Cannot select table for discriminator (model-first)
I'm trying to kick off a project needing table-per-hierachy. I've done this in the past with NHibernate, but we want to avoid having to hand edit XML mapping files - so are trying to use Entity Framework and it's Designer.
I've been following this example online: http://mosesofegypt.net/post/Inheritance-and-Associations-with-Entity-Framework-Part-1.aspx
When trying to select a Table from the "<Add Table or View>" dropdown, I can't select any tables, instead the list shows "(Empty)".
The only deviation I've made from the tutorial is that I didn't generate the Person table off the sample database, as far as I can tell this shouldn't make a difference (we want to generate the DB off the model, not vice versa).
Not sure what criteria a table needs to meet to be eligible to add a discriminator to...
If you need to generate DB from the model you cannot see any table in mapping because both mapping and information about tables is generated when you generate the database. EDMX has quite complex structure (much more complex than very easy hbm files for NHibernate). The complexity is even worse because EDMX doesn't have anything implicit - everything must be described and it must be described three times.
EDMX consists of three parts:
- CSDL - conceptual model you see in the designer (classes)
- SSDL - database description - this can be browsed in model browser but it is read-only
- MSL - mapping between SSDL and MSL (that is what you are trying to edit in that window).
When you are going to use model-first (draw entities in designer and generate database) you define only CSDL and everything else is generated with SQL for the database. You will also probably need another template / workflow for DB generation because I guess it will by default use Table-per-type inheritance. Check Database generation power pack - it should contain template for TPH.
- Log Queries executed by Entity Framework DbContext
- Use int Id for a bigint column in EF6
- Entity Framework not loading related objects
- What does the DBContext.Entry do?
- "where" clause: entity id is in a potentially null array
- Entity Framework query slow, but same SQL in SqlQuery is fast
- What is the right way to get data from related tables using an entity and business models separately in ASP.NET Core Web API?
- How to add a model in asp.net mvc project
- Entity Framework - Check for pending migrations
- Check for pending migrations in Entity Framework?
- How to use query with quotes inside a parent query
- Constructor injection into IDesignTimeDbContextFactory
- An error occurred while accessing the Microsoft.Extensions.Hosting services when do first migrations
- Can I create an app with swift to controle a go pro camera from the phone?
- EF Core navigation properties to both a collection and a specific item in the collection
- Assign Credentials (user name/password) to EF in Code
- How to get next value of SQL Server sequence in Entity Framework?
- How to set a default value on a Boolean in a Code First model?
- Catch SqlException at the controller level?
- BeginTransaction with IsolationLevel in EF Core
- in entity framework code first, how to use KeyAttribute on multiple columns
- Cannot access a disposed context instance EF core
- Multiple includes using Entity Framework and Repository Pattern
- Roslyn analyzer for checking syntax of SQL literals in VS2022?
- How do I add a row in Entity Framework?
- Why is the Entity Framework Model Browser not displaying?
- howt to Include related entities with filter condition using AsExpandable
- How to deal with a list of EF database first contexts and cast them correctly?
- Error Adding DataTable Rows to Entity Framework Invoices Table
- InvalidOperationException: Unable to resolve service for type 'ApplicationDbContext' while attempting to activate