DataContext.Log Property

Definition

Namespace:

System.Data.Linq

Assembly:

System.Data.Linq.dll

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

public:
 property System::IO::TextWriter ^ Log { System::IO::TextWriter ^ get(); void set(System::IO::TextWriter ^ value); };

public System.IO.TextWriter Log { get; set; }

member this.Log : System.IO.TextWriter with get, set

Public Property Log As TextWriter

Property Value

TextWriter

The writer to use for writing the command.

Examples

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);
}

db.Log = Console.Out
Dim custQuery = _
From cust In db.Customers _
Where cust.City = "London" _
Select cust

For Each custObj In custQuery
    Console.WriteLine(custObj.ContactName)
Next

Remarks

Set this property to null to disable command logging.