Entity framework many to many relationship association not automatically generated
I've seen this post, my problem is quite the opposite, EF is treating the entities as two separate 1 to many relation, so the User have many UserInRole, and the Role also have many UserInRole entities, shouldn't EF automatically hide the UserInRole table and give a navigation property Roles for User and Users for Role. What I want is actually this:
Solution
Deleting the entity from the edmx and updating changes fixed it, apparently when I updated the model from the database in the edmx designer it kept columns that I removed from the database maybe because it was referenced somewhere else in the project, anyway I deleted the entire entity manually and updated the changes / re-added the missing tables and it did the trick.
- Entity Framework - Unable to load the specified metadata resource
- modelBuilder.Configurations.Add and modelBuilder.Entity on OnModelCreating
- Lazy Loading vs Eager Loading
- Log Queries executed by Entity Framework DbContext
- Use int Id for a bigint column in EF6
- Check for pending migrations in Entity Framework?
- How do you run .NET Framework/EF migrations in an Azure Pipeline?
- Project X targets framework '.NETStandard'. The Entity Framework Package Manager Console Tools don't support this framework
- Does not contain a definition for 'CreateObjectSet' and no extension method 'CreateObjectSet' in EF6
- Updating parent entity without changing the children
- Unable to get a total count of items in the model in the ASP.NET MVC view
- How do I optimize this EF query and implement paging?
- Selecting Subcollections in Union-Query
- How to ignore duplicate Breeze SaveChanges calls
- AutoFixture creating unwanted depth in complex objects
- EF6 Include not detecting foreign keys
- How can I query the foreign key objects using Entity Framework?
- Is there a way to set the default Azure SQL Database pricing tier for an Azure SQL Server
- Entity Framework 6 change tracker issuing statements in the wrong order
- Accent insensitive search using EF6 and SQL Server 2008 R2 - Czech language
- Setting unique Constraint with fluent API?
- Adding ADO.Net Entity Framework gives "The project's target framework does not contain Entity Framework runtime assemblies"
- Math.Round in linq to entities vs linq to objects
- How entity framework works for large number of records?
- How to log errors in DB within a transaction that fails with Entity Framework 6
- EntityFramework Include method is not working
- EF6 LINQ query for UTC database timestamps that fall on the same day as a given local timestamp?
- Update model from database crashed
- How to connect to LocalDB in Visual Studio Server Explorer?
- Entity Framework search multiple words