Back to the Future in DLL Hell - Update

We have identified the issue and it has to do with a LINQ to Entities query behaving differently in .NET 4.5 and generaring different T-SQL then in .NET 4.0.  Basically, some left joins are now replaced by inner joins.

Our options are to either spend some time trying to fudge the model and/or the query and test it on 4.0 and 4.5 in the hopes that it will generate the same T-SQL or convert this query in a stored proc.  It also mean that we have to do regression testing on all our database code and test any future database code on both 4.0 and 4.5.  Might be simpler to convert the queries into store procs.

blog comments powered by Disqus

Page List

Month List