In this post, a Data access layer is implemented using the repository pattern together with entity Framework 6 and SQLite as a database. The post continues on from Getting started, using SQLite with .NET
UPDATE 02.03.2014: Using the new SQLite version 22.214.171.124 now with the SQLite provider. The xml app configuration needs to be changed due to this. Updated all other NuGet packages as well.
UPDATE 02.07.2014: Using the new SQLite version 126.96.36.199 now with the SQLite provider. The xml app configuration needs to be changed due to this. Updated all other NuGet packages as well.
A SQLite database can be created using the Firefox addon.
Application data can then be added directly using this tool:
The .sqlite file is added to the project and ‘copied if newer’ when built.
OLD no longer required, but still works
The required NuGet packages need to be added. (At present…