LinqConnect Documentation
Logging

Use the Log property of the DataContext class to output SQL statements generated by LinqConnect. Assign any TextWriter descendant to it, and SQL statement will be logged by this TextWriter. For example you may assign Console.Out or Debug.Out TextWriter to it, or StreamWriter that writes to the file.

     CrmDemoContext.CrmDemoDataContext db = new CrmDemoContext.CrmDemoDataContext();
     db.Log = Console.Out;
     
     var query = from product in db.Products
              select new
              {
                Name = product.ProductName,
                Price = product.Price,
                Category = product.ProductCategory.CategoryName
              };
      
      foreach (CrmDemoContext.Product product in query)
      {
         Console.WriteLine(product.ProductName);      
      }
     Dim db As New CrmDemoContext.CrmDemoDataContext()
     db.Log = Console.Out
     
     Dim query = From product in db.Products
              Select New
              {
                Name = product.ProductName,
                Price = product.Price,
                Category = product.ProductCategory.CategoryName
              }
      
      For Each CrmDemoContext.Product In query
        Console.WriteLine(product.ProductName)
      Next

The console output will contain the following:
SELECT t1."ProductName" AS "ProductName", t1."Price", t2."CategoryName" AS "CategoryName"
FROM CRM_DEMO."Products" t1
LEFT OUTER JOIN CRM_DEMO."ProductCategories" t2 ON t1."CategoryID" = t2."CategoryID"

Borland UK CodeGear Division Alpha Bank ... Orderbase Consulting Gmbh