SQLSelectInto Methods

Adds a column (to be copied) to the class where both the source and destination names, and data types match. If either names and/or types do not match match, use AddColumn(String, OleDbType, String, OleDbType) instead.

Adds a column (to be copied) to the class where the source and destination names and/or data types do not match. If both match, use AddColumn(String, OleDbType) instead.

Adds a SQL expression string to the SELECT clause inserting into the specified column.

Adds a literal value to the SELECT clause inserting into the specified column.

Create an instance of a SQLSelectInto object appropriate for copying a record or records in the same table. The method will use GetSchemaInfo(String, SchemaInfoType) to determine the table's columns and set up the SQLSelectInto object for copying all columns except those indicated as IsIdentity.

Using the returned SQLSelectInto object you can use AddColumn(String, OleDbType, String, OleDbType), AddExpression(String, String, Boolean), or AddLiteral(Object, String, OleDbType) to replace a destination column source if changes are required. To perform the actual copy, call Execute(IDatabase, SQLHelperFlags, String).

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

Execute the SQL INSERT INTO ... SELECT FROM statement. Note that embedded functions are always resolved.

Execute the SQL INSERT INTO ... SELECT FROM statement. Note that embedded functions are always resolved.

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 INSERT INTO ... SELECT statement

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.