[3.0.5 MSSQL 2008] Bug by order of Where and Select in quey
Posted: Fri 21 Oct 2011 10:28
The this query is correct executed:
But on next query:
generate error:
Code: Select all
var l = db.Users.Select(a => new { a.ID, a.Name }).Where(a => a.ID == id).ToList();Code: Select all
var l = db.Users.Where(a => a.ID == id).Select(a => new { a.ID, a.Name }).ToList();Code: Select all
System.Exception: Operation could destabilize the runtime. ---> System.Security.VerificationException: Operation could destabilize the runtime. at lambda_method(Closure , c ) at Devart.Data.Linq.Provider.ObjectReader`1.g() at Devart.Data.Linq.Provider.ObjectReader`1.b() at Devart.Data.Linq.Provider.ObjectReader`1.MoveNext() at Devart.Data.Linq.Provider.DataProvider.ReadQuery(CompiledQuery compiledQuery, IDbConnection con, f dataReader) at Devart.Data.Linq.Provider.DataProvider.ExecuteQuery(CompiledQuery compiledQuery, Object[] parentArgs, Object[] userArgs, Object lastResult) at Devart.Data.Linq.Provider.DataProvider.ExecuteAllQueries(CompiledQuery compiledQuery, Object[] userArguments) at Devart.Data.Linq.Provider.DataProvider.Devart.Data.Linq.Provider.IProvider.Execute(Expression query) at Devart.Data.Linq.DataQuery`1.System.Linq.IQueryProvider.Execute[S](Expression expression) at System.Linq.Queryable.FirstOrDefault[TSource](IQueryable`1 source)
...