SQLUpdater Class

The default constructor.

Constructor with table name. Note: You must use the SQLUpdater(IDatabase, String, String) constructor in order to use AddColumnPerSchema(String, Object, SQLColumnFlags).

Constructor with table name and where clause. Note: You must use the SQLUpdater(IDatabase, String, String) constructor in order to use AddColumnPerSchema(String, Object, SQLColumnFlags).

Full constructor which allows for use of AddColumnPerSchema(String, Object, SQLColumnFlags) and Execute(SQLHelperFlags, String).

The number of columns being updated.

The primary key appropriate for providing to an IDatabase.Execute() call.

Retrieves the schema for the specified Table. Requires that the object was constructed with the SQLUpdater(IDatabase, String, String) constructor.

Gets/Sets the table that this class should using when building the UPDATE statement

Gets/Sets the WHERE clause that this class should using when building the UPDATE statement

Adds a column to the class using data and configuration from the specified IField.

Adds a column to the class.

Adds a column to the class truncating if necessary.

Adds a column to the class truncating if necessary.

Adds a column to the class if the column is found in the table's schema. The Schema is interrogated from the IDatabase object and for the Table provided in the object's SQLUpdater(IDatabase, String, String) constructor which must have been used in order to use this method.

Adds a literal expression to the UPDATE statement. The expression will be applied literally. For example, to increment the "quantity" column of a record, specify "quantity" for the name parameter and "quantity + 1" for the expr parameter. This will result in "quantity=quantity + 1" being included in the UPDATE statement.

Determines whether the specified Object is equal to the current Object.

Execute the SQL INSERT statement. Note that embedded functions are always resolved. Requires that the object was created with the SQLUpdater(IDatabase, String, String) constructor. Note that prior to v4.5.1 this method did NOT return a value.

Execute the SQL UPDATE statement. Note that embedded functions are always resolved. Note that prior to v4.5.1 this method did NOT return a value.

Execute the SQL UPDATE statement. Note that embedded functions are always resolved. Note that prior to v4.5.1 this method did NOT return a value.

Allows an Object to attempt to free resources and perform other cleanup operations before the Object is reclaimed by garbage collection.

Serves as a hash function for a particular type.

Gets the Type of the current instance.

Creates a shallow copy of the current Object.

Returns a String that represents the current Object.

Returns the UPDATE statement

Returns the UPDATE statement

Add a column to the updater corresponding to the specified field and using the specified value. If the field does not exist in the mapper then no action is taken.

Determines if the object value is equal to another object. If the two objects are null, then this returns true. There is special handling for guid comparisons (since a guid could be a string formatted in up to 3 different ways). If the special guid handling is not performed, then the object.Equals method is used.