tags:

views:

273

answers:

2
+2  Q: 

Entity Framework Generated SQL

Is it possible to output the SQL generated by the Entity Framework on a global level and not on a query by query basis? I'm looking to just dump it all somewhere so I can review it.

If that is not possible, how do I view the SQL being generated for updates and inserts?

+2  A: 

The SQL Server Profiler will allow you to view the commands that are being executed on the server while the application is running.

Another free tool for profiling SQL Server 2005 Express here.

UPDATE

Another method to see what is being generated by LINQ is the Log property of the DataContext.

It is a TextWriter that should be easy to save the contents to a file or redirect to Console.Out.

MSDN Info for Log property

Jason Miesionczek  2009-08-10 19:40:58
Ah.. got me by 3 seconds. =)
StingyJack  2009-08-10 19:41:22
Ideally, I'd like to output to a file or view the SQL in Visual Studio and avoid having to run profiler or use an additional tool.
Matthew  2009-08-10 20:03:32
LINQ to SQL and Entity Framework are not the same. Entity Framework context does not have this option.
Matthew  2009-08-11 14:40:53
Nice, never knew that about L2S, just another reason I'm glad I went with it over EF :)
Allen  2009-08-12 13:24:00
+2  A: 

you want LinqPad, here are some videos that show you how to use it

Allen  2009-08-10 19:42:38
LINQPad is great for selects, but I need this for all transactions (i.e. select, insert, update, delete) – Matthew 5 mins ago
Matthew  2009-08-10 20:02:54
LINQPad does all of those as well, just checked myself
Allen  2009-08-10 20:21:27
Thank you, I see that now. I was hoping for a different solution but this will work.
Matthew  2009-08-11 15:49:31

related questions

Displaying Flash content in a C# WinForms application
How to get the value of built, encoded ViewState?
Unhandled Exception Handler in .NET 1.1
How do I connect to a database and loop over a recordset in C#?
How do I most elegantly express left join with aggregate SQL as LINQ query
Get a new object instance from a Type in C#
.NET Testing Framework Advice
Automatically update version number
What is the difference between an int and an Integer in Java/C#?
How to write to Web.Config in Medium Trust ?
WinForms ComboBox data binding gotcha
How do you sort a C# dictionary by value?
Adding Scripting functionality to .NET applications
Floating Point Number parsing: Is there a Catch All algorithm?
How do I print an HTML document from a web service?
Decoding T-SQL CAST in C#/VB.net
Anatomy of a "Memory Leak"
How do I get a distinct, ordered list of names from a DataTable using Linq
Reliable Timer in a Console Application
How do I fill a DataSet or a DataTable from a LINQ query resultset ?
What's the difference between Math.Floor() and Math.Truncate() in .NET?
How do I calculate relative time?
How do I calculate someone's age in C#?
Are there any conversion tools for porting Visual J# code to C#?
When setting a form's opacity should I use a decimal or double?