ADO.NET see query that will be sent to SQL server before submitting changes

Question

Lets say I have the code

var Db = new MyEntities();

Random r = new Random();

// select a random customer out of the first 5
var customer = Db.Customers.OrderBy(c=>c.Id).Skip(r.Next(0, 5)).Take(1); 

foreach (var c in customer)
{
    c.WonPrice = true;
}


// How can I see here before saving the changes in order to see
// the query that will be sent to SQL server?
Db.SaveChanges();

When SaveChanges() is called how can I see in code the SQL statement that is generated?

May be this is helpful: http://stackoverflow.com/a/18237349/961113 — Habib, Feb 21 '14 at 16:19

score 2 · Accepted Answer · answered Feb 21 '14 at 16:21

If this is LINQ-to-SQL, then you can attach a TextWriter to Db.Log: then everything you do via Db will be recorded in there. Alternatively, you could use a tool like mini-profiler and just give MyEntities a wrapped connection, i.e.

public static DbConnection GetOpenConnection()
{
    // A SqlConnection, SqliteConnection ... or whatever
    var cnn = CreateRealConnection();

    // wrap the connection with a profiling connection that tracks timings 
    return new StackExchange.Profiling.Data.ProfiledDbConnection(cnn,
                                                MiniProfiler.Current);
}

...
using(var Db = new MyEntities(GetOpenConnection()))
{
    ...
}

ADO.NET see query that will be sent to SQL server before submitting changes

1 Answers1