-->
DDEX provider setup doesn't detect installed VS version DNET-618 Select query with a parameter value that is longer than the size of the column results in an exception, only with firebird.
The information in this post is out of date.
Visit msdn.com/data/ef for the latest information on current and past releases of EF.
Firebird recently announced the RTM of FirebirdClient 2.5. This new release now provides full support for the Entity Framework. To learn more about FirebirdClient 2.5 check out Jiri’s blog at http://blog.vyvojar.cz/jirka/archive/2009/05/22/ann-firebirdclient-2-5-final-released.aspx or access the download page at http://www.firebirdsql.org/index.php?op=files&id=netprovider
Elisa Flasko
Program Manager, Data Programmability
Program Manager, Data Programmability
The System.Data.SQLite DDEX provider does not support Visual Studio 2017. This post describes how to work with SQLite and Entity Framework 6 in Visual Studio 2017, using the 'SQLite Toolbox' DDEX provider for EF6. Notice that this provider only supports the EF 6 Tools, and not other Data Source scenarios, for example Typed DataSets. This requires Visual Studio 2017 15.8 or later.
- Install Toolbox
- Install SQLite in GAC
- Install SQLite EF provider in project
- Run EDM Wizard
Install latest Toolbox
Once per Visual Studio edition (daily build at https://github.com/ErikEJ/SqlCeToolbox/wiki/Release-notes )
Install SQLite in GAC
Once per machine. Download sqlite-netFx46-setup-bundle-x86-2015-1.0.110.0.exe (from https://system.data.sqlite.org/index.html/doc/trunk/www/downloads.wiki)
Select 'Full Installation'
Select: Install the assemblies into the global assembly cache - Install VS designer components
Restart Visual Studio
Verify that the EF6 provider is installed in GAC from the Toolbox 'About' dialog:
If the EF6 provider is not in GAC, this may be due to an invalid entry in machine.config, located in the C:WINDOWSMicrosoft.NETFrameworkv4.0.30319Config folder. The only SQLite related entry should look like this, with this exact version number:
Some users report that adding this to app.config solves some runtime issues.
Install System.Data.Sqlite NuGet package
Install using Package Manager Console or NuGet Manager in each project.
Make sure to install the same version as the tools package above.
Build project!
Packages.config should look like this after install:
App.config should look like this:
Run Entity Data Model Wizard
Add, New Item, Data, ADO.NET Entity Data Model. Choose 'EF Designer from Database' or 'Code First from Database'
Use 'SQLite Provider (Simple for EF6 by ErikEJ)' when creating a connection to your SQLite database file. Enter the full path to your database file in Data Source.
A reader of this wiki post has provided some additional tips here