i have a question. please suppose that we have different entities like category,blog,videos,... and each of them has own comments. how can i use one comment table for all of these entities just using one FK?is that TPH pattern?how can i implement it in codefirst approach? something like this Comments(CommentID, ..., PostID, VideoID) to Comments(CommentID). thanks in advance.
TPH pattern in ef core for a shared table between different entities
210 views Asked by reza setareh At
1
There are 1 answers
Related Questions in .NET
- file download method in visual studio 2017
- Repository manager receives the wrong connection string in .net core
- MongoDb not connecting C#
- The current .NET SDK does not support targeting .NET Core 6.0. Brand new WPF Project VS Community 2022 17.9.5
- Why Scanning GSI on DynamoDb doesnt work as fast as expected when using CONTAINS?
- Are "blittable types" really unmanaged types for StructLayout Sequential
- Failed to fetch dynamically imported module on Blazor JS Interop
- Problem to upload several images per one request
- Implementing Azure AD B2C Authentication in .NET 8 Blazor Project (RenderMode: InteractiveAuto)
- Stripe connect payout - throws exceptions
- 'IOException: The cloud file provider is not running', when trying to delete 'cloud' folder
- Azure Application Insights Not Displaying Custom Logs for Azure Functions with .NET 8
- Convert C# DateTime.Ticks to Bigquery DateTime Format
- Socket.io nodejs server .NET connection
- Producer Batching Service Bus Vs Kafka
Related Questions in ASP.NET-CORE
- Windows environment variables at appsettings.json
- Which approach is right while creating a service for your update method?
- New Blazor Web App, Password Reset "A valid antiforgery token was not provided"
- No webpage was found for the web address: https://localhost:7002/Category/Add?area=Admin. Why is my URL generated like ?area=Admin instead of /Admin/
- how to get the html for a tag helper in code
- How to share authorization implemented in the server project with the client project in Blazor Web App Auto project?
- Why https is disabled on publish in .NET Core 7.0
- How to set language in a server-side rendering blazor app
- How can I debug server side rendering blazor code in a component?
- ASP.NET Core 6 randomly returning 200 with empty response
- ASP.NET Core MVC : NullReferenceException: Object reference not set to an instance of an object
- ASP.NET Core Identity Custom Register Endpoint
- VS Community 2022 cannot install dotnet-ef when i try to publish
- How does ASP.NET Core Identity ensure username is unique under concurrent conditions？
- In clean architecture, is the presentation layer allowed to communicate directly with the infrastructure layer?
Related Questions in ENTITY-FRAMEWORK-CORE
- Will it slow down the performance when Unit of work pattern is used with EF Core
- Entity Framework Core 8 dbcontext - can't add some rows in many-to-many relationship
- Upsert huge amount of data by EFCore.BulkExtensions
- .NET Core 8, how can I add properties to user account that contains multiple values?
- How to load data from a different context in Entity Framework Core?
- Passing GUID value through SqlQuery will raise the error: invalid input syntax for type uuid
- The specified data type in the EF modelBuilder doesn't correspond to the one that is created
- EntityFrameworkCore.DbUpdateException: Unable to delete row, SQL Syntax error
- Create one entity for multiple tables?
- I'm getting an error, when trying to communicate with db, it seems like something with verses, but I've already changed it and the error continues
- Issue with Entity Framework Core: .Include() and .AsNoTracking() not displaying expected related entities
- Entity Framework Core 8 throws "Method not found: 'Void CoreTypeMappingParameters..ctor" error
- EF Core is creating a table not in the migration
- Can I share a List<T> property across multiple queries via a tracking DbContext?
- Revert database context to previous state EF Core 7
Related Questions in EF-CODE-FIRST
- Having trouble with EF Core / ASP.NET Core MVC MultiSelectList selectedItems
- EF Core database-first: proper workflow
- HasComputedColumnSql() method not working as Expected
- Different tool to generate codefirst migration. Time to clean up and refactor
- I want to save the report to the SQl Server database automatically from the DevExpress report designer interface
- Why won't EF Core migration tools add column collation?
- How can I access Entity Type information in EF Core with code first?
- Error In create constraint or index on asp.net
- Introducing foreign key constraint may cause cycles or multiple cascade paths - How do I specify "ON DELETE NO ACTION"?
- Entity Framework Core - One-to-one relationships not creating foreign key
- Entity Framework code-first, Null entries being written to database
- .NET EF Core Sort by child collection property
- How to force Entity Framework 6 to drop/create table instead of renaming?
- Dependency loop despite entities configuration in Entity Framework. Include vs Join
- Saving parent and children into separate tables with EF Core
Related Questions in TPH
- Entity Framework Core TPH with Foreign Keys on Derived Types Erroring
- How to access a property from a base class in a LINQ query with two levels of inheritance in EF Core
- EF Core - TPH: Include child properties
- TPT to TPH discriminator column issue
- Retrieving data from classes that use TPH in entityframework
- Entity Framework invalid cast saving new tph record
- How to declare a parent child relationship when both tables are TPH and the relationship is in the base classes?
- How to combine ProjectTo with Map using Automapper?
- TPH pattern in ef core for a shared table between different entities
- Configuring relationships between 2 TPH types using Fluent API
- How to Mapping TPH in ownsmany
- Invalid column name when using Entity Framework Core Table Per Hierarchy Inheritance
- asp.net core identity Multiple users from BaseApplicationUser
- EF Core - ThenInclude() on collection with polymorphic elements
- How to persist columns as json using the table-per-hierarchy (TPH) pattern in Entity Framework Core 2
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
Popular Tags
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
You can eliminate the FK from the comments table by using Many-to-Many relationships or separate linking entities for the relationships.