Sunday 15 May 2011

c# - Making 2 tables out of a single table in Entity Framework 6.1 -



c# - Making 2 tables out of a single table in Entity Framework 6.1 -

i have hierarchy of classes want generate database construction using code first of entity framework 6.1

base class structures follows.

class base{/*base class properties id basep1 basep2*/} class : base of operations {/*base class properties*/ /*a class properties*/} class b : base of operations {/*base class properties*/ /*b class properties*/} class c : base of operations {/*base class properties*/ /*c class properties*/} class d : base of operations {/*base class properties*/ /*d class properties*/}

from here split 2 types of similar classes.

//type 1 classes class type1_a : {/*type1_a props*/ /*base class properties*/ /*a class properties*/} class type1_b : b {/*type1_b props*/ /*base class properties*/ /*a class properties*/} class type1_c : c {/*type1_c props*/ /*base class properties*/ /*a class properties*/} //type 2 classes class type2_a : {/*type2_a props*/ /*base class properties*/ /*a class properties*/} class type2_b : b {/*type2_b props*/ /*base class properties*/ /*a class properties*/} class type2_c : c {/*type2_c props*/ /*base class properties*/ /*a class properties*/} class type2_d : d {/*type2_d props*/ /*base class properties*/ /*a class properties*/}

i want create database construction as

table1 id basep1 basep2 table2 id basep1 basep2 table_type1_a id(foreign key id table 1) --type1_a columns-- --a columns-- table_type1_b id(foreign key id table 1) --type1_b columns-- --b columns-- table_type2_a id(foreign key id table 2) --type2_a columns-- --a columns-- table_type2_b id(foreign key id table 2) --type2_b columns-- --a columns--

so

i need make 2 tables of same base class , do tpt on type1_* , type2_* classes

both annotations or fluent api(preferable) option

does entity framework supports making 2 table out of same type using code first? how implement it?

c# sql entity-framework code-first entity-framework-6.1

No comments:

Post a Comment