Just a small tip. In case you need to see what is happening in you SQL Server such as I/O, Expensive Queries, resource waits etc you can use the Activity Monitor in SQL Server Management Studio:
This has helped me finding if there are problem within my database and possible areas, functionalities which may slow down the database.
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.
- 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
- You Visual Studio version
- Your Visual Studio target CPU 32bit or 64bit
- Your .NET version which you wish to use
- Install the setup bundle
- Make sure to enable Visual Studio integration and GAC registration during installation.
- Once installed open Visual Studio and Server Explorer
- From here you should see a new data source named System.Data.SQLite Database File when you create a new connection
- In the next windows select your SQLite database file and press OK.
- After this your should have a valid connection to your SQLite database file
- Next create a new Visual Studio Project.
- Add new Nuget Packages
- Entity Framework
- System.Data.SQLite (x86/x64)
- You could build your project at this stage.
- 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: