Entity Framework: table without primary key

by

I think this is solved by Tillito:

Entity Framework and SQL Server View

I’ll quote his entry below:

We had the same problem and this is the solution:

To force entity framework to use a column as a primary key, use ISNULL.

To force entity framework not to use a column as a primary key, use NULLIF.

An easy way to apply this is to wrap the select statement of your view in another select.

Example:

SELECT
  ISNULL(MyPrimaryID,-999) MyPrimaryID,
  NULLIF(AnotherProperty,'') AnotherProperty
  FROM ( ... ) AS temp

answered Apr 26 ’10 at 17:00 by Tillito

More Related Contents:

  1. Introducing FOREIGN KEY constraint may cause cycles or multiple cascade paths – why?
  2. LINQ to Entities does not recognize the method
  3. Like Operator in Entity Framework?
  4. How can I query for null values in entity framework?
  5. .NET Entity Framework and transactions
  6. Get Database Table Name from Entity Framework MetaData
  7. Can you use Microsoft Entity Framework with Oracle? [closed]
  8. “Items collection must be empty before using ItemsSource.”
  9. Undo changes in entity framework entities
  10. Update primary key value using entity framework
  11. ASP.NET MVC: Is Controller created for every request?
  12. EF LINQ include multiple and nested entities
  13. Cannot attach the file *.mdf as database
  14. Is is possible to check if an object is already attached to a data context in Entity Framework?
  15. Generate POCO classes in different project to the project with Entity Framework model
  16. Batching DB commands in Entity Framework 4.0
  17. How to work with Enums in Entity Framework?
  18. What are Navigation Properties in Entity Framework for?
  19. LINQ to Entities does not recognize the method Int32 get_Item(Int32)
  20. How to set default value for POCO’s in EF CF?
  21. How to map table splitting in EF Code First?
  22. Changing the type of an (Entity Framework) entity that is part of an inheritance hierarchy
  23. Organizationally, where should I put common queries when using Entity Framework Code First?
  24. Entity Framework 4 Single() vs First() vs FirstOrDefault()
  25. Using entity framework on multiple databases
  26. entity framework Unable to load the specified metadata resource [duplicate]
  27. The model backing the ‘ApplicationDbContext’ context has changed since the database was created
  28. Entity Framework Find vs. Where
  29. ‘ObjectContext’ vs ‘DbContext’ in Entity Framework
  30. Using Entity Framework entities as business objects?

Leave a Comment