EntityFramework using with database foreign key

[cridgegew]

Actually I spend whole day on the EntityFramework for foreign key.assume we have two table.Process(app_id,process_id)LookupProcessId(process_id, process_description)you can understand two tables with names, first table ,use process_id to indicate every application, and description is in the seoncd table.Actually i try many times and figure out how to do inquery: it was like\[code\]Dim result = (from x in db.Processes where x.LookupProcess is (from m in db.LookupProcessIds where descr = "example" select m).FirstOrDefault() select x).FirstOrDefault()\[/code\]First I want to ask is there easier way to do it.Second i want to ask question is about insert\[code\] p As New AmpApplication.CUEngData.Process p.app_id=100 p.LookupProcess = (from m in db.LookupProcessIds where descr = "example" select m).FirstOrDefault() db.AddToProcesses(p) db.SaveChanges()\[/code\]from appearance it looks fine, but it give me error saysEntities in 'AmpCUEngEntities.Processes' participate in the 'FK_Process_LookupProcess' relationship. 0 related 'LookupProcess' were found. 1 'LookupProcess' is expected.can i ask is that insert wrong? and is that my query correct?