Hi Gabriel,

You must add the reference to the assemblies first before Import/Using the Crosslight.Data, you can find your assemblies in you Packages folder in your project, i attach your project with complete references

You can try these 2 samples: http://git.intersoftpt.com/projects/CROS-SUPP/repos/sqlite-sample and for more advance: http://git.intersoftpt.com/projects/CROS-SUPP/repos/sqlite-sample-businesstemplate

also you can check our tutorial for SQLLite here: http://developer.intersoftsolutions.com/display/crosslight/Using+Crosslight+SQLite+for+Local+Data+Storage

Hope that'll helps!

hi Arief,

Thank you so much for your help.

  I was reading(http://developer.intersoftsolutions.com/display/crosslight/Using+Crosslight+SQLite+for+Local+Data+Storage), Next came a doubt, which place the SQLiteConnection and Db Property? and where would be the part of the code which creates the tables?

Hi Gabriel

First of all i will show you how to make it the right way (using Crosslight, and Our AppFramework which simplify everythings):

You can check your project in the attachment named Teste which already go through these steps

here is my steps:
1. Add reference to Intersoft.AppFramework in both Android and Core

2. Go to nuget packages and add Bcl.Async (To Use Async and Await )

3. In your Teste.Core/Infrastructure/AppService.cs, register your needed service, and on application start create table if not yet created

4. Don't forget to delete your modelBase.cs and container.cs in your Teste.Core because we will be using the one in AppFramework

5. In your PessoaModel you can add [DataMember] for field that you want to save in local database, [IgnoreDataMember] if you don't want to save to local database, but please remember this is actually not necessary, the most important is only [Primary Key]

6. Now you can Update Delete or Save from anywhere whenever you call LocalDataRepository using IOC Container as you can see in PessaoDetailViewModel

The next method is if you dont want to use our framework which i will explain in your other thread:
http://www.intersoftsolutions.com/Community/Crosslight/Problem-saving-object-in-sqlite/