8,497
社区成员
发帖
与我相关
我的任务
分享
//上下文
public partial class Entities : DbContext
{
public Entities()
: base("name=TestUserDataEntities")
{
}
protected override void OnModelCreating(DbModelBuilder modelBuilder)
{
}
public DbSet<U1> U1 { get; set; }
public DbSet<U2> U2 { get; set; }
}
public class U
{
//基类
[Key]
public int id { get; set; }
public string name { get; set; }
}
//U1表
public partial class U1:U
{
public U1()
{
this.U2 = new HashSet<U2>();
}
public Nullable<int> input_Qty { get; set; }
public Nullable<int> output_Qty { get; set; }
public virtual ICollection<U2> U2 { get; set; }
}
U2表
public partial class U2
{
[Key]
public int Id { get; set; }
public Nullable<int> Uid { get; set; }
public string remark { get; set; }
[ForeignKey("Uid")]
public virtual U1 U1 { get; set; }
}
调用:
protected void Button1_Click(object sender, EventArgs e)
{
Entities db = new Entities();
//这里Include我直接使用重载的string参数,表名就可以了
var q = db.Set<U1>().Include("U2").Where(x=>x.id==1).ToList();
}