Entity framework adding null foreign key to child tables -
Entity framework adding null foreign key to child tables -
i'm new ef. here problem.
i have 2 classes:
public class menu { [key] public string number { get; set; } public virtual list<category> categories { get; set; } } public class category { public int64 categoryid { get; set; } public string menucategory { get; set; } public virtual list<item> menuitems { get; set; } }
update-database
command creates 2 tables
create table [dbo].[menus] ( [number] nvarchar (128) not null, constraint [pk_dbo.menus] primary key clustered ([number] asc) ); create table [dbo].[categories] ( [categoryid] bigint identity (1, 1) not null, [menucategory] nvarchar (max) null, [menu_number] nvarchar (128) null, constraint [pk_dbo.categories] primary key clustered ([categoryid] asc), constraint [fk_dbo.categories_dbo.menus_menu_number] foreign key ([menu_number]) references [dbo].[menus] ([number]) );
when tried add together new category
corresponding menu
next method, inserts new category
table sets foreign key of category
table null
.
var dbitem = db.menus.find(id); var categoriestoadd = menu.categories.takewhile(p => p.categoryid == 0); foreach (var item in categoriestoadd) { db.entry(item).state = entitystate.added; }
as result can't newly added categories corresponding menu.
how set proper fk on category
table during adding new category
?
entity-framework entity-framework-6
Comments
Post a Comment