First, when using the ToTraceString method we need an open connection to the database, otherwise we will raise an exception.
Its use is very simple. Here an example:
using (MyEntities ctx= new MyEntities()) {
var strSql = "SELECT VALUE t FROM MyEntities.Employees AS t";
var myQuery = ctx.CreateQuery(strSql);
ctx.Connection.Open();
Console.WriteLine(myQuery.ToTraceString());
Console.ReadLine();
}
The output will be something like:
SELECT
[it].[FirstName] AS [FirstName],
[it].[LastName] AS [LastName],
[it].[Age] AS [Age]
FROM [dbo].[Employees] AS [it]
One important thing about ToTraceString method is that it doesn’t execute the query but it's only output the statement to be executed.
Nessun commento:
Posta un commento
Your message will be verified prior to publication. Thanks for your contribution.