On Sun, Sep 8, 2013 at 2:36 AM, Steve Palmer <swp...@gmail.com> wrote:
> Hi! > > Has anybody successfully used System.Data.SQLite.Linq in their project and > can perhaps help me with this? > > Even after including this DLL in my project reference, it is apparent that > Linq is calling the wrong provider when building the appropriate SQL > statements. It is throwing an exception in SQLiteCommand with the following > statement: > > INSERT INTO [Inbox] > ([Sender], [Subject], [Body], [Date], [ConversationID], > [RemoteID], [ReplyTo]) > VALUES > (@p0, @p1, @p2, @p3, @p4, @p5, @p6) > > SELECT CONVERT(Int,SCOPE_IDENTITY()) AS [value] > > The SCOPE_IDENTITY is not valid in SQLite. http://stackoverflow.com/questions/304543/does-sqlite-support-scope-identity -- -- -- --Ô¿Ô-- K e V i N _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users