In Linq to Entities can you convert an IQueryable into a string of SQL?

Question

eg.

var result = myObject.Where(x => x.prop == 5);

string s = result.toSQL();

Result:

s is "SELECT * FROM [myObjects] WHERE prop = 5"

Take a look at http://stackoverflow.com/questions/3980874/get-tracestring-for-your-business-objects-in-the-entity-framework — Eranga, Jul 05 '12 at 11:07

score 8 · Accepted Answer · answered Jul 05 '12 at 11:36

8

If it's IQueryable/ObjectQuery you can use ToTraceString. If it's IDbSet/DbSet you can use ToString directly.

answered Jul 05 '12 at 11:36

cincura.net

score 0 · Answer 2 · answered Jul 20 '17 at 11:51

Using EF 6 I could not get .ToString() to return SQL for something similar to:

   db.Entry(parent)
   .Collection(p => p.Children)
   .Query()
   .Where(c => c.Active)
   .Load();

Then I remembered you can log it to debug output with:

db.Database.Log = (entry) => System.Diagnostics.Debug.WriteLine(entry);

Just set above before loading queries (duh) :)

db here is an instance of some DbContext derived class.

2 Answers2