Using SQLite in Windows 8 Store Apps

re: Using SQLite in Windows 8 Store Apps

Luke Lucas — Sat, 18 May 2013 15:04:24 GMT

Thank you for this tutorial...

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

Thanks

re: Using SQLite in Windows 8 Store Apps

Luciano Miranda — Thu, 25 Apr 2013 16:46:32 GMT

msdn.microsoft.com/.../hh335063.aspx

Perfect!

re: Using SQLite in Windows 8 Store Apps

Luciano Miranda — Wed, 24 Apr 2013 14:33:30 GMT

I wanna share my SQLite database with WF8 and Windows store apps.

How can I do this?

re: Using SQLite in Windows 8 Store Apps

dean severson — Wed, 17 Apr 2013 03:26:55 GMT

Thanks Robert, I will check it out. Thanks for the video- I enjoyed it

re: Using SQLite in Windows 8 Store Apps

Robert Green - MFST — Wed, 17 Apr 2013 00:27:05 GMT

Dean,

Bill Burrows has a tutorial and code that shows how to use VB with SQLite. Check it out at www.myvbprof.com/.../WinRT_SQLite.aspx.

Robert

re: Using SQLite in Windows 8 Store Apps

dean severson — Tue, 16 Apr 2013 23:57:06 GMT

I am doing a VB project trying to use SQLite. I installed and referenced the SQLite Runtime and installed the sqlite-net nugget package - it added SQLite.cs and SQLiteAsync.cs in my project, but I can't get it to show up as useable .

Is there something special I need to do to add a .cs class into my VB project - I thought we could use them together. So when I try to do something like dim db = new SQLite.SQLiteConnection my project says there is no SQLite. Any suggestions? Thanks.

re: Using SQLite in Windows 8 Store Apps

Jay — Sat, 30 Mar 2013 00:57:09 GMT

An exception of type 'System.DllNotFoundException' occurred in SQLiteDemo.exe but was not handled in user code

Additional information: Unable to load DLL 'sqlite3': The specified module could not be found. (Exception from HRESULT: 0x8007007E)

If there is a handler for this exception, the program may be safely continued.

re: Using SQLite in Windows 8 Store Apps

Prakul — Tue, 19 Mar 2013 22:13:55 GMT

On Launching the app this error was prompted :

Windows was unable to communicate with the target application.This usually indicates that the target application's process aborted. More information may be available in the Debug pane of the Output window (Debug->Windows->Output'.

How to resolve this problem?

re: Using SQLite in Windows 8 Store Apps

Allan Leven — Thu, 07 Mar 2013 18:19:10 GMT

Thanks Robert.. the example worked perfectly :)

stupid question: I'm just getting going to try a develop some store apps... is the purpose of using SqlLite so that the app will run on mobile devices? I guess so as I'm thinking that any software program that is connecting to a data store using web services would need it's own local database... and if the person downloads it from the Windows store onto their mobile device that they would need a local DB

am I correct in this thinking?

Allan

re: Using SQLite in Windows 8 Store Apps

jjackson12172 — Thu, 28 Feb 2013 04:46:46 GMT

Mr.Green,

.Max(); always returns zero, thus a never ending update of an existing Customer. Should remove the GetNewCustomerId() method and add attribute to Models.Customer to AutoIncrement I.E.

[SQLite.PrimaryKey, SQLite.AutoIncrement] After doing so you, this will enable to add a new Customer.

FYI - James