EF用户定义的功能迁移

Question

我正在尝试使用实体框架添加用户定义的功能。

我已经定义了它们如下：

public IQueryable<GetProjectInspectionsFunctionResult> GetProjectInspections(int clientId, int projectId) => FromExpression(() => GetProjectInspections(clientId, projectId));
public IQueryable<GetProjectItemsFunctionResult> GetProjectItems(int clientId, int projectId) => FromExpression(() => GetProjectItems(clientId, projectId));
public IQueryable<GetProjectLopItemsFunctionResult> GetProjectLopItems(int clientId, int projectId) => FromExpression(() => GetProjectLopItems(clientId, projectId));
public IQueryable<GetProjectAttachmentsFunctionResult> GetProjectAttachments(int clientId, int projectId) => FromExpression(() => GetProjectAttachments(clientId, projectId));

modelBuilder.HasDbFunction(typeof(QAppDbContext).GetMethod(nameof(GetProjectInspections))).HasName("fn_GetProjectInspections");
modelBuilder.HasDbFunction(typeof(QAppDbContext).GetMethod(nameof(GetProjectItems))).HasName("fn_GetProjectItems");
modelBuilder.HasDbFunction(typeof(QAppDbContext).GetMethod(nameof(GetProjectLopItems))).HasName("fn_GetProjectLopItems");
modelBuilder.HasDbFunction(typeof(QAppDbContext).GetMethod(nameof(GetProjectAttachments))).HasName("fn_GetProjectAttachments");

都有配置

public class GetProjectInspectionsConfiguration : IEntityTypeConfiguration<GetProjectInspectionsFunctionResult>
{
     public void Configure(EntityTypeBuilder<GetProjectInspectionsFunctionResult> builder)
     {
          builder.HasNoKey();
     }
}

我还为每个功能

migrationBuilder.Sql(
     @"CREATE FUNCTION [dbo].[fn_GetProjectInspections]
        (@clientId INT, @projectId INT)
     RETURNS TABLE
     AS
     RETURN
     (
        WITH clients AS(...)
        SELECT...
     )"
)

在dbContext中， dbcontextsnapshot因为EF添加.totable（null） for for evernuction -cartion类型（例如 getProjectInSpectionsFunctionFunctionFunctionResult ）。

有没有办法克服这种情况？我认为我需要避免任何类型的注释（表，功能等）？

Answer 1

我通过明确指定每个功能结果实体的名称（由方法过载引起）来解决问题：

modelBuilder.Entity<GetProjectInspectionsFunctionResult>((x) =>
{
    x.HasNoKey();
    x.ToTable(name: null);
})