我有以下实体Space
,它的集合为SpaceMessage
public class Space
{
public int Id { get; set; }
[UsePaging(IncludeTotalCount = true, MaxPageSize = 50)]
public ICollection<SpaceMessage> Messages { get; set; } = new HashSet<SpaceMessage>();
}
该查询定义为
[UseFirstOrDefault]
[UseProjection]
[UseFiltering]
public IQueryable<Space> GetSpace(ApplicationDbContext dbContext, int id)
{
return dbContext.Spaces.Where(e => e.Id == id);
}
现在,我想使用分页来查询空间1的消息.
query {
space(id: 1) {
messages(first: 1) {
edges {
node {
id
}
}
}
}
}
,但返回空集合.
{
"data": {
"space": {
"messages": {
"edges": []
}
}
}
}
这是因为SQL没有加入按摩表
info: Microsoft.EntityFrameworkCore.Database.Command[20101]
Executed DbCommand (43ms) [Parameters=[@__id_0='?' (DbType = Int32)], CommandType='Text', CommandTimeout='30']
SELECT 1
FROM [Spaces] AS [s]
WHERE [s].[Id] = @__id_0
如果有任何解决办法,我们将不胜感激.