EntityCommandExecutionException from Entity Framework

Question

I'm confused on why I am getting an exception when I call a stored procedure from the entity framework api. The error states:

    The data reader is incompatible with the specified [Model].[SP_Result_Type]. 
A member of the type, [typeName], does not have a corresponding column in the data reader with the same name.

The SP in question is a SELECT command that gets values from (3) different tables and Entity Framework returns the values in a ComplexObject type. By "data reader", I guess the exception is referring to a type created by the EF API. If so, both the "data reader" and the table(s) have the correct variable names, so I don't understand the cause of this exception.

The change would probably be in the designer EF created, but I don't know what to change.

@Jethro - Does it matter? How can we make it work with MySql? — Mr.X
– Mr.X, Commented Jun 5, 2015 at 7:07

Davide Piras · Accepted Answer · 2011-08-01 12:59:58Z

2

the error is clearly not in the entity/variable names but in the fields, there is a missing column, you should probably update the complex object type definition to either add the missing column or remove the old one no longer present in the db or not returned anymore by the stored procedure you are calling.

hope this helps :)

answered Aug 1, 2011 at 12:59

Davide Piras

44.7k10 gold badges103 silver badges150 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Jethro · Accepted Answer · 2011-08-01 13:01:47Z

0

If I'm not mistaken if you are using SQL Compact, then EF does not support Stored Procedures with Sql Compact.

"SQL Server Compact does not support stored procedures and views."

Link found here

answered Aug 1, 2011 at 13:01

Jethro

5,9413 gold badges25 silver badges24 bronze badges

Collectives™ on Stack Overflow

EntityCommandExecutionException from Entity Framework

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related