LINQ to SQL : New method DataContext.GetCommand()

  • Article

LINQ to SQL we can read the generated T_SQL query using DataContext.Log or SQLQueryVisualizer. But If you are working with WebProject the Log property not very much convenient as you have to use TextWriter to dump the generated T-SQL query.

 

In Orcas Beta 1 we had DataContext.GetQueryText which used to give us the generated T-SQL now we do not have this from Visual Studio 2008 Beta 2. I have mentioned about this change in one of my earlier Blog post. The implementation is here,

 

TextBox1.Text = db.GetCommand(query).CommandText;

 

Now this will give you the DataContext generated T-SQL query.

 

Namoskar!!!