Entity Framework 6.x Must specify mapping for all key properties
I am beginning playing with EF 6.x and I've got an annoying issue.
I've designed a database with simple User,Role,Permissions tables each one bond to another with classic many-to-many relation.
EF wants me to create primary keys in indirect tables (UserPermissions etc.) but also wants me to make some mapping for those Primary Keys but I have no clue why.
Is there something wrong with my design or there Is a workaround to this issue? Maybe Can I in some way use Unique index instead of Primary Key to satisfy EF?
There you have diagram to make it more clear:
Well, I'm embarrased that I've not came up to solution earlier.
Just added multicolumn Primary Key on columns referencing direct tables via foreign key.
e.g. CONSTRAINT pk_IdRole_IdPermission_RolePermissions PRIMARY KEY (IdRole,IdPermission)
- System.Resources.MissingManifestResourceException when Updating database
- How to make Entity Framework Data Context Readonly
- How to manage multiple uses of a model in an application?
- Entity Framework search multiple words
- Composite Key EF Core getting error when using Fluent Api
- Map string column in Entity Framework to Enum (EF 6, not EF Core)
- EF Core: Add custom LINQ in Up method of Migration class
- Create an Expression Tree that generates a parametric query for Entity Framework
- Is there a better way to get Non-friends to appear in "People you may know" Section?
- Wrestling simulator Entity Framework / database design
- How to delete, re-create, move, import, and export LocalDB databases?
- EF Core disconnected update of collection navigation properties via full replacement
- Azure Data Explorer C# querying and ORM
- EF Intersect Syntax
- Entity Framework : Sharing entities across different DbContexts
- Entity Framework Validation confusion - maximum string length of '128'
- Can I generate script of a migration with EF code first and .net core
- Unable to update database to match the current model because there are pending changes
- Entity Framework returns null value of associated tables when using stored procedure
- 'no such table: Blog' -error while table "Blog" does exist
- Unique Key constraints for multiple columns in Entity Framework
- EF4 POCO (not using T4): Mapping and metadata information could not be found for EntityType
- System.MissingMethodException: Method not found: '...EntityFrameworkCore.Metadata.Builders.EntityTypeBuilder`1.HasIndex(...)'
- Querying a custom type with Database.SqlQuery<T> in EF Core 7.0
- Entity Framework 6 Code First Custom Functions
- EF Data migrations won't detect changes when adding new migration
- Clean architecture: inverting dependency of EF DbContext
- C# and EntityFramework: Using a DBContext in multiple projects
- How to join tables using LINQ to Entities query?
- How does the SQLite Entity Framework 6 provider handle Guids?