Capture SQL Generated from Linq
Posted: Fri 06 Feb 2015 23:07
Is there a way to capture the SQL generated from LINQ queries short of capturing traffic sent to the RDBMS? This would be useful for learning LINQ by experimentation.
hello,
Yes, you can retrieve the text of the last executed SQL query, that was generated according to the LINQ query. For this, you can execute the following code:
type
TDataContextUtil = class(TDataContext)
end;
.....
TDataContextUtil(EntityContext1).QueryCompiler.LastQuery.SQL;
.....
You can samples in the Demo application, in the 'Working with LINQ queries' branch.