Re: [sqlite] SQLite with Entity Framework problem

2014-05-06 Thread Joe Mistachkin
Christiano Borchardt wrote: > > My SQL server has a table with a primary key of type smallint which is an > identity column. This is the AUTOINCREMENT equivalent on SQLite. However > AUTOINCREMENT in SQlite only allows the Integer type. > When the entity framework loads the entity for this table

[sqlite] SQLite with Entity Framework problem

2014-05-06 Thread Christiano Borchardt
Hi there, We have a system which uses SQL server as a primary database. We are thinking about replacing the entity framework provider so we can use SQLite in-memory for integration tests. I have done few tests and generally System.Data.SQlite works fine. The only exception I have so far is: My