SQLite Database for Windows 8 App : Adding existing SQLite DB file

Hi Guys ...

This Post is about adding an existing SQLite database file to the Windows Metro App project.
As I think "using SQLite" is the best way to create local database for Windows Rt applications.Actually SQLite is very easy to learn but I really think if Microsoft SQL Server CE supports windows rt applications it will more fun. .Isnt it ?. :)

• The first step is to copy your database file in to the Visual Studio project and, go to the Properties window of the DB file, set the Build action to Content.

• Add following code to the MainPage.cs

 private async void UpDatabase()  
 {  
   bool isDatabaseExisting = false;  
   try  
   {  
     StorageFile storageFile = await ApplicationData.Current.LocalFolder.GetFileAsync("appdb.db");  
     isDatabaseExisting = true;  
   }  
   catch  
   {  
     isDatabaseExisting = false;  
   }  
   if (!isDatabaseExisting)  
   {  
     StorageFile databaseFile = await Package.Current.InstalledLocation.GetFileAsync("appdb.db");  
     await databaseFile.CopyAsync(ApplicationData.Current.LocalFolder);  
   }  
 }  



• Call this method when start up the application .You can call the method inside the MainPage () 

 public MainPage()  
     {  
       this.InitializeComponent();  
       UpDatabase();  
     }  

What is Happening when the code run?? 

Check if the file already exists or not. If it doesn’t exist, we get a reference to the file embedded in the Visual Studio project (called appdb.db) and then we copy it in the local storage. This way the file is copied in the root of the local storage

Hope This will help You Guys ....
ThankYou!!!!!!!!!!

Facebook Page
Project.net Group