Exemple #1
0
 protected IEnumerable <TResult> GetAffectedRowsResultsMultiple <TResult>(IDbTransaction transaction = null, int?commandTimeout = null, CommandType?commandType = null)
 {
     foreach (Query query in GetQueries())
     {
         SqlResult          compiler     = Compiler.Compile(query);
         int                affectedRows = Connection.Execute(compiler.Sql, compiler.NamedBindings, transaction, commandTimeout, commandType);
         ResultAffectedRows result       = new ResultAffectedRows
         {
             AffectedRows = affectedRows,
             ResultType   = ResultTypeGlobal
         };
         yield return(ChangeTypeToType <TResult>(result));
     }
 }
Exemple #2
0
        protected async Task <IEnumerable <TResult> > GetAffectedRowsResultsMultipleAsync <TResult>(IDbTransaction transaction = null, int?commandTimeout = null, CommandType?commandType = null)
        {
            IList <TResult> results = new List <TResult>();

            foreach (Query query in GetQueries())
            {
                SqlResult compiler     = Compiler.Compile(query);
                int       affectedRows = await Connection.ExecuteAsync(compiler.Sql, compiler.NamedBindings, transaction, commandTimeout, commandType);

                ResultAffectedRows result = new ResultAffectedRows
                {
                    AffectedRows = affectedRows,
                    ResultType   = ResultTypeGlobal
                };
                results.Add(ChangeTypeToType <TResult>(result));
            }
            return(results);
        }