Get SQL query from LINQ to SQL?

by

In debugger hover mouse over commiteeMember variable – it will show generated SQL query:

enter image description here

This is what ToString() returns for query. You can get same generated SQL query manually by calling ToString:

string sql = committeeMember.ToString();

This overridden method internally calls ObjectQuery.ToTraceString() which returns commands that will run on data source.

Also you can use SQL Profiler or Entity Framework Profiler to see which SQL query was executed.

More Related Contents:

  1. What is the syntax for an inner join in LINQ to SQL?
  2. Random row from Linq to Sql
  3. LINQ – Left Join, Group By, and Count
  4. Making Entity Class Closed for Changes
  5. To return IQueryable or not return IQueryable [closed]
  6. How to compare only Date without Time in DateTime types in Linq to SQL with Entity Framework?
  7. Updating an ObservableCollection in a separate thread
  8. Metadata were not loaded using MetadataType
  9. Am I misunderstanding LINQ to SQL .AsEnumerable()?
  10. Entity Framework/Linq to SQL: Skip & Take
  11. LINQ Where Ignore Accentuation and Case
  12. Operation could destabilize the runtime?
  13. How to select only the records with the highest date in LINQ
  14. DISTINCT() and ORDERBY issue
  15. Polymorphism: Is ORM entity a Domain Entity or Data Entity?
  16. Max or Default?
  17. How do I do a left outer join with Dynamic Linq?
  18. Best way to update LINQ to SQL classes after database schema change
  19. Get sum of two columns in one LINQ query
  20. Last and LastOrDefault not supported
  21. IDENTITY INSERT and LINQ to SQL
  22. Linq where column == (null reference) not the same as column == null
  23. Windows Forms Splash Screen – Show a form while loading main form
  24. AppSettings get value from .config file
  25. IEqualityComparer that uses ReferenceEquals
  26. How to catch ALL exceptions/crashes in a .NET app [duplicate]
  27. How DataReader works?
  28. How do I programmatically save an image from a URL?
  29. smtpclient ” failure sending mail”
  30. Winform form closed event

Leave a Comment