Intersoft Community - Lounge - Using Sqlite in WinRT App

Using Sqlite in WinRT App

yudi — Thu, 02 Oct 2014 04:37:27 GMT

I didn't experience any difficulty while testing Crosslight 2 Update 5 on the sample provided by Jan Eeckhout. I just simply add the new assembly files (of Crosslight 2 Update 5) into the Packages folder; clean the solution; and re-build.

Could you please provide me with information about step-by-step guide to reproduce the problem?

Using Sqlite in WinRT App

devincroud — Wed, 01 Oct 2014 21:31:32 GMT

Yudi,

I have it working in iOS and Android now but when I try to add the refrences of .95 to Windows Phone I get the following Error:

A reference to a higher version or incompatible assembly cannot be added to the project.

If I add old version, it adds them correctly but does not communicate correctly.

Using Sqlite in WinRT App

yudi — Mon, 29 Sep 2014 04:07:47 GMT

The hotfix for WinRT SQLite will be included in September hotfix. I have tested the nightly build version using the sample project provided by Jan Eeckhout, CrosslightApp2.zip (attached on his post: September 2, 2014) and found that the reported problem is no longer persist.

You will need to apply Crosslight 2 Update 5 (which will be released in the next couple of days) and add following line in InitializeServices method of AppInitializer class from the WinRT project.

public void InitializeServices(IApplicationHost appHost)
{
    ...
    Application.PreserveAssembly((typeof(Intersoft.Crosslight.Data.SQLite.ServiceInitializer).GetObjectTypeInfo().Assembly));
}

Hope this help.

Using Sqlite in WinRT App

devincroud — Fri, 26 Sep 2014 08:16:37 GMT

Did you ever get an answer? I'm having the same issue with Android now.

Using Sqlite in WinRT App

yudi — Wed, 03 Sep 2014 02:11:35 GMT

Thank you very much for the attached sample solution. It really helps to reproduce the problem in my local end.

This has been forwarded to Crosslight development team to be investigated further. I will keep this thread updated with any news I heard from the team regarding the reported problem.

Using Sqlite in WinRT App

Jeankie — Tue, 02 Sep 2014 10:13:01 GMT

Hi all,

I've recently started a trial of crosslight mobile studio for a proof of concept.

What i'm trying to do is creating a simple Windows 8.1 app with local database access using SQLite. But i'm having some trouble with the SQLite part :)

I have 2 projects, "App.Core" and "App.WinRT".

In the core project I've made a reference with the following assemblies:

.NET
Intersoft.AppFramework
Intersoft.Crosslight
Intersoft.Crosslight.Data
Intersoft.Crosslight.Data.ComponentModel
Intersoft.Crosslight.Data.SQLite
Several Nuget packages to get this project to build (Some Microsoft Bcl packages.

In the WinRT project I've made references to same intersoft assemblies. I also made a reference to the Intersoft.Crosslight.Data.SQLite.WinRT assembly (which is the platform specific assembly) and an SDK extension package called SQLite for Windows Runtime (Windows 8.1)

In the AppService class constructor in the Core project I've added some Appsettings and a SQLiteService.

AppSettings settings = new AppSettings();

settings.RequiresInternetConnection = false;

settings.LocalDatabaseName = "database.db3";

settings.LocalDatabaseLocation = LocalFolderKind.Data;

settings.DataSynchronizationMode = DataSynchronizationMode.LoadPartial;

this.GetService<ITypeResolverService>().Register(typeof(CrosslightAppAppService).Assembly);

//Container.Current.RegisterInstance(settings);

Container.Current.Register<IEntityContainer>("Default", c => new EntityContainer()).WithLifetimeManager(new ContainerLifetime());

ServiceProvider.AddService<ISQLiteService, SQLiteService>();

In the OnStart method i've added the following lines.

ISQLiteService service = ServiceProvider.GetService<ISQLiteService>();

ISQLiteAsyncConnection connection = service.OpenConnection("database.db3");

These lines throws the following error:

System.Exception: The SQLite platform service is not initialized. Please make sure the Intersoft.Crosslight.Data.SQLite.[platform] is referenced in your project.

at Intersoft.AppFramework.Services.SQLiteService.OpenConnection(String dbName)

at CrosslightApp2.Infrastructure.CrosslightAppAppService.OnStart(StartParameter parameter)

at Intersoft.Crosslight.ApplicationServiceBase.Intersoft.Crosslight.IApplicationService.OnStart(StartParameter parameter)

at Intersoft.Crosslight.WinRT.Application.

I've added a sample solution to this thread. Can someone please tell me what to do in order to create a local SQLite database and access it from the windows RT app.

Thanks!

Kind regards,

Jan