c# - 如何在 EF Core 中转换字符串 Npgsqldate

Question

我一直坚持将字符串转换为 Npgsql

String dtTo="2020/07/01"

NpgsqlDate DateTo = NpgsqlDate.ToNpgsqlDate(Convert.ToDateTime(dtTo));

它给了我一个错误，提示没有为 CLR 类型“NpgsqlDate”找到到关系类型的映射

我的存储过程需要它：

regionalManager = "%";
        dtFrom = "2020-07-03";
        dtTo = "2020-07-07";
        string service_under = "%";
        string supervisor = "%";


        NpgsqlDate DateFrom = NpgsqlDate.Parse(dtFrom);
        NpgsqlDate DateTo = NpgsqlDate.Parse(dtTo);
        NpgsqlParameter p0 = new NpgsqlParameter("@drfrom", NpgsqlDbType.Date);
        NpgsqlParameter p1 = new NpgsqlParameter("@dtto", NpgsqlDbType.Date);
        NpgsqlParameter p2 = new NpgsqlParameter("@regionalmanager", NpgsqlDbType.Varchar);
        NpgsqlParameter p3 = new NpgsqlParameter("@serviceunder", NpgsqlDbType.Varchar);
        NpgsqlParameter p4 = new NpgsqlParameter("@supervisor", NpgsqlDbType.Varchar);
    
        var x = _db.dataInGlance.FromSqlRaw(@"SELECT * from wpv.avail_pro_failedbattry_error_powerconv(@p0,@p1,@p2,@p3,@p4)
                            res (o_availability double precision, o_production double precision,o_numberofturbines integer, o_errors_disabled integer,o_failed_battery integer,o_power integer,o_crew_present text)",DateFrom,DateTo,regionalManager,service_under,supervisor
                          ).ToList();

标签： c#