Entity Framework – Invalid Column Name ‘*_ID”

by

Check to see if you have any ICollections.

What I have figured out is when you have an ICollection that references a table and there is no column that it can figure out, it creates one for you to try to make the connection between the tables. This specifically happens with ICollection and has driven me “batty” trying to figure it out.

More Related Contents:

  1. LINQ to Entities case sensitive comparison
  2. Entity Framework 4 – AddObject vs Attach
  3. Entity Framework/Linq EXpression converting from string to int
  4. Entity Framework/SQL2008 – How to Automatically Update LastModified fields for Entities?
  5. Entity Framework/Linq to SQL: Skip & Take
  6. Why re-initiate the DbContext when using the Entity Framework?
  7. Exclude a field/property from the database with Entity Framework 4 & Code-First
  8. Internal .NET Framework Data Provider error 1025
  9. Entity Framework Code Only error: the model backing the context has changed since the database was created
  10. Entity Framework 4: How to find the primary key?
  11. Entity Framework Code First AddOrUpdate method insert Duplicate values
  12. Change db table name in EF4 (entity framework 4)
  13. Entity Framework Multiple Object Contexts
  14. The principal end of this association must be explicitly configured using either the relationship fluent API or data annotations
  15. Repository Pattern, POCO, and Business Entities
  16. How to enable assembly bind failure logging (Fusion) in .NET
  17. How do I abort/cancel TPL Tasks?
  18. Fire and forget async method in asp.net mvc
  19. Editing dictionary values in a foreach loop
  20. How to use the ternary operator inside an interpolated string?
  21. ReadOnlyCollection or IEnumerable for exposing member collections?
  22. Static Generic Class as Dictionary
  23. SqlConnection SqlCommand SqlDataReader IDisposable
  24. Extension methods syntax vs query syntax
  25. Refactoring code to avoid anti-pattern
  26. .NET FileInfo.LastWriteTime & FileInfo.LastAccessTime are wrong
  27. Visual Studio 2015 RTM – Debugging not working
  28. Reverse a string with accent chars?
  29. C# how to send email?
  30. .NET DateTime to SqlDateTime Conversion

Leave a Comment