• Introduction
• Before you begin
• Quick Objects Product Editions
• Whats New and Change History
• Roadmap
• Getting Started
  • First Step
  • Introduction to Quick Objects Business Logic Framework
  • Introduction to Quick Objects Data Source For ASP.NET
  • Creating Business Logic Layer (Automated Process)
  • Creating Business Logic Layer (Manual Process)
  • Sample Database
• Configuration And Deployment
  • Database Configuration Setting (Connection String)
  • Database_Type Configuration Setting
  • AutoEncloseObjectNames Configuration Setting
  • TranslateTimeZones Configuration Setting
  • LocalTimeZone Configuration Setting
  • Case Conversion Configuration Setting
  • Deployment and Runtime License
  • Exception Mode Configuration Setting
• How to...
  • Code Generation And Customizations
    • Generating Business Logic Layer Classes From Database Schema
    • Updating Classes When Underlying Database Schema Changes (v2.x)
    • Updating Classes When Underlying Database Schema Changes (v3.x)
    • Code Generation Using the Command Line/Batch Process
    • Generating Enumerations for Table Values
    • Adding Validations To Fields And Generating Validation Code
    • Supporting Multiple Database Schema/Owners
  • Select and Search
    • All Rows
    • Return Selective Fields From a Table
    • Related Objects (Tables)
    • Load a Parent Record and All Child Records
    • Complex Searches
    • Joins, Sorting and Searching
    • Allowing Users to Dynamically Choose Fields To Display
    • Search For Value or NULL
    • Search Based On A List of Values
    • Adding Calculated Columns To Results
    • Creating Complex Searches By Using Search Groups
    • Paged Result Sets
    • Selecting Multiple Parent Objects In Single Call To Database
  • Update
    • Load and Save a Single Record
    • Update Multiple Records
  • Insert
    • Inserting a Single New Record
  • Delete
    • Delete a Single Record
    • Delete Multiple Records
  • Advanced
    • Concurrency Management
      • Concurrency Management During an Update or Delete
    • Events
      • Handling Object Events
    • Strongly Typed Collections
      • Using Strongly Typed Collections To Enumerate Results.
    • Group By
      • Group By Query With Calculated Column
      • Simply Group By
    • Serialization and Deserialization
      • Serialization and Deserialization of Business Logic Objects.
    • Disconnected Mode
      • Bulk Save and Disconnected Mode
    • Connection/Transaction Sharing
      • Sharing Connection Between Multiple Objects
    • Sort
      • Sorting a Result Set By One Column
      • Sorting An Aggregate SubQuery Column
    • Sub Queries
      • Adding Aggregate Sub Query Columns for Select Operation
  • Validation
    • Required Field Validation
    • Complex And Multiple Validations Per Field
    • Adding Validation To Fields
  • Business Logic
    • Implementing Centralized and Reusable Business Logic
    • Leveraging The Centralized Logic
    • Control And Flexibility
• Licensing and Support
  • License Agreement
  • Contact Us
• Tutorials
  • Database Library
    • Running a SELECT Statement and Returning a DataSet
    • Running a SELECT Statement and Adding Results to an Existing DataSet
    • Running Stored Procedure and Returning a DataSet
    • Running a Scalar SQL Statement and Getting the Number of Records Affected
  • Business Logic Framework
    • Return All Records From a Table
    • Return Selective Fields From a Table
    • Return All Records From Two Joined Tables
    • Load and Save a Single Record
    • Load a Parent Record and All Child Records
    • Performing Complex Searches
    • Performing Complex Search with Related Objects
    • Joining, Sorting, Searching and Customizing the result set.
    • Inserting a Single New Record
    • Delete a Single Record
    • Concurrency Management During an Update or Delete
    • Serialization and Deserialization of Business Logic Objects.
    • Allowing Users to Dynamically Choose Fields To Display
    • Using Strongly Typed Collections To Enumerate Results.
    • Creating Complex Searches By Using Search Groups
    • Group By Query With Calculated Column
    • Handling Object Events
    • Paged Result Sets
    • Defining Calculated Columns
    • Complex Group By Queries With Search Criteria
    • Bulk Save and Disconnected Mode
    • Implementing Centralized and Reusable Business Logic
    • Leveraging The Centralized Logic
    • Control And Flexibility
  • Time Zones Library
    • Converting DateTime Values To And From UTC To Any Time Zone
    • Converting DateTime Values Between Two Time Zones
  • Data Source for ASP.NET
    • Using Quick Objects Data Source For ASP.NET
    • Controlling Visibility of Fields
    • Zero Code Select-Insert-Update-Delete Operations
    • Parent Child Relationships and Using Control Parameters
    • Performing Searches With Control Parameter As a Source
    • Using Events To Gain Access To Underlying Objects And Enable Concurrency Manager
  • Designer
    • Generating Business Logic Layer Classes From Database Schema
    • Updating Classes When Underlying Database Schema Changes (v3.x)
    • Using the Command Line Parameters
    • Creating Enumerations for Table Values
    • Adding Validators To Fields In The Designer
    • Supporting Multiple Database Schema/Owners
• API Reference
  • Namespaces
    • Akal.QuickObjects.DBLibrary Namespace
      • Overview
      • Classes
        • DatabaseObject
          • Overview
          • Members
          • DatabaseObject Constructor
            • DatabaseObject Constructor()
            • DatabaseObject Constructor(String)
            • DatabaseObject Constructor(String,DatabaseTypes)
          • Methods
            • EnsureConnectionString Method
            • EnsureDatabaseType Method
            • SetDatabaseType Method
          • Properties
            • AffectedRecords Property
            • ConnectionString Property
            • ConnectionStringConfigName Property
            • DatabaseTypeConfigName Property
            • DBType Property
            • ErrorString Property
            • ExceptionMode Property
        • DatabaseObjectSQL
          • Overview
          • Members
          • DatabaseObjectSQL Constructor
            • DatabaseObjectSQL Constructor()
            • DatabaseObjectSQL Constructor(String)
            • DatabaseObjectSQL Constructor(String,DatabaseTypes)
          • Methods
            • AssignConnection Method
            • CommitTransaction Method
            • CreateConnection Method
            • Dispose Method
            • GetNewAdapterInstance Method
            • GetNewParameterInstance Method
            • GetSQLExceptionAsString Method
            • HandleException Method
            • RollBackTransaction Method
            • RunSessionEndCommand Method
            • RunSessionStartCommand Method
            • RunSPReturnDataReader Method
            • RunSPReturnDataset Method
              • RunSPReturnDataset(String,IDataParameter[]) Method
              • RunSPReturnDataset(String,String,IDataParameter[]) Method
              • RunSPReturnDataset(String,DataSet,String,IDataParameter[]) Method
            • RunSPWithNoReturn Method
              • RunSPWithNoReturn(String) Method
              • RunSPWithNoReturn(String,IDataParameter[]) Method
              • RunSPWithNoReturn(String,ArrayList) Method
            • RunSQLReturnDataset Method
              • RunSQLReturnDataset(String) Method
              • RunSQLReturnDataset(String,ArrayList) Method
              • RunSQLReturnDataset(String,DataSet,String) Method
              • RunSQLReturnDataset(String,DataSet,String,ArrayList) Method
            • RunSQLWithNoReturn Method
              • RunSQLWithNoReturn(String) Method
              • RunSQLWithNoReturn(String,IDataParameter[]) Method
              • RunSQLWithNoReturn(String,ArrayList) Method
            • SetSqlParamType Method
          • Properties
            • DBConnection Property
            • DBTransaction Property
            • FillSchema Property
            • ParameterPrefix Property
            • SessionEndCommand Property
            • SessionEndCommandType Property
            • SessionEndParameters Property
            • SessionStartCommand Property
            • SessionStartCommandType Property
            • SessionStartParameters Property
            • UseTransaction Property
      • Enumerations
        • DatabaseObject.DatabaseTypes
        • ExceptionModes
    • Akal.QuickObjects.ObjectBase Namespace
      • Overview
      • Classes
        • AfterCommandEventArgs
          • Overview
          • Members
          • AfterCommandEventArgs Constructor
          • Fields
            • Success Field
        • AggregateSubQueryField
          • Overview
          • Members
          • AggregateSubQueryField Constructor
            • AggregateSubQueryField Constructor()
            • AggregateSubQueryField Constructor(IBusinessObject)
            • AggregateSubQueryField Constructor(IBusinessObject,GroupTypes,BaseField)
            • AggregateSubQueryField Constructor(IBusinessObject,GroupTypes,BaseField,String)
            • AggregateSubQueryField Constructor(IBusinessObject,GroupTypes,BaseField,String,BaseField,BaseField)
            • AggregateSubQueryField Constructor(IBusinessObject,String)
            • AggregateSubQueryField Constructor(IBusinessObject,String,String)
          • Properties
            • AggregateField Property
            • AggregateMethod Property
            • JoinedFields Property
        • BaseBusinessObject
          • Overview
          • Members
          • BaseBusinessObject Constructor
            • BaseBusinessObject Constructor()
            • BaseBusinessObject Constructor(BaseBusinessObject)
            • BaseBusinessObject Constructor(BaseBusinessObject,Boolean)
            • BaseBusinessObject Constructor(String)
            • BaseBusinessObject Constructor(String,DatabaseTypes)
          • Methods
            • Average Method
            • BulkDelete Method
            • BulkUpdate Method
            • Copy Method
            • Count Method
            • CreateJoin Method
              • CreateJoin(String,IField,IField,IBusinessObject,JoinTypes,RelationshipTypes) Method
              • CreateJoin(String,IField[],IField[],IBusinessObject,JoinTypes,RelationshipTypes) Method
            • Delete Method
              • Delete() Method
              • Delete(DataRow) Method
            • Dispose Method
            • Find Method
              • Find(Int32,Int32) Method
              • Find() Method
            • FindAndLoad Method
            • GetDeleteSQL Method
            • GetDelimetedValue Method
              • GetDelimetedValue(DataRow[],String,String) Method
              • GetDelimetedValue(DataRowCollection,String,String) Method
              • GetDelimetedValue(Object[],String) Method
            • GetFieldsList Method
              • GetFieldsList(Int32,Int32,IBusinessObjectCollection) Method
              • GetFieldsList(Boolean,Int32,Int32,IBusinessObjectCollection) Method
              • GetFieldsList(Boolean,RecursionTypes,Int32,Int32,IBusinessObjectCollection) Method
              • GetFieldsList(Boolean,RecursionTypes,Boolean,Int32,Int32,IBusinessObjectCollection) Method
              • GetFieldsList(Boolean,RecursionTypes,Boolean,Boolean,Int32,Int32,IBusinessObjectCollection) Method
            • GetFromExpression Method
            • GetGroupByExpression Method
              • GetGroupByExpression(Int32,Int32,IBusinessObjectCollection,IFieldCollection) Method
              • GetGroupByExpression(RecursionTypes,Int32,Int32,IBusinessObjectCollection,IFieldCollection) Method
            • GetInsertExpression Method
            • GetInsertSQL Method
            • GetJoinExpression Method
              • GetJoinExpression(Int32,Int32,IBusinessObjectCollection) Method
              • GetJoinExpression(RecursionTypes,Int32,Int32,IBusinessObjectCollection) Method
            • GetOriginalWhereExpression Method
            • GetResultSetName Method
              • GetResultSetName() Method
              • GetResultSetName(CaseTypes) Method
            • GetSelectSQL Method
            • GetSortExpression Method
              • GetSortExpression(Int32,Int32,IBusinessObjectCollection,IFieldCollection) Method
              • GetSortExpression(RecursionTypes,Int32,Int32,IBusinessObjectCollection,IFieldCollection) Method
            • GetStringsFromColumn Method
            • GetUpdateExpression Method
            • GetUpdateSQL Method
            • GetValueList Method
              • GetValueList() Method
              • GetValueList(Boolean) Method
            • GetWhereExpression Method
              • GetWhereExpression(Boolean,Int32,Int32,IBusinessObjectCollection,ArrayList) Method
              • GetWhereExpression(Boolean,RecursionTypes,Int32,Int32,IBusinessObjectCollection,ArrayList) Method
              • GetWhereExpression(Boolean,RecursionTypes,Int32,Int32,IBusinessObjectCollection,ArrayList,Boolean) Method
            • InitializeObject Method
            • Insert Method
              • Insert() Method
              • Insert(DataRow) Method
            • Load Method
            • LoadChild Method
            • LoadFromDataRow Method
            • LoadOriginalFromDataRow Method
            • LoadOriginalFromHashtable Method
            • LoadParent Method
            • Maximum Method
            • Minimum Method
            • OnAfterDelete Method
            • OnAfterFind Method
            • OnAfterInsert Method
            • OnAfterLoad Method
            • OnAfterUpdate Method
            • OnBeforeDelete Method
            • OnBeforeFind Method
            • OnBeforeInsert Method
            • OnBeforeLoad Method
            • OnBeforeUpdate Method
            • OnObjectDisposing Method
            • OnObjectInitialized Method
            • Save Method
            • SetHiddenFields Method
              • SetHiddenFields(Boolean,IField[]) Method
              • SetHiddenFields(IField[]) Method
            • SetSaveFields Method
            • SetSearchFields Method
              • SetSearchFields(Boolean,Boolean,IField[]) Method
              • SetSearchFields(Boolean,IField[]) Method
              • SetSearchFields(IField[]) Method
            • SetVisibleFields Method
              • SetVisibleFields(Boolean,IField[]) Method
              • SetVisibleFields(IField[]) Method
            • Sum Method
            • Update Method
              • Update() Method
              • Update(DataRow) Method
            • UseAllFieldsForDisplay Method
              • UseAllFieldsForDisplay(Boolean) Method
              • UseAllFieldsForDisplay(Boolean,RecursionTypes) Method
            • UseAllFieldsForSave Method
            • UseAllFieldsForSearch Method
              • UseAllFieldsForSearch(Boolean) Method
              • UseAllFieldsForSearch(Boolean,RecursionTypes) Method
          • Properties
            • AddResultsToDataSet Property
            • AutoEncloseObjectNames Property
            • AutoRecursion Property
            • AutoSyncOnConnect Property
            • CaseConversion Property
            • ConcurrencyMode Property
            • ContainerJoin Property
            • ErrorString Property
            • Fields Property
            • HasChanges Property
            • IncludeTableName Property
            • IsDirty Property
            • IsLoaded Property
            • IsValid Property
            • Joins Property
            • LocalTimeZone Property
            • LoggedInUser Property
            • MaxRecords Property
            • MaxRecursionLevels Property
            • MoreResults Property
            • ObjectMode Property
            • ObjectState Property
            • OnlyDistinct Property
            • PageSize Property
            • PartialTextMatch Property
            • PrimaryKeyFields Property
            • QuickObjectsEdition Property
            • Recursive Property
            • ResultSet Property
            • ResultSetName Property
            • ResultTable Property
            • StartRowIndex Property
            • TableName Property
            • TableOwner Property
            • TranslateTimeZoneMode Property
            • TranslateTimeZones Property
            • UseNoLock Property
            • Visible Property
          • Events
            • AfterDelete Event
            • AfterFind Event
            • AfterInsert Event
            • AfterLoad Event
            • AfterUpdate Event
            • BeforeDelete Event
            • BeforeFind Event
            • BeforeInsert Event
            • BeforeLoad Event
            • BeforeUpdate Event
            • ObjectDisposing Event
            • ObjectInitialized Event
        • BaseBusinessObjectCollection
          • Overview
          • Members
          • BaseBusinessObjectCollection Constructor
          • Methods
            • Contains Method
            • CopyTo Method
              • CopyTo(Array,Int32) Method
              • CopyTo(BaseBusinessObjectCollection) Method
            • GetEnumerator Method
          • Properties
            • BusinessObject Property
            • Count Property
            • IsSynchronized Property
            • Item Property
            • SyncRoot Property
        • BaseBusinessObjectCollectionEnumerator
          • Overview
          • Members
          • BaseBusinessObjectCollectionEnumerator Constructor
        • BaseEventArgs
          • Overview
          • Members
          • BaseEventArgs Constructor
            • BaseEventArgs Constructor()
            • BaseEventArgs Constructor(IBusinessObject)
          • Properties
            • BusinessObject Property
        • BaseField
          • Overview
          • Members
          • BaseField Constructor
            • BaseField Constructor()
            • BaseField Constructor(IBusinessObject)
            • BaseField Constructor(IBusinessObject,String)
            • BaseField Constructor(IBusinessObject,String,String)
          • Methods
            • AssignValueToParam Method
              • AssignValueToParam(QueryTypes) Method
              • AssignValueToParam(QueryTypes,IDataParameter) Method
            • Copy Method
              • Copy(BaseField) Method
              • Copy(BaseField,Boolean,Boolean) Method
              • Copy(BaseField,Boolean,Boolean,Boolean,Boolean) Method
              • Copy(BaseField,Boolean,Boolean,Boolean,Boolean,Boolean,Boolean,Boolean,Boolean,Boolean) Method
            • CopyValidators Method
              • CopyValidators(BaseField) Method
              • CopyValidators(BaseField,Boolean) Method
            • GetFieldType Method
            • GetInsertExpression Method
            • GetListWhereExpression Method
            • GetOriginalWhereExpression Method
            • GetResultSetName Method
            • GetSortExpression Method
            • GetSqlParamName Method
            • GetSqlParamName_Orig Method
              • GetSqlParamName_Orig(Boolean) Method
              • GetSqlParamName_Orig(Boolean,String) Method
            • GetUpdateExpression Method
            • GetValueExpression Method
            • GetWhereExpression Method
              • GetWhereExpression(Boolean,ArrayList) Method
              • GetWhereExpression(Boolean,ArrayList,String) Method
              • GetWhereExpression(Boolean,ArrayList,String,Boolean) Method
            • NewInstance Method
            • Parse Method
            • Set Method
              • Set(String,String) Method
              • Set(String,String,SearchModes) Method
              • Set(Boolean,String) Method
              • Set(Boolean,String,String) Method
              • Set(Boolean,String,String,SearchModes) Method
              • Set(SortTypes,Int32) Method
              • Set(GroupTypes,Int32) Method
            • SetSqlParamType Method
            • Validate Method
          • Properties
            • AllowGroupBy Property
            • AllowNull Property
            • AllowSave Property
            • AllowSearch Property
            • AllowSort Property
            • BusinessObject Property
            • DBType Property
            • GroupPosition Property
            • GroupType Property
            • IsCustom Property
            • IsDirty Property
            • IsNull Property
            • IsValid Property
            • List Property
            • Name Property
            • Operator Property
            • OriginalValue Property
            • ResultSetName Property
            • RetainEverything Property
            • SearchCondition Property
            • SearchMode Property
            • SearchPostfix Property
            • SearchPrefix Property
            • Sort Property
            • SortPosition Property
            • SqlParam Property
            • TableName Property
            • TableResultSetName Property
            • UseInSave Property
            • UseInSearch Property
            • Validators Property
            • Value Property
            • Visible Property
          • Fields
            • _operator Field
        • BaseFieldValidator
          • Overview
          • Members
          • BaseFieldValidator Constructor
            • BaseFieldValidator Constructor()
            • BaseFieldValidator Constructor(BaseField)
            • BaseFieldValidator Constructor(BaseField,Boolean)
            • BaseFieldValidator Constructor(BaseField,Boolean,String)
          • Methods
            • Copy Method
            • GetValidatorTypeName Method
            • NewInstance Method
            • OnAfterValidation Method
            • OnBeforeValidation Method
            • Validate Method
          • Properties
            • CustomErrorMessage Property
            • Enabled Property
            • ErrorString Property
            • FieldToValidate Property
            • FieldToValidateLookup Property
            • IsValid Property
            • Name Property
            • ValidatorType Property
          • Events
            • AfterValidation Event
            • BeforeValidation Event
        • BaseFieldValidatorCollection
          • Overview
          • Members
          • BaseFieldValidatorCollection Constructor
            • BaseFieldValidatorCollection Constructor()
            • BaseFieldValidatorCollection Constructor(Int32)
          • Methods
            • Add Method
            • Clear Method
            • ClearErrors Method
            • Contains Method
              • Contains(BaseFieldValidator) Method
              • Contains(String) Method
              • Contains(ValidatorTypes) Method
            • CopyTo Method
              • CopyTo(Array,Int32) Method
              • CopyTo(BaseFieldValidatorCollection) Method
            • DisableAll Method
            • EnableAll Method
            • GetEnumerator Method
              • GetEnumerator() Method
              • GetEnumerator(Int32,Int32) Method
            • IndexOf Method
              • IndexOf(BaseFieldValidator) Method
              • IndexOf(String) Method
              • IndexOf(ValidatorTypes) Method
            • Insert Method
            • Remove Method
              • Remove(BaseFieldValidator) Method
              • Remove(ValidatorTypes) Method
            • RemoveAt Method
          • Properties
            • Count Property
            • Errors Property
            • IsFixedSize Property
            • IsReadOnly Property
            • IsSynchronized Property
            • Item Property
              • Item(Int32) Property
              • Item(String) Property
              • Item(ValidatorTypes) Property
            • SyncRoot Property
        • BeforeCommandEventArgs
          • Overview
          • Members
          • BeforeCommandEventArgs Constructor
          • Fields