EntityFrameworkCore.KingbaseES
EntityFrameworkCore.KingbaseES copied to clipboard
dotnetcore
Entity Framework Core provider for KingbaseES Database
query.Select(q => q.ActionStudies.Sum(v => v.Count)).ToArray() query.Sum(q => q.ActionStudies.Select(a => a.Count).Sum()) query.SelectMany(q => q.ActionStudies.Select(v => v.Count)).Sum(); 以上任意一种表达式都不行， ActionStudies是一个子表的集合字段， count是ActionStudies子表的中的一个字段。
`Kdbndp.KingbaseException (0x80004005): 3D000: database "postgres" does not exist at Kdbndp.KdbndpConnector.c__DisplayClass166_0.d.MoveNext() --- End of stack trace from previous location --- at Kdbndp.KdbndpConnector.c__DisplayClass166_0.d.MoveNext() --- End of stack trace from previous location ---...
WHERE (@__a_0 = '') OR (((b."SiteName" IS NOT NULL)) AND ((b."SiteName" LIKE @__a_0 || '%' ESCAPE '') AND (left(b."SiteName", length(@__a_0))::text = @__a_0::text))) ESCAPE 附近有语法错误，貌似是缺少括号 应该是 (b."SiteName" LIKE @__a_0 || '%')...
如下, linq语句的group by中包含Year/Month时会抛例外，BegDate在c#中的类型为Datetime, 在数据库中为 timestamp without time zone. ``` group q by new { q.LineSeq, YearMonth = new { Year = q.BegDate.Year, Month = q.BegDate.Month } }; ``` 例外： ```log...
The LINQ expression 'DbSet() .GroupJoin( inner: DbSet() .Where(v => v.EndDate < __now_0 || v.EndDate == null && (int?)v.OrgAuditState == (int?)已通过), outerKeySelector: user => (Guid?)user.Id, innerKeySelector: record => record.TraineeId, resultSelector: (user,...
Metadata
Owner
Metadata
Entity Framework Core provider for KingbaseES Database