Question

我组成了以下准则问题,但造成错误。

mcc_season is not an Depende in mcc_product

我有2个<代码>的问询。 WHERE conditions and both from different entities in the participation

var guestCardProduct =
           (from c in CrmOrgServiceContext.mcc_productpriceSet
            join d in CrmOrgServiceContext.mcc_productSet
            on c.mcc_product.Id equals d.mcc_productId
            where d.mcc_producttype.Value == (int)mcc_product.mcc_producttypeOptionSet.GuestCard
            && c.mcc_season.Id == seasonId
            select new
            {
                d.mcc_productId,
                c.mcc_price
            }).FirstOrDefault();

Answer 1

您可以重新做如下工作:

var guestCardProduct = 
           (from c in CrmOrgServiceContext.mcc_productpriceSet 
            where c.mcc_season.Id == seasonId
            join d in CrmOrgServiceContext.mcc_productSet 
            on c.mcc_product.Id equals d.mcc_productId 
            where d.mcc_producttype.Value == (int)c.mcc_product.mcc_producttypeOptionSet.GuestCard 
            select new 
            { 
                d.mcc_productId, 
                c.mcc_price 
            }).FirstOrDefault();

我们在此假设,乳房主之间的关系是1-0.1。 Set and both mcc_season and mcc_product and also a 1 - 0.1 relationship between mcc_product and mcc_producttype 备选案文Set。如果你在其中任何一种财产之间有1-n关系,那么你就不得不通过这些关系开展工作,而不是把他们混入单一财产,因为你将收集儿童物品而不是一个儿童物品。你可能认为,把你的询问分成小部分,以缩小问题的根源是有益的。

友情链接