如何从EF Core调用PostgreSQL存储过程?

Question

我想调用我从数据库中编写的函数，但结果是-1请帮助

数据库:Postgresql

var result = _context.Database.ExecuteSqlRaw($"select * from subunit({unitId})");

Answer 1

函数类

[Keyless]
public  class SubUnit
{

public string Unit { get; set; }

}

我们向DbContext类

添加了以下引用

public virtual DbSet<SubUnit> SubUnits { get; set; }

调用函数码

public IEnumerable<Unit> GetSubUnitByParentId(long unitId)
{
var result = _context.SubUnits.FromSqlInterpolated($"select * from subunit({unitId})");

return result;
}

its run successfully .