Intersoft Community - Sqlite

Problem saving object in sqlite

gabrielswapi — Wed, 26 Aug 2015 21:06:36 GMT

Hello,

I created a model "PessoaModel," and I tried to save the sqlite, but tou some problems, the first would think that I am unable to save my data in sqlite. The second is that I'm not getting in my "PessoaListViewModel.cs" use "this.SourceItems = conexao.Connection () Table <PessoaModel> () ToListAsync ();.."

Problem Sqlite

gabrielswapi — Tue, 25 Aug 2015 20:18:38 GMT

Hello,

I am creating a test project, and would like to study more about sqlite, I am unable to import into my project ".Core" the "CrossLith.Data" as could solve this problem and I wonder if Voes has some sample project using sQLite so I can base myself in it.

How-to: Create Crosslight Business Apps with Local Data Storage (SQLite)

martin@intersoftpt.com — Mon, 16 Mar 2015 05:52:32 GMT

This how-to topic will show you in-depth how to create apps that use SQLite as its local data storage using Crosslight Business Template. You will learn how to configure SQLite for the first time, setting up the domain model through Intersoft Entity Designer and add some simple settings and code to enable SQLite. Learn more.

You can download the available sample code from our Git server here.

Regards,
Martin Lie
Account Manager

How to obtain the local storage and activator service?

MiseryChen — Wed, 17 Dec 2014 02:39:57 GMT

Hi support:

in project, I want to use local data . I have tried your mothed which is publiced online:

for the following code:

ILocalStorageService storageService = this.GetService<ILocalStorageService>();

IActivatorService activatorService = this.GetService<IActivatorService>();

var factory = activatorService.CreateInstance<System.Func<string, ISQLiteConnection>>();

the underlined parts is wrong in my project, error info is

Could not resolve type: activatorService.CreateInstance<global::System.Func<string, global::Intersoft.Crosslight.Data.SQLite.ISQLiteConnection>>

How to slove this problme?

Thanks!

Crosslight - Local Data Synchronization

kibork — Tue, 16 Dec 2014 10:29:23 GMT

Hello,

it try to add the Local Data Synchronization to the 'startup Business App' from Crosslight Project Wizard. I can login and so on... When I start the app it synchronizes with the .mdf database. 42 entities will fetch.

Now my current Problem.

When I go in menu to the Inventory (Page3), I get this Error:

"Unable to perform data operation due to an error: Object reference not set to an instance of an object."

Error occurs after this part(ItemListViewModel):

public DateTime? LastSync {            get {                return _lastSync;            }
            set {
                if (_lastSync != value) {
                    _lastSync = value;
                    OnPropertyChanged("LastUpdate");
                    OnPropertyChanged("UpdatedText");
                }
            }
        }

Wich object and where? o.O

Best regards

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