[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.) |