Using SQLite in Windows Store Apps

Thanks for the video. I have just finished a new app (currently going through submission) called NewHouse. I used Sqlite for the data source. It's fantastic, especially when combined with RoamingStorage for cross-device apps.

Can we create portable class library that refer SQLITE and act as model (MVVM) for both Win8 & WP8 app?

How does this work with all async/await statements ? 

I can see that you are opening/close db each time you take something from it and was wondering how this will work if we will use async/awaits and at some point two different function will try to manipulate on db. 

kind give us your thoughts around that

thanks

M.

Since SQLite.dll is native dll, existing for x32/x64/arm, you have to make/test/publish 3 different versions of your app - for each platform.

Welcome to native hell ;)

Can the SQLLite data be encrypted ?

can I make an invoice to print and reports like pdf with SQLite and can I using a network Metro application with SQLite.
Thansk

Good tool I use for SQLite http://sqliteexpert.com/

Excellent!  This is exactly what I was looking for.  Thanks Robert!

Thanks For This Video

Seriously guys, I kind of remember there is a Server and Tools Division inside Microsoft, which happens to have a product called SQL Server, and something like SQL Express, SQL Embeded, SQL Compact, SQL Whatever. Are they all dead?

Wecarpool.com: That link (http://sqliteexpert.com/) says, "Supported platforms: Windows 2000, XP, Vista, 7." So it doesn't support Windows 8?

Best tool for SQLite:
SQLite Administrator
http://sqliteadmin.orbmu2k.de

(Supported
Win 2000
Win XP
Win Vista)

Had ZERO issues using it with Windows 8.

Hi Guys, any idea why SQLite3.Open(path, out handle) method can not open any file out side ApplicationData.Current\...?
I am trying to unittest my class library which uses sqlite but I want
to keep the data for other tests. (the point is that the ApplicationData.Current will remove after each test because my library is not a user interface). and SQLite3.Open(path, out handle) can not open any file in DocumentsLibrary nor DownloadsFolder.

Thanks in advance

@Clay Shannon: Windows 8 is Windows 7 + RT.

It works on Desktop in Win8 no problem

Yeah, seriously, the presenter is writing an APP to manage his APPS.  Great.  That's a real world example of why someone would need a robust FULLY SUPPORTED RDBMS on a device lol.  Well Robert, here in the real world, where we have apps written that, as an example, would do the following.

1.) Route sheet with over 50 calls per day/per driver handling sales for a major international Energy drink distributor.  That's 70 routes x 50 sales calls/invoices per day.

2.) Sales history for each customer (over 1000 customers per device) for the last 24 months that can be recalled and printed while at the store dealing with the customer

3.) New invoices from the route created that day replicated in real time to the SQL Server at head office

4.) New route sheet for the next day (and 14 day peak into the future for driver planning)

5.) Multiple "Surveys" regarding shelving and presentation for every store on the route.  Data is collected while the driver is at the store and immediately replicated to head office for analysis

6.) Real time "chatting" with the drivers with entire dialogue stored on the LOCAL SQL CE DATABASE.

blah, what a disaster.  Try the above with SQL Lite.

If I/We were in the business of writing 99 cent apps, we would be coding for android or IOS.  We chose MS because we code APPs for businesses, not 18 year old college students.

I am inspired... to code for the android.  Unfortunately, I agreed with the client, and moved them over to an iPhone web based app as I saw (and now confirmed) no use for MS in the device market place.

what a gong show

Hello Robert i'm new to application development this was really nice explanation of sqlite, i got the answers of many doubts i was looking for, however in the MSDN Code Samples provided when i compiled it gave two errors

Error 1 The name 'ex' does not exist in the current context C:\Users\Downloads\New folder\Using SQLite in a Windows Store App\C#\SQLiteDemo\SQLite.cs 722 19 SQLiteDemo

Error 2 The name 'ex' does not exist in the current context C:\Users\Downloads\New folder\Using SQLite in a Windows Store App\C#\SQLiteDemo\SQLite.cs 767 18 SQLiteDemo



is there something that i missed ??

When i try run your Simple SqLite demo application it is getting an exception as displaying 'System.DllNotFoundException' occured, & Unable to load DLL 'sqlite3'
What is Team foundation server, Why i have to integrate with it. When i start your sample app it is asking for Team Foundation server Version control "https://microsoftdpe.tfspreview.com/defaultcollection".
Please help me, Thanks in advance.

Hi Robert,

Thank you for your tutorial...

i am a beginer and i am interested in the development of Winsdows Stores application with MVVM-pattern. I have download your SQLiteDemo and wanted to tested but there is not "start-app". Which template may i select (empty store template)?.

I want to develope some store-application with my own page like login-page.

Thank,

Jibyz

Hi Robert,

i have retried, but i don't receive the information:

and the there was no file added into the Common folder. I just have the StandardStyle.xaml in this folder.

Maybe i do something wrong... please can you help me? I have your tutorial step by step...

Thanks,

Jibyz

@rogreen How can I make relationship?

I used to do that with the entity framework :
public virtual ICollection<KCExample> examples { get; set; }
public virtual KCTrade trade { get; set; }

But it seems to be unsupported... What's the right syntax?

Hi Robert, great video tutorial.

Is it possible to create a Windows Store App using SQLite in Visual Basic? I'm having difficulties with the "Imports.SQLite" statement.

Thanks

@rogreen that's exactly what I needed to get started.

I'm definitely heading in the right direction now.

Thank you for the link and for the great tutorial! 

Thanks for the video Robert!

Is it a good idea to instantiate a new SQLiteConnection each time your interact with the database or could I re-use a single connection over and over again?

Does anyone have a best-practice? Thanks.

Thanks Robert, it is just what I need for my Windows 8 project.

Others had told me to us XML and I was banging my head against the wall. This will let me do exactly what I need for my app.

Thanks again

Dave

Thanks for the video Robert!

Can we create portable class library that refer SQLITE and act as model (MVVM) for both Win8 & WP8 app?

http://msdn.microsoft.com/en-us/magazine/hh335063.aspx

Perfect!

Thank you for this tutorial...

Can someone please tell me from where I can locate the database on my Disk so I can modify it using Mozilla Fire Fox?

Thanks