SQLUpserter Methods |
The SQLUpserter type exposes the following members.
Methods| Name | Description | |
|---|---|---|
 | AddColumn(String, Object, OleDbType, UpsertRoles) |
Adds a column to the class
|
| AddColumn(String, Object, OleDbType, UpsertRoles, Int32) |
Adds a column to the class, truncating if necessary.
|
| AddColumn(String, Object, OleDbType, UpsertRoles, 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 SQLInserter(IDatabase, String) constructor which must have been used in order to
use this method.
|
| AddExpression |
Adds a SQL expression string to the clause inserting or updating the specified column.
|
| AddFilter |
Add a filter clause. Typically a filter is added to the Match clause (and this is assumed if no role
is specified), but filters CAN be added to the other clauses.
|
| Equals | (Inherited from Object.) |
| Execute(String, SQLHelperFlags) |
Execute the SQL MERGE statement. Note that embedded functions are always resolved.
|
| Execute(String, SQLHelperFlags, Int32) |
Execute the SQL MERGE statement. Note that embedded functions are always resolved.
|
 | 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, SQLHelperFlags) |
Returns the MERGE statement.
|
Extension Methods| Name | Description | |
|---|---|---|
 | 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