实体框架内连接

发布于 2024-11-06 02:59:28 字数 397 浏览 1 评论 0原文

我正在尝试在客户、订单、订单详细信息和产品之间加入

我使用以下内容生成内部联接查询

IQueryable<Customer> CustomerList = ent.Customer
                                     .Include("orders").Include("orders.orderdetails")
                                      .include(orders.orderdetails.products)

我需要与这些表生成内部联接，以便我可以在 where 子句中检查姓氏和名字，但它正在生成左外部加入。

如何使用这些表生成内部联接

谢谢

原文

I am trying to join between customers,orders,orderdetails and products

I used the following to generate an inner join query

IQueryable<Customer> CustomerList = ent.Customer
                                     .Include("orders").Include("orders.orderdetails")
                                      .include(orders.orderdetails.products)

I need to generate an inner join with these tables so that i can check surname and firstname in where clause but it is generating left outer join.

How to generate an inner join with these tables

thanks

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

嗳卜坏 2024-11-13 02:59:28

var query = from OrdersDetails od in ent.OrdersDetails
            select new {
                od.Orders.Customers.FirtsName,
                od.Orders.OrderDate,
                ....
            }

希望有帮助。

var query = from OrdersDetails od in ent.OrdersDetails
            select new {
                od.Orders.Customers.FirtsName,
                od.Orders.OrderDate,
                ....
            }

Hope it helps.

回复收藏 0 原文

江挽川 2024-11-13 02:59:28

尝试这个

            var v = from en in context.Entity
                let leftouter = (from pa in en.PostalAddress
                                 select new
                                 {
                                     pa.PostalAddressID
                                 }).FirstOrDefault()
                select new
                {
                    EntityID = en.EntityID,
                    PostalAddressID = (Guid?)leftouter.PostalAddressID,
                };

引用自 http://geekswithblogs.net/SudheersBlog/archive/2009 /06/11/132758.aspx

try this

            var v = from en in context.Entity
                let leftouter = (from pa in en.PostalAddress
                                 select new
                                 {
                                     pa.PostalAddressID
                                 }).FirstOrDefault()
                select new
                {
                    EntityID = en.EntityID,
                    PostalAddressID = (Guid?)leftouter.PostalAddressID,
                };

refered from http://geekswithblogs.net/SudheersBlog/archive/2009/06/11/132758.aspx

回复收藏 0 原文

~没有更多了~