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 F开发者_JS百科ramework 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)
You're looking for the SQLite provider for the Entity Framework
Try dotConnect for SQLite.
Only professional version of dotConnect offers EF, linq, etc.
精彩评论