[This is preliminary documentation and is subject to change.]
The MetaSqlDB type exposes the following members.
Constructors
| Name | Description | |
|---|---|---|
| MetaSqlDB | Overloaded. |
Methods
| Name | Description | |
|---|---|---|
| AddOutputParameter | Overloaded. | |
| AddParameter | Overloaded. | |
| AddParameters | Overloaded. | |
| CheckMetaSqls |
Checks the metasql statement and refresh the sql if necessary
| |
| ClearParameters |
Clear all the sql stored procedure parameters
(Inherited from OfficeClipDB.) | |
| Close |
Close the connection, data adapter and the command
(Inherited from OfficeClipDB.) | |
| Commit |
Commits the transaction
(Inherited from OfficeClipDB.) | |
| Dispose |
disposes the object for garbage collection
(Inherited from OfficeClipDB.) | |
| Equals | Determines whether the specified Object is equal to the current Object. (Inherited from Object.) | |
| ExecuteNonQuery | Overloaded. | |
| ExecuteReader |
Executes the sql datareader
(Inherited from OfficeClipDB.) | |
| ExecuteScalar |
Executes the query that returns a single valur
(Inherited from OfficeClipDB.) | |
| Fill |
Fills the dataset
(Inherited from OfficeClipDB.) | |
| 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.) | |
| FixedListSelects |
Selection of fixed lists
| |
| GetForeignTableColumnName |
Gets the foreign table column name
| |
| GetHashCode | Serves as a hash function for a particular type. GetHashCode()()() is suitable for use in hashing algorithms and data structures like a hash table. (Inherited from Object.) | |
| GetListExternalColumn |
Gets the list of the external column
| |
| GetListForeignColumn |
Gets the foreign column list
| |
| GetMetaDataSet |
Gets the meta data set
| |
| GetParameterCount |
Gets the parameter count
(Inherited from OfficeClipDB.) | |
| GetParameterValue |
Gets the value of the parameter
(Inherited from OfficeClipDB.) | |
| GetPrimaryTableColumnName |
Gets the primary table column name
| |
| GetPrimaryTableName |
Get the primary table name
| |
| GetSecondaryTableColumnName |
Gets the secondary table column name
| |
| GetSecondaryTableName |
Gets the secondary table name
| |
| GetType | Gets the Type of the current instance. (Inherited from Object.) | |
| Init |
Initialize the connection parameters
(Inherited from OfficeClipDB.) | |
| InitTransaction | Overloaded. | |
| MainSqlJoin |
The sql join string
| |
| MemberwiseClone | Creates a shallow copy of the current Object. (Inherited from Object.) | |
| PrimaryTableInsertParameters |
Insert parameter for the primary table
| |
| RefreshSqls | Overloaded. | |
| Rollback |
Rolls back the transaction
(Inherited from OfficeClipDB.) | |
| SecondaryTableInsertParameters |
Insert parameter for the secondary table
| |
| SetParameterValue |
Sets the parameter value of the sql parameter to a known value
(Inherited from OfficeClipDB.) | |
| SetSPCommand | Overloaded. | |
| SetSPDataAdapter |
Sets the stored procedure data adapter
(Inherited from OfficeClipDB.) | |
| SqlDelete |
The sql delete statement
| |
| SqlInsert |
The sql insert statement
| |
| SqlSelectAll |
Sql for selecting all the information
| |
| SqlSelectByFilter |
Sql statement for select by filter
| |
| SqlSelectByPk |
Sql statement for select by primary key
| |
| SqlSelectLists |
The sql select list
| |
| SqlSelectPreferred |
Sql statement for preferred information
| |
| SqlUpdateFixed |
The sql update statement for the fixed field
| |
| SqlUpdateUdf |
The sql update statement for the user defined fields
| |
| ToString | Returns a String that represents the current Object. (Inherited from Object.) | |
| UdfListSelects |
User defined list selects
| |
| UpdateMetaSqls |
Create the update sql for the metabase
|
Properties
| Name | Description | |
|---|---|---|
| ConnectionString |
Gets the OfficeClip.DBLayer.ConnectionString property encapsulates
a callout to the ASP+ Config System to obtain the
database connection string for the application.
(Inherited from OfficeClipDB.) | |
| DBConnString |
The database connection string that is only available within the framework of the DBLayer.
This should only be set through a constructor so this is not available outside
the DBLayer. A default conection string is assumed if not set.
(Inherited from OfficeClipDB.) |
