报表查询 对象和表随意JOIN 提示 ',' 附近有语法错误 返回
好奇的粉丝 发布于1周前
实践三、对象和表随意JOIN
比如我们创建一个List对象，我们这个List对象就能和表进行Join了
var queryable2 = db.Reportable(List<实体>).ToQueryable(); var list= db.Queryable<Order>().InnerJoin(queryable2, (x1, x2) => x1.Id == x2.OrderId) .Select((x1, x2) => new { name = x1.Name, id = x1.Id, orderid = x2.OrderId }).ToList(); |
建了一个实体
public class day_state
{
public Int32 user_id = 0;
public DateTime date;
public string state = "";
}
//日期清单
var _datetime = Convert.ToDateTime("2023-02-01");//获取待统计月份
var days = (_datetime.AddMonths(1) - _datetime).Days;//获取某月天数
var dayArray = Enumerable.Range(1, days).Select(it => Convert.ToDateTime(_datetime.ToString("yyyy-MM-" + it))).ToList();//转成时间数组
var _queryableLeft = _dbInstance.Reportable(dayArray).ToQueryable<DateTime>();
//数据清单
List<day_state> _queryableRightModel = new List<day_state>();
_queryableRightModel.add 多条数据
var _queryableRight = _dbInstance.Reportable(_queryableRightLogModel).ToQueryable();
这句执行报错
var _resultList = _dbInstance.Queryable(_queryableLeft).LeftJoin(_queryableRight , (k1, k2) => k1.ColumnName == k2.date).ToList();
_queryableLeft 换成数据库表实体也是这个错误
',' 附近有语法错误。
AS ColumnName UNION ALL
SELECT CAST('2023-02-24 00:00:00.000' AS DATETIME)
AS ColumnName UNION ALL
SELECT CAST('2023-02-25 00:00:00.000' AS DATETIME)
AS ColumnName UNION ALL
SELECT CAST('2023-02-26 00:00:00.000' AS DATETIME)
AS ColumnName UNION ALL
SELECT CAST('2023-02-27 00:00:00.000' AS DATETIME)
AS ColumnName UNION ALL
SELECT CAST('2023-02-28 00:00:00.000' AS DATETIME)
AS ColumnName ) t ) [k1] Inner JOIN ( SELECT ,null as NoCacheColumn
UNION ALL
SELECT ,null as NoCacheColumn
UNION ALL
SELECT ,null as NoCacheColumn
UNION ALL
SELECT ,null as NoCacheColumn
UNION ALL
SELECT ,null as NoCacheColumn
请教大神这个要怎样调整
热忱回答（8）
-
fate sta VIP0
1周前我记得高版本修复过这个问题
捞述一下 ：是什么数据库,sqlsugar版本是多少
0 回复 -
好奇的粉丝 VIP0
1周前
sqlserver2008R2
sqlsugarscope 5.1.3.50
0 回复 -
好奇的粉丝 VIP0
1周前
升到5.1.4.58 也有这个提示
0 回复 -
fate sta VIP0
1周前
-
0 回复 -
fate sta VIP0
1周前
实体类错误
0 回复 -
fate sta VIP0
1周前
找到原因了
0 回复 -
fate sta VIP0
1周前
public Int32 user_id = 0;
改成
public Int32 user_id{ get;set;}
0 回复 -
好奇的粉丝 VIP0
1周前
好的，谢谢。。。
0 回复