How to read a sqlite database in windows phone app?

Question

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

Asfend Yar · Answer

First you will install a sqlite package install it from nuget package manager

Carmelo La Monica · Answer

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 Moore · Answer

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 modi · Answer

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 Pall · Answer

This will help you.. http://www.codeguru.com/csharp/.net/wp7/using-sqlite-in-your-windows-phone-application.htm