我们如何在Parent&使用实体框架的子表 [英] how we can insert data in both Parent & Child table using Entity Framework
问题描述
最后,我经过巨大的挣扎后找到了这个解决方案
我的工作非常聪明! !
列表< 第二> ;&NBSP;仙;
List < 首先> con = (来自 a in db.Firsts.Include(" seconds" )
并且 选择 a).ToList< First >();
for ( int i = 0; i< 1; i ++)
{
&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP; textBox1.Text&NBSP; =&NBSP;精读[I] .ID.ToString(); // 3父表的属性" Firsts"
&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP; textBox2.Text&NBSP; =&NBSP;精读[I] .Name.ToString();
textBox3.Text = con [i] .Password.ToString();
sen = con [i] .seconds.ToList();
for ( int j = 0; j< sen.Count; j ++) //访问与第二个表相关的datagridview的所有数据以进行收集
{
dataGridView2.Rows.Add("" ,"" ,sen [j] .Subject.ToString(),sen [j ] .Marks.ToString());
&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;}
&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP ;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;
}
Finally, i found this solution after a huge struggle
Its work me very smart !!!
List<second> sen; List<First> con = (from a in db.Firsts.Include("seconds") select a).ToList<First>(); for(int i=0;i<1;i++) { textBox1.Text = con[i].ID.ToString(); // 3 property of parent table "Firsts" textBox2.Text = con[i].Name.ToString(); textBox3.Text = con[i].Password.ToString(); sen=con[i].seconds.ToList(); for(int j=0;j<sen.Count;j++) //Access all data of from datagridview related to second table for make Collection { dataGridView2.Rows.Add("","",sen[j].Subject.ToString(),sen[j].Marks.ToString()); } }
这篇关于我们如何在Parent&使用实体框架的子表的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!