A Sandcastle Documented Class Library
cls
Base class for all SQL Server Database table classes
Definition
Namespace: MbcsCentral
Assembly: MbcsCentral (in MbcsCentral.exe) Version: 2.0.1.15 (2.0.1.15)
Assembly: MbcsCentral (in MbcsCentral.exe) Version: 2.0.1.15 (2.0.1.15)
C#
public class clsDB- Inheritance
- Object clsDB
- Derived
Constructors
| clsDB | |
| clsDB | Initializes a new instance of the clsDB class |
| clsDB(String, String, String, String, String, String, SqlConnection, String) | Full constructor |
Properties
| ColumnCount | Reports column count |
| ErrorMessage | Used to retrieve internal error messages |
| IsDupe | Set true when a duplicate record is found on insertion |
| Item | Generic method for getting values of property by names. Useful when iterating through columns in a record |
Methods
| delete | Delete record |
| Equals | Determines whether the specified object is equal to the current object. (Inherited from Object) |
| Finalize | Allows an object to try to free resources and perform other cleanup operations before it is reclaimed by garbage collection. (Inherited from Object) |
| GetColumn | Finds if specified Column name is in table. Datarows must have already been fetched. |
| GetHashCode | Serves as the default hash function. (Inherited from Object) |
| GetTableSchema | Gets a table schema |
| GetType | Gets the Type of the current instance. (Inherited from Object) |
| insertRecord | Inserts a new record using instantiated Insert statement |
| load | Retrieve records from a table using the passes SQL string |
| loadAll | Retrieve all records in a table |
| loadByPrimaryKey | Load a record by Primary Key |
| MemberwiseClone | Creates a shallow copy of the current Object. (Inherited from Object) |
| prepareStatement | Inserts options (parameters) in an SQL string to prepare it for execution. Options are indicated by question marks (? for numeric and '?' for strings) in the raw sql. |
| query | Execute custom query. Used mainly for special deletion scenarios |
| Query | Performs custom queries using ConnectionString |
| Query2 | Performs custom queries using SQLConnection |
| queryWithCount | Custome query for getting record counts |
| ToString | Returns a string that represents the current object. (Inherited from Object) |
| updateRecord | Updates records using update statement passed with child class instantiation |
| updateRecordSpecial | Updates records using passed update statement |
Fields
| connectionString | |
| DataSetName | |
| DS_DATA_SET | |
| insertStmt | |
| loadAllStmt | |
| loadStmt | |
| LoadStmt | |
| localCN | |
| localTable | |
| Log | |
| priKeyName | |
| SQL_DELETE | |
| updateStmt |