How do I view SQL generated statement for Update, Delete and Insert with Entity Framework?

Question

For select it is easy and the solution is here

How do I view the SQL generated by the Entity Framework?

But what about Update, Delete and Insert?

I'm using EF version 4.

look at http://visualstudiomagazine.com/blogs/tool-tracker/2011/11/seeing-the-sql.aspx — COLD TOLD, Oct 01 '14 at 16:15

score 0 · Answer 1 · answered Oct 01 '14 at 16:23

0

run SQL server profiler and watch the queries executed, that should do it

answered Oct 01 '14 at 16:23

Federico Ponte

91
1
3

score 0 · Answer 2 · edited May 23 '17 at 11:57

SQL profiler is an option (and you can luckily use "Application Name" "EntityFramework" (or similar that might not be exactly it) to target EF queries.

In addition to SQL profiler, here's an article from Julie Lerman (one of the leading EF peoples): http://msdn.microsoft.com/en-us/magazine/gg490349.aspx

EDIT:

also here are a few other options in this SO question: How do I view the SQL generated by the Entity Framework?

How do I view SQL generated statement for Update, Delete and Insert with Entity Framework?

2 Answers2