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

Popular posts from this blog

java - How to set log4j.defaultInitOverride property to false in jboss server 6 -

c - GStreamer 1.0 1.4.5 RTSP Example Server sends 503 Service unavailable -

Using ajax with sonata admin list view pagination -