How to create multiple table references to one table - Entity framework

asp.net c# database entity-framework-6 sql-server

Question

enter image description here

As shown in the figure, we have a need that several tables must be referenced to in a single table.

Please be aware that the design only serves to illustrate our requirements and is NOT the true DB model. Could you provide advice on how to accomplish the aforementioned in aSQL Server DB andEntity Framework 6 ?

Example: Multiple files may be uploaded to a sales order (in the SalesOrder database), and the information of those uploaded files are maintained in the UploadedFile table. The same applies to OrderTable and Invoice.

Therefore, a good database schema with FK links between the FileUpload table and all other associated tables is required.

Note: All tables' PKs are auto-increment int values, and further entities (tables) may be required in the future.

1
3
10/23/2018 3:33:01 PM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Popular Answer

ZZZ_tmp
2
10/23/2018 4:16:33 PM

Related Questions

Multiple tables are mapped to one object using Entity Framework.

In your database, you may build a view and use that to produce the object.
entity-framework
asked by Matt Dotson

Entity Framework 6 multiple table to one foreign key relationship code first

I experienced the same issue and started off using abstract classes rather than interfaces. My table 3 had two navigation properties: a public virtual Table 1 and a public virtual Table 2, and EF had recently added these new foreign key columns. This was a problem, so I combined the two navigation properties into a single navigation property....pub...
c# ef-code-first entity-framework sql
asked by anIBMer

Entity Framework - How to Insert to table with foreign keys without retrieving foreign table rows first

Foreign key properties can simply be added to the navigation properties and set using the existing ids. By doing this, you will avoid having to search the database for related items only to set the relationship.
entity-framework entity-framework-6 insert
asked by Pawel

Delete row in table with self-referencing many-to-many relationship in Entity Framework Code First

I think I have it figured out now....The answer is to change the PersonController Delete() stub as follows:...using (var context = new DataContext()) { Person person= context.Persons.Find(id); foreach (var child in person.Children.ToList()) { person.Children.Remove(chi...
asp.net-mvc ef-code-first entity-framework-6 many-to-many
asked by Marius Conjeaud

Two tables referencing each other in Entity Framework 6 Code First

The subsequent...OnModelCreating()... worked and seems to be accurate....protected override void OnModelCreating(DbModelBuilder modelBuilder) { modelBuilder.Entity<Sprint>() .HasKey(s => s.ID) .HasRequired(s => s.Project) .WithMany(p => p.Sprints) .HasForeignKey(s => s.ProjectId); modelBuilder.Entity<Project...
c# entity-framework entity-framework-6 sqlite
asked by Jay Wick

Entity Framework left join on multiple tables creates inner join instead

ZZZ_tmp
c# entity-framework entity-framework-6 linq
asked by Gert Arnold

Defining multiple Foreign Key for the Same table in Entity Framework Code First

You need to offer some additional configuration in order to get what you desire. Code When there are many bidirectional relationships between two entities, the first convention cannot distinguish between them. To provide the model builder access to this data, you can add configuration (using the ...Statistical Notes... or ...Flowing API...). You'll...
asp.net-mvc ef-code-first entity-framework foreign-key-relationship foreign-keys
asked by octavioccl

How to use Linq to join entity tables with a cross-reference table

ZZZ_tmp
.net entity entity-framework entity-framework-6 linq
asked by octavioccl

Entity Framework 6 - Missing table with only primary keys referencing different tables

ZZZ_tmp
.net c# entity-framework entity-framework-6
asked by DaniDev

Should I create new table for every consistent data set or one systemCodes table?

ZZZ_tmp
asp.net-mvc entity-framework entity-framework-6 sql-server
asked by user10340688

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge
View more on Stack Overflow

Prime Library

Performance

Expression Evaluator

More Projects...

Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow