sqlsugar 联表查询报错 返回
OrderPay 表 ,Orders 表 都有CustomerId
/// <summary>
/// 备 注:客户Id
/// 默认值:
///</summary>
[SugarColumn(ColumnName = "CustomerId")]
public string CustomerId { get; set; } = null!;
/// <summary>
/// 备 注:客户Id
/// 默认值:
///</summary>
[SugarColumn(ColumnName = "CustomerId")]
public string CustomerId { get; set; }= null!;
var orderPays = await _orderRepository.Db.Queryable<OrderPay>()
.LeftJoin<Orders>((aa,or)=>aa.OrderId==or.Id)
.Where((aa, or) => aa.OrderId == orderId && aa.CheckState!= OrderPayCheckStateEnum.Reject)
.Select((aa, or) =>
new OrderPayResDto
{
CustomerId= aa.CustomerId,
OrderPayId= aa.Id,
OrderNo= or.OrderNo
}, true
).ToListAsync();
这为啥指定aa表 会提示别名不存在
热忱回答(1)
-
草帽尖顶着天 VIP0
2026/2/5撤回,表字段加错库了
0 回复