Example #1
0
        /// <summary>
        /// Executes the specified stored procedure against a database.
        /// </summary>
        /// <param name="database">The database to execute against.</param>
        /// <param name="storedProcedure">The stored procedure to execute.</param>
        public static void ExecuteStoredProcedure(this Database database, object storedProcedure)
        {
            if (storedProcedure == null)
            {
                throw new ArgumentNullException(nameof(storedProcedure));
            }

            var info = StoredProcedureParser.BuildStoredProcedureInfo(storedProcedure);

            // ReSharper disable once CoVariantArrayConversion
            database.ExecuteSqlCommand(info.Sql, info.SqlParameters);

            SetOutputParameterValues(info.SqlParameters, storedProcedure);
        }
Example #2
0
        /// <summary>
        /// Executes the specified stored procedure against a database and returns an enumerable of T
        /// representing the data returned.
        /// </summary>
        /// <typeparam name="T">Type of the data returned from the stored procedure.</typeparam>
        /// <param name="database">The database to execute against.</param>
        /// <param name="storedProcedure">The stored procedure to execute.</param>
        /// <returns></returns>
        public static IEnumerable <T> ExecuteStoredProcedure <T>(this Database database, object storedProcedure)
        {
            if (storedProcedure == null)
            {
                throw new ArgumentNullException(nameof(storedProcedure));
            }

            var info = StoredProcedureParser.BuildStoredProcedureInfo(storedProcedure);

            // ReSharper disable once CoVariantArrayConversion
            var result = database.SqlQuery <T>(info.Sql, info.SqlParameters).ToList();

            SetOutputParameterValues(info.SqlParameters, storedProcedure);

            return(result);
        }