我想在新的Entity Framework Core中使用存储过程。很快我就需要开始一个ASP.Net 5项目,但不确定Entity Framework是否适合这项工作。该应用程序将每分钟触发多个存储过程,并且我需要输出参数。EF是否适合此任务,还是应该使用ADO.Net?
我尝试过FromSql和database.ExecuteSqlCommand,但没有成功。
using (AppDbContext db = factory.Create())
{
var in1 = new SqlParameter
{
ParameterName = "ParamIn1",
DbType = System.Data.DbType.Int64,
Direction = System.Data.ParameterDirection.Input
};
var in2 = new SqlParameter
{
ParameterName = "ParamIn2",
DbType = System.Data.DbType.String,
Direction = System.Data.ParameterDirection.Input
};
var out1 = new SqlParameter
{
ParameterName = "ParamOut1",
DbType = System.Data.DbType.Int64,
Direction = System.Data.ParameterDirection.Output
};
var out2 = new SqlParameter
{
ParameterName = "ParamOut2",
DbType = System.Data.DbType.String,
Direction = System.Data.ParameterDirection.Output
};
var result = db.Database.ExecuteSqlCommand("exec spTestSp", in1, in2, out1, out2);
}
SqlParameter job1 = cmd2.Parameters.Add("@job", SqlDbType.VarChar, 50);
- JB's