SQLInserter Methods |
The SQLInserter type exposes the following members.
Methods| Name | Description | |
|---|---|---|
 | 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 SQLInserter(IDatabase, String) constructor which must have been used in order to
use this method.
|
| Equals | (Inherited from Object.) |
| Execute(String) |
Execute the SQL INSERT statement. Note that embedded functions are always resolved.
Requires that the object was created with the SQLInserter(IDatabase, String) constructor.
Note that if you want to obtain the value of the IDENTITY value for the newly created record you must
use the Execute(String, Int32, Boolean, ExecuteOptions) overload.
|
| Execute(String, Boolean) |
Execute the SQL INSERT statement. Note that embedded functions are always resolved.
Requires that the object was created with the SQLInserter(IDatabase, String) constructor.
Note that if you want to obtain the value of the IDENTITY value for the newly created record you must
use the Execute(String, Int32, Boolean, ExecuteOptions) overload.
|
| Execute(String, Int32) |
Execute the SQL INSERT statement. Note that embedded functions are always resolved.
Requires that the object was created with the SQLInserter(IDatabase, String) constructor.
Note that if you want to obtain the value of the IDENTITY value for the newly created record you must
use the Execute(String, Int32, Boolean, ExecuteOptions) overload.
|
| Execute(IDatabase, String) |
Execute the SQL INSERT statement. Note that embedded functions are always resolved.
|
| Execute(IDatabase, String, Int32) |
Execute the SQL INSERT statement. Note that embedded functions are always resolved.
|
| Execute(String, Int32, Boolean, ExecuteOptions) |
Execute the SQL INSERT statement. Note that embedded functions are always resolved
unless an executeOptions parameter is provided (without ResolveEmbedded set).
Requires that the object was created with the SQLInserter(IDatabase, String) constructor.
|
 | 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.) |
| FireAndForget |
Executes the specified SQL asynchronously on a thread pool thread.
Uses IDatabase.FireAndForget.
|
| GetHashCode | Serves as a hash function for a particular type. (Inherited from Object.) |
| GetType | Gets the Type of the current instance. (Inherited from Object.) |
| IndexOfColumn |
Get the index of the column in the internal column collection.
|
| MemberwiseClone | Creates a shallow copy of the current Object. (Inherited from Object.) |
| ToString | (Inherited from Object.) |
| ToString(DBMSType) |
Returns the INSERT statement.
|
| ToString(DBMSType, Boolean) |
Returns the INSERT statement.
|
Extension Methods| Name | Description | |
|---|---|---|
 | AddColumn |
Add a column to the inserter 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