從物體框架接收資料的執行程式

Oracle 中的資料庫 - 查看：

     COLUMN_NAME | DATE_TYPE
___________________________________________________
 UMOWA           | VARCHAR2(30)
 RODZ_LEAS       | VARCHAR2(1)
  KTH            | NUMBER(10)
  SKRóT          | VARCHAR2(50)
 NAZWA           | VARCHAR2(240)
 AMORTYZ         | NUMBER(10,6)
 WALUTA          | VARCHAR2(3)
WARTOSC_UMW      | NUMBER
  LICZBA_RAT     | NUMBER
WK               | NUMBER
 WK%             | NUMBER
Rodzaj stopy baz.|  VARCHAR2(2000)
Wart.stopy baz.  | NUMBER
REFI             | NUMBER
RA_NR_RATY       | NUMBER(10)
RA_TYP           | VARCHAR2(10)
RA_DATA_SPLATY   | DATE
RA_KWOTA_NETTO   | NUMBER(12,2)
RA_KAPITAL_POZOSTALY   | NUMBER(12,2)

SQL Server 中的程序 - 它有效 - 我從 Oracle 獲取資料。

CREATE PROCEDURE [egeria].[ContractData_P] (@ContractNumberPar varchar(20))
AS
    EXECUTE(
        'Select 
            Umowa ContractNumber
            , Rodz_leas TypeOfLeasing
            , Kth CodeClient
            , skrót Short
            , Nazwa NameOfClient
            , amortyz Amortization
            , Waluta Currency
            , Wartosc_Umw ContractValue
            , Liczba_rat NumberOfInstallments
            , WK FinalValue
            , "WK%" FinalValuePercent
            , "Rodzaj stopy baz." TypeOfBaseRate
            , "Wart.stopy baz." ValueOfBaseRate
            , REFI
            , ra_nr_raty InstallmentNumber
            , ra_typ Type
            , ra_data_splaty MaturityDate
            , ra_kwota_netto NetAmount
            , ra_kapital_pozostaly CapitalRemaining
        from RAPADM.XLS_SKROCENIA_UMOW_V 
        where UMOWA  = ?'
        , @ContractNumberPar) AT EF_EG5PROD
GO

模型

public class ContractData
{
    public string ContractNumber { get; }
    public string TypeOfLeasing { get; }
    public int CodeClient { get; }
    public string Short { get; }
    public string NameOfClient { get; }
    public decimal Amortization { get; }
    public string Currency { get; }
    public decimal ContractValue { get; }
    public decimal NumberOfInstallments { get; }
    public decimal FinalValue { get; }
    public decimal FinalValuePercent { get; }
    public string TypeOfBaseRate { get; }
    public decimal ValueOfBaseRate { get; }
    public decimal REFI { get; }
    public decimal InstallmentNumber { get; }
    public string Type { get; }
    public DateTime MaturityDate { get; }
    public decimal NetAmount { get; }
    public decimal CapitalRemaining { get; }
}

語境

public class AppDbContext : DbContext
{
    public AppDbContext(DbContextOptions<AppDbContext> options) 
        : base(options)
    {
    }

    public virtual DbSet<ContractData> ContractData { get; set; }

    protected override void OnModelCreating(ModelBuilder modelBuilder)
    {
        base.OnModelCreating(modelBuilder);

        modelBuilder.Entity<ContractData>().HasNoKey();          
    }
}

ContractDataService - 這里我有錯誤

private readonly AppDbContext _context;

public ContractDataService(AppDbContext context)
{
    _context = context;
}

public async Task<IEnumerable<ContractData>> ExecAsync(string contractNumberPar)
{
    var data = _context.ContractData.FromSqlRaw("EXECUTE [egeria].[ContractData_P] @ContractNumberPar", contractNumberPar).AsEnumerable();
    return data;
}

錯誤：

system.InvalidOperationException：序列在 Microsoft.EntityFrameworkCore.Query.RelationalShapedQueryCompilingExpressionVisitor.ShaperProcessingExpressionVisitor.VisitBinary(BinaryExpression binaryExpression) 在 System.Linq.Enumerable.Max(IEnumerable`1 source) 的 System.Linq.ThrowHelper.ThrowNoElementsException() 中不包含任何元素.Linq.Expressions.ExpressionVisitor.Visit(Expression node) at System.Dynamic.Utils.ExpressionVisitorUtils.VisitBlockExpressions(ExpressionVisitor visitor, BlockExpression block) at System.Linq.Expressions.ExpressionVisitor.VisitBlock(BlockExpression node) at System.Linq.Expressions。 BlockExpression.Accept(ExpressionVisitor visitor) 在 System.Linq.Expressions.ExpressionVisitor.Visit(Expression node) 在 Microsoft.EntityFrameworkCore.Query.RelationalShapedQueryCompilingExpressionVisitor。ShaperProcessingExpressionVisitor.VisitExtension(Expression extensionExpression) at System.Linq.Expressions.Expression.Accept(ExpressionVisitor visitor) at System.Linq.Expressions.ExpressionVisitor.Visit(Expression node) at Microsoft.EntityFrameworkCore.Query.RelationalShapedQueryCompilingExpressionVisitor.ShaperProcessingExpressionVisitor.ProcessShaper(Expression shaperExpression , RelationalCommandCache&relationalCommandCache, LambdaExpression&relatedDataLoaders, Int32&collectionId) 在ProcessShaper(Expression shaperExpression, RelationalCommandCache&relationalCommandCache, LambdaExpression&relatedDataLoaders, Int32&collectionId) 在ProcessShaper(Expression shaperExpression, RelationalCommandCache&relationalCommandCache, LambdaExpression&relatedDataLoaders, Int32&collectionId) 在

有誰知道如何做到這一點？我應該走另一條路嗎？

請檢查我正在做的事情是否有任何意義，或者走更好的路不是更好嗎？

uj5u.com熱心網友回復：

EF Core 無法創建投影運算式，因為 的所有屬性ContractNumber都是只讀的。添加設定器來解決您的問題：

public class ContractData
{
    public string ContractNumber { get; set; }
    public string TypeOfLeasing { get; set; }
    public int CodeClient { get; set; }
    public string Short { get; set; }
    public string NameOfClient { get; set; }
    public decimal Amortization { get; set; }
    public string Currency { get; set; }
    public decimal ContractValue { get; set; }
    public decimal NumberOfInstallments { get; set; }
    public decimal FinalValue { get; set; }
    public decimal FinalValuePercent { get; set; }
    public string TypeOfBaseRate { get; set; }
    public decimal ValueOfBaseRate { get; set; }
    public decimal REFI { get; set; }
    public decimal InstallmentNumber { get; set; }
    public string Type { get; set; }
    public DateTime MaturityDate { get; set; }
    public decimal NetAmount { get; set; }
    public decimal CapitalRemaining { get; set; }
}

標籤：C＃ 网 sql服务器 实体框架 林克

上一篇：具有通用包含的EntityFramework通用服務

下一篇：將此SQL查詢轉換為LINQ