How to debug inserts with LINQ to Entities

I have come across this, which is a visualliser for LINQ to Entities which can be used in visual studio,

http://www.thinqlinq.com/Post.aspx/Title/LINQ-to-Entity-Visualizer#close=1

The only problem is that it debugs LINQ st开发者_开发技巧atements. I am doing an insert statement, is there any way to see what SQL the LINQ to Entities engine is going to execute when doing an insert?

Thanks.

---

You could use SQL Profiler to capture the actual TSQL sent to SQL Server

---

+1 to Mitch for SQL Profiler.

If not using SQL Server, you can use this Entity Framework Tracing Provider.

---

You should be able to see the query in the debugger.

DataContext db = new DataContext();
var myQuery = from t in db.Tables
select t;

The myQuery will hold your query until it is run. This will work for selects.

Alternatively you could:

db.Log = Console.Out;

Should log all the calls to your Datacontext

A reference can be found here http://msdn.microsoft.com/en-us/library/bb386961(VS.100).aspx