Public Instance Constructors
sqlDialect
|
Overloaded. Initializes a new instance of the sqlDialect class. |
Public Instance Fields
 datetimeQueryValue | Set how component write SQL query date/time value. |
| doubleRecordSqlsTemplate | This are sql templates for multiplying records in specified table. Data can be multiply using dataAccess.multiplyRecords function. |
| emptyString | Some databases treat empty string as null value, but most not. |
| getDbNameSelectSQL | |
| getIdentitySelectSQL | Set select statement for retrieve new inserted id. Only for sqlServer and mySql clients (odbc or native) this property is set by object. For others set this property manually. |
| limitMode | Limitation type for specified database. |
| numericQueryValue | Set how component write SQL query numeric value. |
| parameterCollectionFormat | Set only when parameters in parameter collection have different format, otherwise leave empty. |
| parameterQueryFormat | Parameter form for SQL statements. |
| templateConcatLIKE | Concatenation string is set with concatenation value for SQL parameter. |
Public Instance Properties
 concatenation | Set concatenation type for specific database. |
| databaseLanguageLCID | Get database language LCID. |
| dbEngineTwoLetterISOCultureName | Some (odbc) clients have problems with parameterized queries. In this case sql statement is build as string. For this option set database language as two letter ISO culture name (default is "en-US") and also set numericQueryValue and/or datetimeQueryValue asString |
| type | Get or set predefined sql dialect type. |
Public Instance Methods
| Equals (inherited from Object) | Determines whether the specified Object is equal to the current Object. |
| GetHashCode (inherited from Object) | Serves as a hash function for a particular type. GetHashCode is suitable for use in hashing algorithms and data structures like a hash table. |
| GetType (inherited from Object) | Gets the Type of the current instance. |
| setTypeByConnection | Procedure for automated set of correct sql dialect type. |
| setVersionMsSQL | |
| ToString (inherited from Object) | Returns a String that represents the current Object. |
Public Instance Events
 prepareSqlStatementEvent | Event fires before each sql statement action. Useful for handling sql statement manually. Event fires on each table name and each sql statement. |
Protected Instance Methods
 Finalize (inherited from Object) | Allows an Object to attempt to free resources and perform other cleanup operations before the Object is reclaimed by garbage collection. |
| MemberwiseClone (inherited from Object) | Creates a shallow copy of the current Object. |
See Also
sqlDialect Class | Indoo.Data Namespace