• Introduction
• Before you begin
• Quick Objects Product Editions
• Whats New
• Release 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)
  • Using Quick Objects on Compact Framework
  • Included Samples
  • Sample Database
  • Product Videos
  • Community/Discussions
  • Can't Find Something, need further help?
• 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
  • Using Quick Objects on Compact Framework
• 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
    • Configuring Templates To Generate Code
    • Reverse Engineer Views And Stored Procedures
  • 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
    • Selecting Records and using Anonymous Types
    • Specify Search Criteria Using Linq
    • Joins With LINQ and Quick Objects
    • Projections Without using Anonymous Types
    • Paging Records with Skip and Take methods
    • Using Strongly Typed Views
    • Search Based On Range Of Values
    • Adding Aggregate Sub Query Columns
    • Sorting a Joined Result Set With Multiple Column Sort
  • Update
    • Load and Save a Single Record
    • Update Multiple Records
    • Work With Blob Field To Store Image Data
  • Insert
    • Inserting a Single New Record
    • Work With Blob Field To Store Image Data
  • 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
      • Group By And Aggregates with LINQ To Quick Objects
    • 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
      • Sorting with LINQ to Quick Objects
    • Sub Queries
      • Adding Aggregate Sub Query Columns for Select Operation
    • Calculated Columns
      • Defining Calculated Columns
      • Calculated Columns and Calculations in Criteria
    • Blob/Binary Data
      • Work With Blob Field To Store Image Data
  • 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
  • Strongly Typed Views
    • Using Strongly Typed Views
• 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
    • Work With Blob Field To Store Image Data
    • Using Strongly Typed Views
  • 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
    • Configuring Templates To Generate Code
    • Reverse Engineer Views And Stored Procedures
  • LINQ
    • LINQ to Quick Objects Introduction
    • Selecting Records and using Anonymous Types
    • Delayed Execution In Linq To Quick Objects
    • Specify Search Criteria Using Linq
    • Joins With LINQ and Quick Objects
    • Projections Without using Anonymous Types
    • Paging Records with Skip and Take methods
    • Sorting with LINQ to Quick Objects
    • Group By And Aggregates with LINQ To Quick Objects
    • Calculated Columns and Calculations in Criteria
  • Web Xml Form
    • Introduction to Web Xml Form For ASP.NET
• API Reference
  • Namespaces
    • Akal.QuickObjects.DBLibrary Namespace
      • Overview
      • Classes
        • BaseDatabaseProviderFactory
          • Overview
          • Members
          • BaseDatabaseProviderFactory Constructor
        • 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
              • GetNewParameterInstance() Method
              • GetNewParameterInstance(String) Method
              • GetNewParameterInstance(String,DbType) Method
              • GetNewParameterInstance(String,Object) Method
              • GetNewParameterInstance(String,DbType,Object) Method
            • GetSchema Method
              • GetSchema() Method
              • GetSchema(String) Method
              • GetSchema(String,String[]) Method
            • GetSQLExceptionAsString Method
            • HandleException Method
            • RollBackTransaction Method
            • RunSessionEndCommand Method
            • RunSessionStartCommand Method
            • RunSPReturnDataReader Method
            • RunSPReturnDataset Method
              • RunSPReturnDataset(String,IDataParameter[]) Method
              • RunSPReturnDataset(String,Generic List) Method
              • RunSPReturnDataset(String,String,IDataParameter[]) Method
              • RunSPReturnDataset(String,DataSet,String,IDataParameter[]) Method
            • RunSPWithNoReturn Method
              • RunSPWithNoReturn(String) Method
              • RunSPWithNoReturn(String,IDataParameter[]) Method
              • RunSPWithNoReturn(String,Generic List) 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
            • ParameterIncludesPrefix Property
            • ParameterPrefix Property
            • SessionEndCommand Property
            • SessionEndCommandType Property
            • SessionEndParameters Property
            • SessionStartCommand Property
            • SessionStartCommandType Property
            • SessionStartParameters Property
            • UseParameterName Property
            • UseTransaction Property
        • DB2Factory
          • Overview
          • Members
        • IDatabaseProviderFactory
          • Overview
          • Members
          • IDatabaseProviderFactory Constructor
        • MySqlFactory
          • Overview
          • Members
        • OdbcFactory
          • Overview
          • Members
        • OleDbFactory
          • Overview
          • Members
        • SqlCeFactory
          • Overview
          • Members
          • SqlCeFactory Constructor
        • VistaDBFactory
          • Overview
          • Members
          • VistaDBFactory Constructor
      • 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
            • AssignConnection Method
            • Average Method
            • BeginEdit Method
            • BulkDelete Method
            • BulkUpdate Method
            • CancelEdit Method
            • Copy Method
            • Count Method
              • Count(BaseField) Method
              • Count() Method
            • CreateJoin Method
              • CreateJoin(String,IField,IField,IBusinessObject,JoinTypes,RelationshipTypes) Method
              • CreateJoin(String,IField[],IField[],IBusinessObject,JoinTypes,RelationshipTypes) Method
            • CreateJoinByName Method
              • CreateJoinByName(String) Method
              • CreateJoinByName(String,JoinTypes) Method
            • CreateRelationsInResultSet Method
            • Delete Method
              • Delete() Method
              • Delete(DataRow) Method
            • Dispose Method
            • EndEdit Method
            • FillList Method
              • FillList(IList) Method
              • FillList(IList,String) Method
            • Find Method
              • Find(Int32,Int32) Method
              • Find() Method
            • FindAndLoad Method
              • FindAndLoad() Method
              • FindAndLoad(Boolean) Method
            • FindAndReturnTable 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
            • NewInstance Method
              • NewInstance() Method
              • NewInstance(Boolean) 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
            • OnPropertyChanged Method
            • OnPropertyChanging Method
            • RemoveJoin Method
            • ResetObjectValuesFromOriginalValues Method
              • ResetObjectValuesFromOriginalValues() Method
              • ResetObjectValuesFromOriginalValues(Boolean,Boolean) Method
            • ResetOriginalValuesFromObjectValues Method
              • ResetOriginalValuesFromObjectValues() Method
              • ResetOriginalValuesFromObjectValues(Boolean,Boolean) Method
            • Save Method
            • SetHiddenFields Method
              • SetHiddenFields(Boolean,IField[]) Method
              • SetHiddenFields(IField[]) Method
            • SetLoggedInUser Method
            • SetSaveFields Method
            • SetSearchFields Method
              • SetSearchFields(Boolean,Boolean,IField[]) Method
              • SetSearchFields(Boolean,IField[]) Method
              • SetSearchFields(IField[]) Method
            • SetSortFieldPosition Method
            • SetVisibleFields Method
              • SetVisibleFields(Boolean,IField[]) Method
              • SetVisibleFields(Boolean,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
            • AutoCreateJoins Property
            • AutoEncloseObjectNames Property
            • AutoRecursion Property
            • AutoSyncOnConnect Property
            • CaseConversion Property
            • ConcurrencyMode Property
            • ContainerJoin Property
            • EnableVirtualPaging Property
            • ErrorString Property
            • Fields Property
            • HasChanges Property
            • IncludeTableName Property
            • IsDirty Property
            • IsInReinitializationMode Property
            • IsLoaded Property
            • IsValid Property
            • Joins Property
            • List Property
            • LocalTimeZone Property
            • LoggedInUser Property
            • MaxRecords Property
            • MaxRecursionLevels Property
            • MoreResults Property
            • ObjectMode Property
            • ObjectState Property
            • OnlyDistinct Property
            • OtherObjects Property
            • PageSize Property
            • PartialTextMatch Property
            • PossibleJoins 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
          • Fields
            • _list Field
            • isExecuted Field
            • IsObjectInNewState Field
          • 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
            • PropertyChanged Event
            • PropertyChanging Event
        • BaseBusinessObjectCollection
          • Overview
          • Members
          • BaseBusinessObjectCollection Constructor
            • BaseBusinessObjectCollection Constructor(BaseBusinessObject)
            • BaseBusinessObjectCollection Constructor(BaseBusinessObject,CollectionModes)
          • Methods
            • Contains Method
            • CopyTo Method
              • CopyTo(Array,Int32) Method
              • CopyTo(BaseBusinessObjectCollection) Method
            • GetEnumerator Method
            • GetItemProperties Method
              • GetItemProperties(PropertyDescriptor[],ArrayList,Int32,Int32) Method
              • GetItemProperties(PropertyDescriptor[]) Method
            • GetListName Method
          • Properties
            • BusinessObject Property
            • CollectionMode Property
            • Count Property
            • Enumerator 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
            • Between Method
              • Between(Object,Object) Method
              • Between(Object,Object,String) Method
              • Between(Object,Object,String,String) Method
              • Between(Object,Object,String,String,RangeField) 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