EF executes SQL statement results and performs inconsistent results directly in SQL Server

Say the question first.

Results of direct SQL execution

var result = base. Context.Customers.SqlQuery (SQL);

　

The SQL statement is a break point, the connection is also a database, but the results are inconsistent

It is also correct to use SqlDataAdapter to fetch data into a dataset.

So you can rule out a problem with the SQL statement

While finding a solution, adding a dataset here is too ugly, although it avoids the problem

and change the way EF executes SQL directly

var result = base. Context.Database.SqlQuery (typeof (Customer), SQL). GetEnumerator ();

The data obtained by this method is normal, but the return is a Dbrawsqlquery object,

GetEnumerator () or Tolistasync () to get the Ienumerable<t> object after processing

Although bypassing the problem, but did not find the cause of the problem, if there is a great God know also hope to enlighten

EF executes SQL statement results and performs inconsistent results directly in SQL Server