Incompatible Data Reader Exception From EF Mapped Objects

by

The message means that the results of the stored procedure do not contain a column named ValudationId. Double check your select statement and run it in SSMS to ensure that you’re bringing back that column.

EDIT: Your procedure does not contain a select statement. You need to select the inserted identity value (using the scope_identity() function, for example) so that EF can map it back to the entity.

For example,

insert into Table
(
    Col1,
    Col2
)
values
(
    1,
    2
)

select scope_identity() as IdentityColName

Also, as an aside, you don’t need all that transaction business in your insert statement; you only have one statement (your insert) that’s modifying data.

More Related Contents:

  1. getting the values from a nested complex object that is passed to a partial view
  2. One DbContext per request in ASP.NET MVC (without IOC container)
  3. ASP.NET MVC Model vs ViewModel
  4. Why LINQ to Entities does not recognize the method ‘System.String ToString()?
  5. Multiple DB Contexts in the Same DB and Application in EF 6 and Code First Migrations
  6. using stored procedure in entity framework
  7. Real example of TryUpdateModel, ASP .NET MVC 3
  8. Should services always return DTOs, or can they also return domain models?
  9. ASP.NET MVC3 and Entity Framework Code first architecture
  10. attribute dependent on another field
  11. How to change type of id in Microsoft.AspNet.Identity.EntityFramework.IdentityUser
  12. Saving Many to Many relationship data on MVC Create view
  13. Defining multiple Foreign Key for the Same table in Entity Framework Code First
  14. ‘Microsoft.SqlServer.Types’ version 10 or higher could not be found on Azure
  15. Converting flattened hierarchical data from SQL Server into a structured JSON object with C#/Linq
  16. Entity Framework Include OrderBy random generates duplicate data
  17. Use Entity framework I want to include only first children objects and not child of child(sub of sub)
  18. Required Attribute on Generic List Property
  19. keyword not supported data source
  20. Model backing a DB Context has changed; Consider Code First Migrations
  21. There is already an object named ‘AspNetRoles’ in the database
  22. The conversion of a datetime2 data type to a datetime data type resulted in an out-of-range value
  23. The type or namespace name ‘DbContext’ could not be found [closed]
  24. EntityType ‘Category’ has no key defined. Define the key for this EntityType [duplicate]
  25. Strongly-Typed ASP.NET MVC with ADO.NET Entity Framework [closed]
  26. ASP.NET MVC – Should business logic exist in controllers?
  27. MVC Html.Partial or Html.Action
  28. Bootstrap glyphicon not showing in Form
  29. Attempt by security transparent method ‘WebMatrix.WebData.PreApplicationStartCode.Start()’
  30. MVVM ViewModel vs. MVC ViewModel

Leave a Comment