Can we have table without primary key in entity framework?

by

There is a great difference between what EF can do with a database, and what is possible with a database.

Most databases allow for a table to be without a primary key. Most databases also allow for a table to be without a clustered index / Index Organized Table (or what ever it is the specific term for it in other database systems).

There is nothing wrong with that, and one should not state that it is a bad idea to have a table without a PK.

As always, it dependes on the needs and usage of the specific table. e.g. a log table, does not need a PK. It will never be used as a FK, so what is it use?

Bottom line, EF does not support tables without a key out of the box, there are some weird workarounds, but none that I have seen is good enough. That is a shame.

More Related Contents:

  1. EF: Include with where clause [duplicate]
  2. Entering keys manually with Entity Framework
  3. How do I apply OrderBy on an IQueryable using a string column name within a generic extension method?
  4. The cast to value type ‘Int32’ failed because the materialized value is null
  5. Entity framework left join
  6. What are the downsides to turning off ProxyCreationEnabled for CTP5 of EF code first
  7. An object with the same key already exists in the ObjectStateManager. The ObjectStateManager cannot track multiple objects with the same key
  8. Entity Framework. Delete all rows in table
  9. ‘datetime2’ error when using entity framework in VS 2010 .net 4.0
  10. Entity vs Model vs View Model
  11. Eager , Lazy and explicit loading in EF6
  12. Place to put Database.SetInitializer
  13. ToArrayAsync() throws “The source IQueryable doesn’t implement IAsyncEnumerable”
  14. EF4 Code First: how to add a relationship without adding a navigation property
  15. Entity Framework 4: How to find the primary key?
  16. How to COUNT rows within EntityFramework without loading contents?
  17. Simulating Cross Context Joins–LINQ/C#
  18. Can you get the DbContext from a DbSet?
  19. Entity Framework | Sequence contains more than one matching element
  20. Check if list contains item from other list in EntityFramework
  21. Why is EF generating SQL queries with unnecessary null-checks?
  22. Entities VS Domain Models VS View Models
  23. How to do an “in” query in entity framework?
  24. big issue in converting string to datetime using linq-to-entities
  25. Mixing Fluent API and DataAnnotations in EF code first
  26. Keep Getting ‘The LINQ expression node type ‘Invoke’ is not supported in LINQ to Entities’ Exception
  27. Why is EF returning a proxy class instead of the actual entity?
  28. How does the SQLite Entity Framework 6 provider handle Guids?
  29. System.Data.Entity.Core.EntityCommandExecutionException Occurred in MVC app Using EF
  30. How to set Identity Seed value in code-first?

Leave a Comment