CODEWITHSUNDEEP
entity-framework
Aayushi Soni
Aayushi Soni

Reputation: 489

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

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?

Upvotes: 47

Views: 237251

Answers (9)

Hossein Yousefpour
Hossein Yousefpour

Reputation: 4953

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

Upvotes: 0

Preet Sangha
Preet Sangha

Reputation: 65506

Does the actual query return no results? First() will fail if there are no results.

Upvotes: 1

Joe
Joe

Reputation: 51

After spending hours, I found that I missed 's' letter in table name

It was [Table("Employee")] instead of [Table("Employees")]

Upvotes: 5

j00hi
j00hi

Reputation: 5931

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.

Upvotes: 3

Greg
Greg

Reputation: 181

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.

Upvotes: 0

jettmann
jettmann

Reputation: 36

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.

Upvotes: 1

user2919069
user2919069

Reputation: 31

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.

Upvotes: 3

live-love
live-love

Reputation: 52366

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

Upvotes: 0

John Farrell
John Farrell

Reputation: 24754

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

Upvotes: 64

Related Questions