Click to Rate and Give Feedback
MSDN
MSDN Library
.NET Development
.NET Framework
DataContext Class
 Log Property
.NET Framework Class Library
DataContext..::.Log Property

Specifies the destination to write the SQL query or command.

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

Visual Basic (Declaration)
Public Property Log As TextWriter
Visual Basic (Usage)
Dim instance As DataContext
Dim value As TextWriter

value = instance.Log

instance.Log = value
C#
public TextWriter Log { get; set; }
Visual C++
public:
property TextWriter^ Log {
    TextWriter^ get ();
    void set (TextWriter^ value);
}
JScript
public function get Log () : TextWriter
public function set Log (value : TextWriter)

Property Value

Type: System.IO..::.TextWriter

The TextReader to use for writing the command.

Set this property to nullNothingnullptra null reference (Nothing in Visual Basic) to disable command logging.

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

Visual Basic
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

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

Windows Vista, Windows XP SP2, Windows Server 2003

The .NET Framework and .NET Compact Framework do not support all versions of every platform. For a list of the supported versions, see .NET Framework System Requirements.

.NET Framework

Supported in: 3.5
Tags What's this?: Add a tag
Community Content   What is Community Content?
Add new content      
Processing
© 2008 Microsoft Corporation. All rights reserved. Terms of Use  |  Trademarks  |  Privacy Statement
Page view tracker