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.
- Run code after all EF Core migrations are applied
- Why can't I install Microsoft.EntityFrameworkCore.Sqlite?
- Paging Support - ADO.NET Entitry Framework and LINQ
- I have a SQL query and I want to convert it to linq
- Why I am getting Cascade delete cycle error when updating the database
- Entity framework Invalid Column name, EF adds number 1 to primary key
- How can I implement DbContext Connection String in .NET Core?
- Entity Framework | Sequence contains more than one matching element
- Entity Framework error: Cannot insert explicit value for identity column in table
- Does EntityFrameworkCore async method use different thread than the one which DbContext is created?
- I am try to Pagination using Skip Take in Code Frist Approach But given Error
- Entity Framework Core multiple connection strings on same DBContext?
- ASP.NET MVC. PagedList filtering by multiple params
- Why string property must be declared as nullable string in Entity Framework Core when corresponding database table column is nullable
- Is there is a C# function which is similar to .Map() in JavaScript?
- Unable to update database to match the current model because there are pending changes
- EF .NET 6 Data Annotations with database-first: cannot make annotations work
- How do I call SQLitePCL.Batteries.Init().?
- String or binary data would be truncated. The statement has been terminated. System.Data.SqlClient.SqlException (0x80131904)
- Is there a reason for using the Repository pattern with Entity Framework if I know I will only ever use EF?
- Invalid object name 'dbo.AspNetUsers' in Asp.NET MVC 5 Entity Framework
- EF6.5 SetExecutionStrategy vs SetTransactionHandler
- C# Entity Framework: Keyword not supported: 'port'
- Using Global Query Filters for all entities
- Test for schema changes in Entity Framework migration
- LINQ: Why does a union of a union throw error message "IQueryable<...> does not contain a definition for 'Union'"?
- Map Table Column to Enum and Lookup Table to Enum
- How to automatically call Entity Framework's update from database without Visual Studio
- Multiple Tables With Same Structure Entity Framework
- NpgsqlException while connecting to Postgres: ERROR: 3D000: odyssey: c16b9035a1f78: route for 'template1.xxx' is not found