如何使用标志字段连接linq中的多个表
如何使用标志字段连接linq中的多个表
提问于 2014-01-16 06:44:42
这是连接查询代码，其中包含3个表--一个tbl发票、tblClient、TblCustomer。在Tbl发票中包含一个标志字段，其中包含" customer“，然后我需要加入发票和客户表，或者它包含客户端，然后我需要加入发票和客户表，请帮助我的朋友们。。。
public class InvoiceJoin
{
private TblInvoice invoice;
private TblClient client;
private TblCustomer Customer;
public InvoiceJoin(TblInvoice invoice, TblClient client)
{
this.invoice = invoice;
this.client = client;
//this.Customer = Customer;
//...
}
public string RakeNumber { get { return invoice.RakeNumber; } set { invoice.RakeNumber = value; } }
public string partyCode { get { return invoice.ReceiverCode; } set { invoice.ReceiverCode = value; } }
public string invoiceNum { get { return invoice.InvoiceNumber; } set { invoice.InvoiceNumber = value; } }
//... ather invoice properties you want to see in grid
public string ClientCode { get { return client.ClientCode; } set { client.ClientCode = value; } }
public string ClientName { get { return client.ClientAddress1; } set { client.ClientAddress1 = value; } }
// ...ather clientproperties you want to see in grid
}和我的数据加载方法
List<InvoiceJoin> datalist = (from invoice in _godownEntity.TblInvoices
join client in _godownEntity.TblClients
on invoice.ReceiverCode equals client.ClientCode
select new { Invoice = invoice, Client = client }).ToList() // until this road will be done on SQL servrer
.Select(n => new InvoiceJoin(n.Invoice, n.Client)).ToList();回答 1
Stack Overflow用户
回答已采纳
发布于 2014-01-16 08:33:53
如果您询问如何在Linq中连接这些表，这是语法(如果是，告诉注释)：将主键和外键放在X&Y上
var Query = (from invoice in _godownEntity.TblInvoices
join client in _godownEntity.TblClients on invoice.ReceiverCode equals client.ClientCode
join customer in _godownEntity.TblCustomers on invoice.**X** equals customer.**Y**
select *WHAT U WANT*页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：
https://stackoverflow.com/questions/21155001
复制相关文章
相似问题
腾讯云开发者
