Tutorial :VS2010/EntityFramework - Is it possible to execute generated sql for a Sqlite database?



Question:

VS2010/EntityFramework - Is it possible to execute generated sql for a Sqlite database? (like you can for SQL Server).

When I try to do this I only seem to get SQL Server type options re which database to execute the SQL against (even though my Entity Framework design was based on the initial/successful upload from a SQLite database)

EDIT: I can create an entity model ok from import from a sqlite database, BUT when I try to generate SQL code it doesn't seem to be standard sql (perhaps it is Sql Server syntax or something). And if I try to run the sql it wants to connect me to a sql server database (not the connection I had to the sqlite database I used to create the entity framework model)


Solution:1

You're looking for the SQLite provider for the Entity Framework


Solution:2

Try dotConnect for SQLite.


Solution:3

Only professional version of dotConnect offers EF, linq, etc.


Note:If u also have question or solution just comment us below or mail us on toontricks1994@gmail.com
Previous
Next Post »