Services
Support
Store
©2015 Intersoft Solutions. All rights reserved.

Using Sqlite in WinRT App

5 replies. Last post: October 2, 2014 4:37 AM by Yudi
Tags :
Post Reply
Jan EeckhoutMember
Posted: September 2, 2014 10:13 AM

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

1 attachment

All Replies

Yudi Member
Posted: September 3, 2014 2:11 AM in response to Jan Eeckhout

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.

Posted: September 26, 2014 8:16 AM in response to Jan Eeckhout
Did you ever get an answer? I'm having the same issue with Android now.
Yudi Member
Posted: September 29, 2014 4:07 AM in response to Ryan Herman

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.

Posted: October 1, 2014 9:31 PM in response to Yudi

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.

Yudi Member
Posted: October 2, 2014 4:37 AM in response to Ryan Herman

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?

Custom VirtualLoadMode
Registration failed Windows Phone Business Templat...
All times are GMT -5. The time now is 4:28 PM.
Previous Next