DataContext.Log Property

 
System_CAPS_noteNote

The .NET API Reference documentation has a new home. Visit the .NET API Browser on docs.microsoft.com to see the new experience.

Gets or sets the destination to write the SQL query or command.

Namespace:   System.Data.Linq
Assembly:  System.Data.Linq (in System.Data.Linq.dll)

public TextWriter Log { get; set; }

Property Value

Type: System.IO.TextWriter

The TextReader to use for writing the command.

Set this property to null to disable command logging.

The following example displays generated SQL in the console window before it displays the results of the query.

db.Log = Console.Out;
var custQuery =
    from cust in db.Customers
    where cust.City == "London"
    select cust;

foreach (var custObj in custQuery)
{
    Console.WriteLine(custObj.ContactName);
}

.NET Framework
Available since 3.5
Windows Phone Silverlight
Available since 7.1
Return to top
Show: