Intersoft Community - Crosslight - Problem Sqlite

Problem Sqlite

Arief — Thu, 27 Aug 2015 06:35:17 GMT

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/

Problem Sqlite

Arief — Thu, 27 Aug 2015 04:20:35 GMT

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

Problem Sqlite

gabrielswapi — Wed, 26 Aug 2015 13:50:11 GMT

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?

Problem Sqlite

Arief — Wed, 26 Aug 2015 02:53:24 GMT

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!

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.