How to create an Entity Framework model from an existing SQLite database in Visual Studio 2008?
- by splattne
I've installed the System.Data.SQLite ADO.NET Provider from http://sqlite.phxsoftware.com/. I can connect to the database from within Visual Studio, I can open table schemas, views etc.
I'd like to use an existing SQLite database to create an Entity Framework model in Visual Studio 2008.
When I try to create a new ADO.NET Entity Data Model (.edmx) file using the wizard, the existing SQLite connection is not in the list though. Also, it's not possible to create a SQLite connection because there is no provider for SQLite. It only lists SQL Server, SQL Server file and SQL Server Compact 3.5.
Any idea how to solve this problem?