System.Data.SQLite

Hello,

I would like where can i get the SQL statement sent to the SQLITE engine ?

I tried the ToTraceString() method but it always returns me the same select statement !

Thank you

Hi,

You should be able to get the sql command with (query as ObjectQuery).ToTraceString(); [where query is a IQueryable]

Example:

var query = from o in context.Item select o; 

(query as ObjectQuery).ToTraceString() => "SELECT \r\n[Extent1].[ItemId] AS [ItemId]], \r\n[Extent1].[ItemName] AS [ItemName]\r\nFROM [Item] AS [Extent1]"

When you want the queries generated by

context.SaveChanges();

You should take a look @ sqlite3_trace (http://www.sqlite.org/c3ref/profile.html).

( Attached a patch to use sqlite3_trace() }