Click to Rate and Give Feedback
MSDN
MSDN Library
.NET Development
.NET Framework 3.5
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.

TopicLocation
How to: Display Generated SQLLINQ to SQL

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 RSS  Annotations
Error in documentation      Trifu   |   Edit   |  


"Property ValueType: System.IO..::.TextWriter

The TextReader to use for writing the command. "

should be "The TextWriter to use ..."

Tags What's this?: Add a tag
Flag as ContentBug
Processing
© 2008 Microsoft Corporation. All rights reserved. Terms of Use  |  Trademarks  |  Privacy Statement
Page view tracker