.net core EF Core 调用存储过程

  截至目前EF Core 6版本， EF Core是不支持调用存储过程的，这就给我们项目开发造成了一定的局限性，为此给EF Core增加执行存储过程的扩展方法， 采用ADO来处理存储过程。

 public static class EntityFrameworkCoreExtensions
    {
        //创建SqlCommand
        private static DbCommand CreateCommand(DatabaseFacade facade, string sql, out DbConnection connection, params object[] parameters)
        {
            var conn = facade.GetDbConnection();
            connection = conn;
            conn.Open();
            var cmd = conn.CreateCommand();
            if (facade.IsSqlServer())
            {
                cmd.CommandText = sql;
                cmd.Parameters.AddRange(parameters);
            }
            return cmd;
        }

        //执行存储过程的扩展方法ExecuteSqlCommand
        public static int ExecuteSqlCommand([NotNull] this DatabaseFacade facade, string sql, [NotNull]params object[] parameters)
        {
            try
            {
                //创建SqlCommand
                var command = CreateCommand(facade, sql, out DbConnection conn, parameters);
                if (conn.State == ConnectionState.Open)
                {
                    command.CommandType = CommandType.StoredProcedure; //执行类型是存储过程
                    return command.ExecuteNonQuery();
                }
                return -1;
            }
            catch (Exception ex)
            {
                return -1;
            }
        }
    }

 使用方法：dbContext.Database.ExecuteSqlCommand("存储过程"，参数组)；