EquityDomainContext equity=new EquityDomainContext;
当我想要连接多张表查询的时候！应该如何写查询语句啊！
var equity=from tp1 in this.equity.OperationTable from tp2 in this.equity.StaticUser where tp2.Id==tp1.Id select tp1;
直接这么写会提示指定集合没有任何序列存在！
像下面这样写就可以查询，不过这是为什么呢！
EquityDomainContext equity=new EquityDomainContext;
LoadOperation<OperationTable> loadOp = this.equity.Load(this.equity.GetOperationTableQuery());
LoadOperation<StaticUser> loadOp1 = this.equity.Load(this.equity.GetStaticUsersQuery());
loadOp.Completed += new EventHandler(loadOp_Completed);
loadOp1.Completed += new EventHandler(loadOp1_Completed);
void loadOp_Completed(object sender, EventArgs e) {
l1 = true;
JiaZai();
}
void loadOp1_Completed(object sender, EventArgs e)
{
l2 = true;
JiaZai();
}
void JIaZai()
{
if(l1==true && l2==true)
{
var equity=from tp1 in this.equity.OperationTable from tp2 in this.equity.StaticUser where tp2.Id==tp1.Id select tp1;
}
}
Static
