C# (CSharp) Simple.Data.Ado CommandHelper.TryExecuteNonQuery Exemples

Exemple #1

        internal IDictionary <string, object> ExecuteSingletonQuery(string insertSql, string selectSql, IEnumerable <Column> columns, IEnumerable <Object> values)
        {
            if (_transaction != null)
            {
                var command = new CommandHelper(_adapter).CreateInsert(_transaction.Connection, insertSql, columns, values.ToArray());
                command.Transaction = _transaction;
                command.TryExecuteNonQuery();
                command.CommandText = selectSql;
                command.Parameters.Clear();
                return(TryExecuteSingletonQuery(command));
            }

            var connection = _connection ?? _adapter.CreateConnection();

            using (connection.MaybeDisposable())
            {
                using (var command = new CommandHelper(_adapter).CreateInsert(connection, insertSql, columns, values.ToArray()))
                {
                    connection.OpenIfClosed();
                    command.TryExecuteNonQuery();
                    command.CommandText = selectSql;
                    command.Parameters.Clear();
                    return(TryExecuteSingletonQuery(command));
                }
            }
        }

Exemple #2

        internal int Execute(string sql, IEnumerable <Column> columns, IEnumerable <Object> values)
        {
            if (_transaction != null)
            {
                var command = new CommandHelper(_adapter).CreateInsert(_transaction.Connection, sql, columns, values.ToArray());
                command.Transaction = _transaction;
                return(command.TryExecuteNonQuery());
            }
            var connection = _connection ?? _adapter.CreateConnection();

            using (connection.MaybeDisposable())
            {
                using (var command = new CommandHelper(_adapter).CreateInsert(connection, sql, columns, values.ToArray()))
                {
                    connection.OpenIfClosed();
                    return(command.TryExecuteNonQuery());
                }
            }
        }

Exemple #3

Fichier : MysqlCustomInserter.cs Projet : andy01pr/Simple.Data.Mysql

 private static int Execute(AdoAdapter adapter, string sql, IEnumerable<Column> columns, IEnumerable<Object> values,
                     IDbTransaction transaction)
 {
     if (transaction != null)
     {
         var command = new CommandHelper(adapter).CreateInsert(transaction.Connection, sql, columns,
                                                               values.ToArray());
         command.Transaction = transaction;
         return command.TryExecuteNonQuery();
     }
     var connection = adapter.CreateConnection();
     using (connection.MaybeDisposable())
     {
         using (var command = new CommandHelper(adapter).CreateInsert(connection, sql, columns, values.ToArray())
             )
         {
             connection.OpenIfClosed();
             return command.TryExecuteNonQuery();
         }
     }
 }

Exemple #4

Fichier : AdoAdapterInserter.cs Projet : JorgeGamba/Simple.Data

 internal int Execute(string sql, IEnumerable<Column> columns, IEnumerable<Object> values)
 {
     if (_transaction != null)
     {
         var command = new CommandHelper(_adapter).CreateInsert(_transaction.Connection, sql, columns, values.ToArray());
         command.Transaction = _transaction;
         return command.TryExecuteNonQuery();
     }
     var connection = _connection ?? _adapter.CreateConnection();
     using (connection.MaybeDisposable())
     {
         using (var command = new CommandHelper(_adapter).CreateInsert(connection, sql, columns, values.ToArray()))
         {
             connection.OpenIfClosed();
             return command.TryExecuteNonQuery();
         }
     }
 }

Exemple #5

Fichier : AdoAdapterInserter.cs Projet : JorgeGamba/Simple.Data

        internal IDictionary<string, object> ExecuteSingletonQuery(string insertSql, string selectSql, IEnumerable<Column> columns, IEnumerable<Object> values)
        {
            if (_transaction != null)
            {
                var command = new CommandHelper(_adapter).CreateInsert(_transaction.Connection, insertSql, columns, values.ToArray());
                command.Transaction = _transaction;
                command.TryExecuteNonQuery();
                command.CommandText = selectSql;
                command.Parameters.Clear();
                return TryExecuteSingletonQuery(command);
            }

            var connection = _connection ?? _adapter.CreateConnection();
            using (connection.MaybeDisposable())
            {
                using (var command = new CommandHelper(_adapter).CreateInsert(connection, insertSql, columns, values.ToArray()))
                {
                    connection.OpenIfClosed();
                    command.TryExecuteNonQuery();
                    command.CommandText = selectSql;
                    command.Parameters.Clear();
                    return TryExecuteSingletonQuery(command);
                }
            }
        }