SQLUpdater Methods |
The SQLUpdater type exposes the following members.
Methods| Name | Description | |
|---|---|---|
 | AddColumn(IField, SQLColumnFlags) |
Adds a column to the class using data and configuration from the specified IField.
|
| AddColumn(String, Object, OleDbType) |
Adds a column to the class.
|
| AddColumn(String, Object, OleDbType, Int32) |
Adds a column to the class truncating if necessary.
|
| AddColumn(String, Object, OleDbType, Int32, SQLColumnFlags) |
Adds a column to the class truncating if necessary.
|
| AddColumnPerSchema |
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.
|
| AddExpression |
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.
|
| Equals | (Inherited from Object.) |
| Execute(SQLHelperFlags, String) |
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(IDatabase, SQLHelperFlags, String) |
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(IDatabase, SQLHelperFlags, String, Int32) |
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.
|
 | Finalize | Allows an Object to attempt to free resources and perform other cleanup operations before the Object is reclaimed by garbage collection. (Inherited from Object.) |
| GetHashCode | Serves as a hash function for a particular type. (Inherited from Object.) |
| GetType | Gets the Type of the current instance. (Inherited from Object.) |
| MemberwiseClone | Creates a shallow copy of the current Object. (Inherited from Object.) |
| ToString | (Inherited from Object.) |
| ToString(DBMSType) |
Returns the UPDATE statement
|
| ToString(DBMSType, SQLHelperFlags) |
Returns the UPDATE statement
|
Extension Methods| Name | Description | |
|---|---|---|
 | AddColumn |
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.
(Defined by MapperExtensions.) |
| EqualValue |
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.
(Defined by EAPUtil.) |
See Also