CSharp - Get SQL query via DataContext Log

Introduction

DataContext Log can output the equivalent SQL statement of an IQueryable<T> query prior to the parameter substitution.

You can then run the sql against the database to see the exact data coming back.

Northwind db = new Northwind(@"Data Source=.\SQLEXPRESS;Initial Catalog=Northwind");  
db.Log = Console.Out;  
IQueryable<Order> orders = from c in db.Customers  
                           from o in c.Orders  
                           where c.Country == "USA" && c.Region == "WA"  
                           select o;  
  
foreach(Order item in orders)  
  Console.WriteLine("{0} - {1} - {2}", item.OrderDate, item.OrderID, item.ShipName);  

Related Topic

• Query Expressions
• Create Anonymous Types
• Collection Initialization on List
• Returning IEnumerable<T>, Yielding, and Deferred Queries
• Returning a List So the Query Is Executed Immediately and the Results Are Cached
• Using One of the Func Delegate Declarations
• Query with Intentional Exception Deferred Until Enumeration
• Use the var Keyword When Confused
• XML Query Using LINQ to XML
• Database Query Using LINQ to SQL
• Converting an Array of Strings to Integers and Sorting It
• Create extension for string to convert string to double and bool
• LINQ to Objects Query
• Query Results Changing Between Enumerations

• Previous
• Next