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

Question

Hi,

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)

Answer 1

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

Answer 2

Try dotConnect for SQLite.