[This is preliminary documentation and is subject to change.]

The MetaSqlDB type exposes the following members.

Constructors

  NameDescription
Public methodMetaSqlDBOverloaded.

Methods

  NameDescription
Public methodAddOutputParameterOverloaded.
Public methodAddParameterOverloaded.
Protected methodAddParametersOverloaded.
Public methodCheckMetaSqls
Checks the metasql statement and refresh the sql if necessary
Public methodClearParameters
Clear all the sql stored procedure parameters
(Inherited from OfficeClipDB.)
Public methodClose
Close the connection, data adapter and the command
(Inherited from OfficeClipDB.)
Public methodCommit
Commits the transaction
(Inherited from OfficeClipDB.)
Public methodDispose
disposes the object for garbage collection
(Inherited from OfficeClipDB.)
Public methodEquals
Determines whether the specified Object is equal to the current Object.
(Inherited from Object.)
Protected methodExecuteNonQueryOverloaded.
Protected methodExecuteReader
Executes the sql datareader
(Inherited from OfficeClipDB.)
Protected methodExecuteScalar
Executes the query that returns a single valur
(Inherited from OfficeClipDB.)
Protected methodFill
Fills the dataset
(Inherited from OfficeClipDB.)
Protected methodFinalize
Allows an Object to attempt to free resources and perform other cleanup operations before the Object is reclaimed by garbage collection.
(Inherited from Object.)
Protected methodFixedListSelects
Selection of fixed lists
Protected methodGetForeignTableColumnName
Gets the foreign table column name
Public methodGetHashCode
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.)
Protected methodGetListExternalColumn
Gets the list of the external column
Protected methodGetListForeignColumn
Gets the foreign column list
Public methodGetMetaDataSet
Gets the meta data set
Public methodGetParameterCount
Gets the parameter count
(Inherited from OfficeClipDB.)
Public methodGetParameterValue
Gets the value of the parameter
(Inherited from OfficeClipDB.)
Protected methodGetPrimaryTableColumnName
Gets the primary table column name
Protected methodGetPrimaryTableName
Get the primary table name
Protected methodGetSecondaryTableColumnName
Gets the secondary table column name
Protected methodGetSecondaryTableName
Gets the secondary table name
Public methodGetType
Gets the Type of the current instance.
(Inherited from Object.)
Protected methodInit
Initialize the connection parameters
(Inherited from OfficeClipDB.)
Public methodInitTransactionOverloaded.
Protected methodMainSqlJoin
The sql join string
Protected methodMemberwiseClone
Creates a shallow copy of the current Object.
(Inherited from Object.)
Protected methodPrimaryTableInsertParameters
Insert parameter for the primary table
Public methodRefreshSqlsOverloaded.
Public methodRollback
Rolls back the transaction
(Inherited from OfficeClipDB.)
Protected methodSecondaryTableInsertParameters
Insert parameter for the secondary table
Public methodSetParameterValue
Sets the parameter value of the sql parameter to a known value
(Inherited from OfficeClipDB.)
Protected methodSetSPCommandOverloaded.
Protected methodSetSPDataAdapter
Sets the stored procedure data adapter
(Inherited from OfficeClipDB.)
Public methodSqlDelete
The sql delete statement
Public methodSqlInsert
The sql insert statement
Public methodSqlSelectAll
Sql for selecting all the information
Public methodSqlSelectByFilter
Sql statement for select by filter
Public methodSqlSelectByPk
Sql statement for select by primary key
Public methodSqlSelectLists
The sql select list
Public methodSqlSelectPreferred
Sql statement for preferred information
Public methodSqlUpdateFixed
The sql update statement for the fixed field
Public methodSqlUpdateUdf
The sql update statement for the user defined fields
Public methodToString
Returns a String that represents the current Object.
(Inherited from Object.)
Protected methodUdfListSelects
User defined list selects
Protected methodUpdateMetaSqls
Create the update sql for the metabase

Properties

  NameDescription
Public propertyConnectionString
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.)
Protected propertyDBConnString
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.)

See Also