Geek Answers Handbook

EF6 Partitioning tables and a shared primary key for multiple partitions

I am updating an outdated database system in .NET + Entity Framework 6 (with POCO code) + PostgreSQL. To simplify programming, I want to split a large table (more than 200 fields) into several objects, for example:

Franchise
FranchiseLegalEntity
FranchiseBilling
FranchiseSignup
FranchiseAllocation
FranchiseCompliance
FranchiseMiscellaneous
FranchiseNotifications

I was glad to find that EF6 supports "table splitting": displaying a separate table for multiple objects to split fields up.

However, an attempt to realize this and reading many pages on the Internet has confirmed that this is a problem when splitting several times. Entity Framework requires navigation properties not only for the main object, but for all objects mapped to the table. For my scenario above, this will require 21 meaningless navigation properties - 42 if I was worried about making them two-way.

See: http://social.msdn.microsoft.com/Forums/en-US/0f65caae-8a66-431f-aa02-4b2c68f871e9/ef-41-rc-code-first-split-one-table-into-multiple- entities? forum = adodotnetentityframework

See: How to separate a large table from several discrete types using EF-Code-First

, . , EF SQL-, PostgreSQL , (100GB + database).

:

: ,

: OnModelBuilding() ,

: ,

: ,

:

1) EF6 2+ ?

2) - , ?

3) ?

P.S. [ComplexType]

+4
2

, , - .

API. , , .

( ) :

EF6 / + ?

+1

BCP- BCP- DB. , SQL- BCP-out , (, , ). , - .

+1

More articles:


All Articles