我使用了EntityFramework6.2,并注意到Distinct忽略了我的OrderBy子句。我有课:
public class Order
{
public int Id { get; set; }
public string PartnerId { get; set; }
// Other properties removed for clarity.
}
想得到我的最后20名合伙人:
var list = db.Orders.AsNoTracking()
.OrderByDescending(obj => obj.Id)
.Select(x =&g
SELECT deals.id,
deals.partner_id
FROM deals
LEFT JOIN deals_partners
ON ( deals.id = deals_partners.deal_id )
WHERE 1
AND ( `deals`.`partner_id` = 222
OR CASE
WHEN deals.partner_count = 1 THEN
deals_p
我想做这样的事:
流必须与:有关系
一个应用程序或
合伙人
我的流程肯定有这两种关系之一。我试过这样做:
MATCH (c:Flow)-[y:AppliFlux]-(d:Application)
OPTIONAL MATCH (c)-[r:FlowPart]-(e:Partner)
return c
但它没有归还我需要的东西。谢谢你的帮忙