entity framework core 调用存储过程和方法

　　目前EF Core调用存储过程，限制很多，比如返回结果必须是定义好的DbSet<>等等。这里用一种曲线救国的方式,自定义两个方法，用原始ado.net解决问题。以MySql数据库为例，代码如下：

 namespace WebApi.Core.Data

 {

     using System.Data;

     using System.Linq;

     using Microsoft.EntityFrameworkCore;

     using MySql.Data.MySqlClient;

     public class TestContext : DbContext

     {

         public TestContext(DbContextOptions<TestContext> options)

             : base(options)

         {

         }

         public int ExcuteProcedure(string parcedureName, params MySqlParameter[] ps)

         {

             using (var cmd = this.Database.GetDbConnection().CreateCommand())

             {

                 cmd.CommandText = parcedureName;

                 cmd.CommandType = CommandType.StoredProcedure;

                 cmd.Parameters.AddRange(ps);

                 this.Database.OpenConnection();

                 var r = cmd.ExecuteNonQuery();

                 this.Database.CloseConnection();

                 return r;

             }

         }

         public object ExcuteFunction(string functionName, params MySqlParameter[] ps)

         {

             using (var cmd = this.Database.GetDbConnection().CreateCommand())

             {

                 // 参数字符串，传参时注意顺序

                 var pString =

                     $"'{ps.Aggregate(string.Empty, (c, n) => $"{c}','{n.Value}").TrimStart(new[] { ',', '\'' })}'";

                 // 可用this.Database.IsXXX()，判读数据库类型，拼command字符串，这里不写了

                 cmd.CommandText = $"select {functionName}({pString});";

                 this.Database.OpenConnection();

                 var r = cmd.ExecuteScalar();

                 this.Database.CloseConnection();

                 return r;

             }

         }

         protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)

         {

         }

     }

 }