Problem: A particular LINQ-to-SQL query selecting fields from a SQL Server view in a C# program, which ran fine in my local dev environment, produced an exception when run in the staging environment:
Exception Message: An error occurred while executing the command definition. See the inner exception for details. Exception Trace: System.Data.Entity.Core.EntityCommandExecutionException at System.Data.Entity.Core.EntityClient.Internal.EntityCommandDefinition.ExecuteStoreCommands(EntityCommand entityCommand, CommandBehavior behavior) at System.Data.Entity.Core.Objects.Internal.ObjectQueryExecutionPlan.Execute[TResultType](ObjectContext context, ObjectParameterCollection parameterValues) at System.Data.Entity.Core.Objects.ObjectContext.ExecuteInTransaction[T](Func`1 func, IDbExecutionStrategy executionStrategy, Boolean startLocalTransaction, Boolean releaseConnectionOnSuccess) at System.Data.Entity.Core.Objects.ObjectQuery`1.<>c__DisplayClass7.b__5() at System.Data.Entity.SqlServer.DefaultSqlExecutionStrategy.Execute[TResult](Func`1 operation) at System.Data.Entity.Core.Objects.ObjectQuery`1.GetResults(Nullable`1 forMergeOption) at System.Data.Entity.Core.Objects.ObjectQuery`1..GetEnumerator>b__0() at System.Data.Entity.Internal.LazyEnumerator`1.MoveNext() at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection) at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source) at [My code ...]
Resolution: I had neglected to deploy to the staging environment (where the query was failing) a recently-created Entity Framework migration, which added a new output field to the SQL Server view being queried. The query was failing because it was trying to select a field which didn’t actually exist on the target view.
Upon closer examination, when I reproduced the error and inspected the inner exception (which wasn’t being automatically written to the application’s error log), it was indeed of type SqlException and had the helpful message “Invalid column name ‘[my column name]’”.
So, things to try next time I see this exception:
- Examine the inner exception (as suggested by the outer exception’s error message).
- Make sure all Entity Framework migrations have been deployed to the target environment (if EF is in use).
- Check and see whether the query is trying to select a field that doesn’t exist.
Posts
Thank you! The Google search for "EntityCommandExecutionException at System.Data.Entity.Core.EntityClient.Internal.EntityCommandDefinition.ExecuteStoreCommands" results in only 1 hit! This page! You saved me a lot of headscratching.. thanks again!
ReplyDeleteNice, glad this was helpful!
ReplyDeleteHi, yeah SQL exceptions and/or mapping errors can be hard to find sometimes, specially if they're not logged :)
ReplyDeleteAt first I tought my issue was a mapping migration problem, but it turned out to be a "Configuration Manager" configuration selection that was set wrong. I found out about this transform mistake while doing some testing, I actually looked at the Output window, I seldom do that.. when I publishing my site, and there I noticed that the "Transformed Web.config using..." was wrong!
I'm using transformation on the Web.config file to support different enviroments, Live/Demo/Staging.. and somehow the Staging configuration in the Visual Studio 2013 "Configuration Manager" had the wrong configuration selected. So instead of having Staging selected on the Web project it had Release selected which led to the wrong environment being used.. and of course the wrong mapping :P