C# DBConnection.ExecuteNonQueryCommand方法代码示例

        /// <summary>
        /// Executes this command against the specified database connection and returns the auto-increment value of the inserted row, or null if it is not an
        /// auto-increment table.
        /// </summary>
        public object Execute( DBConnection cn )
        {
            var cmd = cn.DatabaseInfo.CreateCommand();
            cmd.CommandText = "INSERT INTO " + table;
            if( columnModifications.Count == 0 )
                cmd.CommandText += " DEFAULT VALUES";
            else {
                cmd.CommandText += "( ";
                foreach( var columnMod in columnModifications )
                    cmd.CommandText += columnMod.ColumnName + ", ";
                cmd.CommandText = cmd.CommandText.Substring( 0, cmd.CommandText.Length - 2 );
                cmd.CommandText += " ) VALUES( ";
                foreach( var columnMod in columnModifications ) {
                    var parameter = columnMod.GetParameter();
                    cmd.CommandText += parameter.GetNameForCommandText( cn.DatabaseInfo ) + ", ";
                    cmd.Parameters.Add( parameter.GetAdoDotNetParameter( cn.DatabaseInfo ) );
                }
                cmd.CommandText = cmd.CommandText.Substring( 0, cmd.CommandText.Length - 2 );
                cmd.CommandText += " )";
            }
            cn.ExecuteNonQueryCommand( cmd );

            if( !cn.DatabaseInfo.LastAutoIncrementValueExpression.Any() )
                return null;
            var autoIncrementRetriever = cn.DatabaseInfo.CreateCommand();
            autoIncrementRetriever.CommandText = "SELECT {0}".FormatWith( cn.DatabaseInfo.LastAutoIncrementValueExpression );
            var autoIncrementValue = cn.ExecuteScalarCommand( autoIncrementRetriever );
            return autoIncrementValue != DBNull.Value ? autoIncrementValue : null;
        }

 /// <summary>
 /// Executes this command against the specified database connection and returns the number of rows affected.
 /// </summary>
 public int Execute( DBConnection cn )
 {
     if( conditions.Count == 0 )
         throw new ApplicationException( "Executing an inline delete command with no parameters in the where clause is not allowed." );
     var command = cn.DatabaseInfo.CreateCommand();
     command.CommandText = "DELETE FROM " + tableName + " WHERE ";
     var paramNumber = 0;
     foreach( var condition in conditions ) {
         condition.AddToCommand( command, cn.DatabaseInfo, InlineUpdate.GetParamNameFromNumber( paramNumber++ ) );
         command.CommandText += " AND ";
     }
     command.CommandText = command.CommandText.Remove( command.CommandText.Length - 5 );
     return cn.ExecuteNonQueryCommand( command );
 }

        /// <summary>
        /// Executes this command against the specified database connection and returns the number of rows affected.
        /// </summary>
        public int Execute( DBConnection cn )
        {
            if( columnModifications.Count == 0 )
                return 0;
            if( conditions.Count == 0 )
                throw new ApplicationException( "Executing an inline update command with no parameters in the where clause is not allowed." );

            var command = cn.DatabaseInfo.CreateCommand();
            command.CommandText = "UPDATE " + tableName + " SET ";
            var paramNumber = 0;
            foreach( var columnMod in columnModifications ) {
                var parameter = columnMod.GetParameter( name: GetParamNameFromNumber( paramNumber++ ) );
                command.CommandText += columnMod.ColumnName + " = " + parameter.GetNameForCommandText( cn.DatabaseInfo ) + ", ";
                command.Parameters.Add( parameter.GetAdoDotNetParameter( cn.DatabaseInfo ) );
            }
            command.CommandText = command.CommandText.Remove( command.CommandText.Length - 2 );
            command.CommandText += " WHERE ";
            foreach( var condition in conditions ) {
                condition.AddToCommand( command, cn.DatabaseInfo, GetParamNameFromNumber( paramNumber++ ) );
                command.CommandText += " AND ";
            }
            command.CommandText = command.CommandText.Remove( command.CommandText.Length - 5 );
            return cn.ExecuteNonQueryCommand( command );
        }

        private void executeLongRunningCommand( DBConnection cn, string commandText )
        {
            var command = cn.DatabaseInfo.CreateCommand();
            command.CommandTimeout = 0; // This means the command can take as much time as it needs.
            command.CommandText = commandText;

            // NOTE: Not sure if this is the right execute method to use.
            cn.ExecuteNonQueryCommand( command );
        }

 /// <summary>
 /// Executes this sproc against the specified database connection and returns the number of rows affected.
 /// </summary>
 public int ExecuteNonQuery( DBConnection cn )
 {
     var cmd = cn.DatabaseInfo.CreateCommand();
     setupDbCommand( cmd, cn.DatabaseInfo );
     return cn.ExecuteNonQueryCommand( cmd );
 }