An error occurred while executing the command definition See the inner exception for details

Question

In my mvc asp net application  I am getting an error in edit function   in given code  public ActionResult Edit int id           var res    from r in objeEntities DocumentationsSet Include  DocStatus                   where r textid    id select r                   First        I am getting this exception   Source   System Data Entity  Stack Trace    at System Data EntityClient EntityCommandDefinition ExecuteStoreCommands EntityCommand entityCommand  CommandBehavior behavior   at System Data Objects Internal ObjectQueryExecutionPlan Execute TResultType  ObjectContext    context  ObjectParameterCollection parameterValues   at System Data Objects ObjectQuery 1 GetResults Nullable 1 forMergeOption   at System Data Objects ObjectQuery 1 System Collections Generic IEnumerable GetEnumerator   at System Linq Enumerable First TSource  IEnumerable 1 source  at System Data Objects ELinq ObjectQueryProvider b  0 TResult  IEnumerable 1 sequence   at System Data Objects ELinq ObjectQueryProvider ExecuteSingle TResult  IEnumerable 1 query  Expression queryRoot  at System Data Objects ELinq ObjectQueryProvider System Linq IQueryProvider Execute S  Expression expression  at System Linq Queryable First TSource  IQueryable 1 source  at admin com Controllers DocsGridController Edit Int32 id  in c  Data FinalCode AC015 acomMVCSourceCode admincom Controllers DocsController cs line    307  Message   An error occurred while executing the command definition  See the inner exception for details    This error is generated when I connect with remote server    What is this error  How do I fix it

User · Answer

In my case  It was from Stored Producers  I was removed a field from table and forgotten to remove it from my SP

User · Answer

Usually this means that your schema and mapping files are not in synch and there is a renamed or missing column someplace

User · Answer

I ve just run into this issue and it was because I had updated a view in my DB and not refreshed the schema in my mapping

User · Answer

Look at the Inner Exception and find out what object might have caused the problem  you might have changed its name

User · Answer

In my case  I messed up the connectionString property in a publish profile  trying to access the wrong database  Initial Catalog   Entity Framework then complains that the entities do not match the database  and rightly so

User · Answer

I had a similar situation with the  An error occurred while executing the command definition  error   I had some views which were grabbing from another db which used current user security   The second db did not allow the login for the user of the first db causing this issue to occur   I added the db login to the server it was trying to get to from the original server and this fixed the issue   Check your views and see if there are any linked dbs which have different security than the db you are logging onto originally

User · Answer

Does the actual query return no results  First   will fail if there are no results

User · Answer

After spending hours  I found that I missed  s  letter in table name  It was  Table  Employee    instead of  Table  Employees

User · Answer

This occurs when you specify the different name for repository table name and database table name  Please check your table name with database and repository

[entity-framework] An error occurred while executing the command definition. See the inner exception for details

Examples related to entity-framework