报表查询-大数据处理报错对象名 'SingleColumnEntity`1' 无效。返回

SqlSugar 沟通中

 5  125

悬赏：0 飞吻

//创建临时表 (用真表兼容性好，表名随机)

tableName = "TempEventIds" + SnowFlakeSingle.Instance.NextId();

Thread.Sleep(500);

var type2 = db.DynamicBuilder().CreateClass(tableName, new SugarTable())

.CreateProperty("ColumnName", typeof(Guid), new SugarColumn() { IsPrimaryKey = true })//主键不要自增

.BuilderType();

Thread.Sleep(500);

db.CodeFirst.InitTables(type2);//创建表

Thread.Sleep(500);

//将集合插入临时表

var insertData = checkEventIds.Select(it => new SingleColumnEntity<Guid>() { ColumnName = it.Value }).ToList();

Thread.Sleep(500);

db.Fastest<SingleColumnEntity<Guid>>().AS(tableName).BulkCopy(insertData);

Thread.Sleep(500);

filerEventIdSql = $" AND EXISTS (SELECT 1 FROM {tableName} e WHERE e.ColumnName = t.EventId)";

热忱回答（5）