ADO. NET Entity Framework: SQL statement used to check the latest row

When you use the ADO. NET Entity Framework, when you need to obtain the primary line, the SQL statement of the primary line is used.
You can use the totracestring () method in system. Data. Objects. objectquery
Example

 

01	/// Display method: SQL statement Display Method

02	using (TestEntities te = new TestEntities())

03

{

04	/// System. Data. objects must be referenced.

05	ObjectQuery oq = te.user.Where(a => a.user_id == 2) as ObjectQuery;

06

07	/// Obtain the SQL statement using the totracestring () method

08	string sql = oq.ToTraceString();

09

10	/// Extract the SQL statement

11	Response.Write(sql);

12

}

The results are as follows:

Select [extent1]. [user_id] as [user_id], [extent1]. [user_name] as [user_name],
[Extent1]. [user_email] as [user_email] from [DBO]. [user] as [extent1]
Where 1 = [extent1]. [user_id]