SQLite Entity Data Model (EDMX) with Entity Framework – Guide

This was a bit tricky for me but these are the steps I took for Visual Studio 2013 Community Edition. Notice that the order is important, especially you should not create the Visual Studio project before the SQLite conenction in Server Explorer is established. For some reason existing VS project wont’t recognize the connection, well at least in my environement.

  1. Download the proper SQLite setup bundle based on your criteria in your environment: http://system.data.sqlite.org/index.html/doc/trunk/www/downloads.wiki
    1. You Visual Studio version
    2. Your Visual Studio target CPU 32bit or 64bit
    3. Your .NET version which you wish to use
  2. Install the setup bundle
    1. Make sure to enable Visual Studio integration and GAC registration during installation.
  3. Once installed open Visual Studio and Server Explorer
  4. From here you should see a new data source named System.Data.SQLite Database File when you create a new connection
  5. In the next windows select your SQLite database file and press OK.
  6. After this your should have a valid connection to your SQLite database file
  7. Next create a new Visual Studio Project.
  8. Add new Nuget Packages
    1. Entity Framework
    2. System.Data.SQLite (x86/x64)
  9. You could build your project at this stage.
  10. After all these steps your should be able to generate an Entity Data Model on your SQLite database based on the Server Explorer connection

 

Other sources of information:

http://erikej.blogspot.fi/2014/11/using-sqlite-with-entity-framework-6.html

https://visualstudiogallery.msdn.microsoft.com/0e313dfd-be80-4afb-b5e9-6e74d369f7a1

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s