How to view LINQ Generated SQL statements?

by

You can always attach something to the .Log property of your DataContext. That will show all the SQL commands as they are sent.

I do this in my base for data access objects and output it to the Visual Studio debug console. As the objects create their DataContext I check it see if its debug and attach a TextWritter helper class like this:

dbDataContext _dB = new dbDataContext();
_dB.CommandTimeout = 5000;

#if DEBUG
    _dB.Log = new DebugTextWriter();
#endif

Here is the helper object for output to the debug console:

//utility class for output of TextWriter for the Visual Sudio Debug window
class DebugTextWriter : System.IO.TextWriter
{
    public override void Write(char[] buffer, int index, int count)
    {
        System.Diagnostics.Debug.Write(new String(buffer, index, count));
    }

    public override void Write(string value)
    {
        System.Diagnostics.Debug.Write(value);
    }

    public override Encoding Encoding
    {
        get { return System.Text.Encoding.Default; }
    }
}

More Related Contents:

  1. Convert this sql command to c# linq
  2. LINQ: Distinct values
  3. Entity Framework: There is already an open DataReader associated with this Command
  4. LINQ-to-SQL vs stored procedures? [closed]
  5. Entity framework linq query Include() multiple children entities
  6. How can I do an OrderBy with a dynamic string parameter?
  7. LINQ to Entities does not recognize the method ‘System.String Format(System.String, System.Object, System.Object)’
  8. How to view LINQ Generated SQL statements?
  9. LINQ across multiple databases
  10. Convert String to Int in EF 4.0
  11. System.LINQ.Dynamic: Select(” new (…)”) into a List (or any other enumerable collection of )
  12. LINQ Join with Multiple Conditions in On Clause
  13. Standard Deviation in LINQ
  14. How To Project a Line Number Into Linq Query Results
  15. Calculate difference from previous item with LINQ
  16. LINQ with SQLite (linqtosql)
  17. Entity Framework – “Unable to create a constant value of type ‘Closure type’…” error
  18. How to create a dynamic LINQ join extension method
  19. EF 4: Removing child object from collection does not delete it – why?
  20. How to dynamically add OR operator to WHERE clause in LINQ
  21. Greater Than Condition in Linq Join
  22. How do I write this cross apply query in LINQ-to-SQL?
  23. Can’t make GroupJoin work. NavigationExpandingExpressionVisitor exception
  24. LINQ Include vs Join. Are they equivalent?
  25. Tradeoffs using NHibernate 3.0 QueryOver or LINQ provider
  26. If condition in LINQ Where clause
  27. Point connectionstring in dbml to app.config
  28. How to implement Unit of Work that works with EF and NHibernate
  29. Building Dynamic LINQ Queries based on Combobox Value
  30. NHibernate vs LINQ to SQL

Leave a Comment