It has a DefiningQuery but no InsertFunction element… err

by

Well when a table is encountered without a PrimaryKey it is treated as a View.

And views show up in the EDMX file (open in an XML editor to see) in the StorageModel\EntitySet[n]\DefiningQuery element.

When you have a DefiningQuery the Entity becomes readonly unless you add modification functions. You need 3 modifications functions (aka Stored Procedures) one for each of Insert, Update and Delete.

But you have two options:

Change the key definion:

  1. And convince the EF that what it thinks is a view is really a table
  2. Or add the appropriate modification functions

In your case I recommend (1).

More Related Contents:

  1. MVC3 and Entity Framework
  2. ASP.NET Identity DbContext confusion
  3. How can I force entity framework to insert identity columns?
  4. How to “warm-up” Entity Framework? When does it get “cold”?
  5. How do I add ROW_NUMBER to a LINQ query or Entity?
  6. How and where to call Database.EnsureCreated and Database.Migrate?
  7. Entity Framework: how to solve “FOREIGN KEY constraint may cause cycles or multiple cascade paths”?
  8. How to warm up an ASP.NET MVC application on IIS 7.5?
  9. thread messaging system database schema design
  10. The type initializer for ‘System.Data.Entity.Internal.AppConfig’ threw an exception
  11. Entity Framework 4 – Update database schema from model. Without wiping the table data
  12. Entity framework context as static
  13. Unable to Retrieve Metadata
  14. Difference between DropDownlist or DropDownListFor Html helper
  15. Unit-testing .ToListAsync() using an in-memory
  16. Unable to create an object of type ‘[DBContext’s Name]’. For the different patterns supported at design time [closed]
  17. Entity Framework v2 doesn’t support sql 2000?
  18. How to implement multiple searching in jqGrid
  19. How to add ASP.NET 4.0 as Application Pool on IIS 7, Windows 7
  20. Error to use a section registered as allowDefinition=’MachineToApplication’ beyond application level
  21. jqgrid Page 1 of x pager
  22. What are the (dis)advantages of using Cassini instead of IIS?
  23. ASP.NET MVC Url Route supporting (dot)
  24. Viewing localhost website from mobile device
  25. SSL pages under ASP.NET MVC
  26. Session Fixation in ASP.NET
  27. How can I get a MAC address from an HTTP request?
  28. How to disable submit behaviour of asp:ImageButton?
  29. What do the TargetFramework settings mean in web.config in ASP .NET MVC?
  30. Asp.Net Check file size before upload

Leave a Comment