How to read a sqlite database in windows phone app?

dinesh joshi

14y5.3kC#

Hi,

I want to use a sqlite database in my app but don't know how to use this

I want to Know

1. Where to place this sqlite Db in my app i.e the location /Folder to place this DataBase.

2. How to use this in my app i.e How to read the data fron this sqlite .

Please help me to solve this and If any sample for the same

Thanks & Regards

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Asfend Yar10y ago
First you will install a sqlite package install it from nuget package manager
Carmelo La Monica11y ago
Hy Dinesh,

i wrote some months ago this two samples, i hope it can help you.

https://code.msdn.microsoft.com/vstudio/Parte-uno-Sqlite-in-182c5875
https://code.msdn.microsoft.com/vstudio/Parte-due-Sqlite-in-47e31aab
Bye
Amelie Moore11y ago
Dear Dinesh Joshi,

I think SQLite Viewer Program will be helpful for read SQLite database. This software is capable to read every SQLite format for example .db, .db3, .sqlite, .sqlite3 etc. Just download this utility free of cost for read SQLite files but if you want to export SQLite database then upgrade to pro.

Note: The tool works with Windows Operating System if you are using other OS then first copy SQLite database into Windows Computer after that install the tool for preview SQLite files.
ankit modi13y ago
hello

Please reffere bellow link.

http://dotnetslackers.com/articles/silverlight/Windows-Phone-7-Native-Database-Programming-via-Sqlite-Client-for-Windows-Phone.aspx

you got all answer for this link.And also this link contain a sample so you can understand easily
Shuvro Pall13y ago
This will help you..
http://www.codeguru.com/csharp/.net/wp7/using-sqlite-in-your-windows-phone-application.htm