Windows Phone Local database

Question

I want to built a data file based database for Windows Phone database and use it to store the following object of class.

public class employee()
{
   public int EmployeeNumber{get;set;}
   public string EmployeeFirstName{get;set;}
   public string EmployeeLastName{get;set;}
}

VTC: A simple search provides a detailed article on how to store data in a local relational database: https://msdn.microsoft.com/en-us/library/windows/apps/hh202860(v=vs.105).aspx — Rich Turner, Jan 19 '16 at 18:39

score 0 · Answer 1 · answered Jan 21 '16 at 14:47

0

I think this Tutorial will Help you. http://social.technet.microsoft.com/wiki/contents/articles/18204.how-to-use-sqlite-with-a-windows-phone-8-application.aspx

answered Jan 21 '16 at 14:47

TheOliver

120
4

An exception of type 'System.DllNotFoundException' occurred in SqlLiteDemo.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) – Vaibhav Patil Jan 22 '16 at 16:48
I follow the above link but getting this error please help and i am trying the sql lite connection from past 10 days and getting problem – Vaibhav Patil Jan 22 '16 at 16:49

score 0 · Answer 2 · answered Oct 06 '16 at 21:57

I am thinking that you may try to make a database with codefirst... Codefirst is a new way to create database from code but you need to make a datacontext first. See this example for windows phone 7 using sql ce https://code.msdn.microsoft.com/windowsapps/Database-in-Windows-Phone-7-d69c13c9/sourcecode?fileId=65025&pathId=2036637683

Windows Phone Local database

2 Answers2