Quick Objects
Developer(s) | Akal Tech |
---|---|
Stable release |
Quick Objects 4.2.2008.29
/ 29 September 2008 |
Preview release |
Quick Objects 4.2.2008.29
|
Written in | C# |
Operating system | Windows |
Platform | .NET 2.0+ |
Type | Object-relational mapping |
License | Licensed per developer seat |
Website |
Quick Objects is a powerful object-relational mapping tool for Microsoft .NET Framework with a built in framework for business logic and validation. The architecture for Quick Objects is different from other ORM tools (See: List of object-relational mapping software). Focus of Quick Objects to provide the advantages of code reuse, code generation and object relational mapping in a single tool set.
Quick Objects API is very simple but packed with powerful features and capabilities. LINQ is fully supported and can be used against any of the supported databases. Classes generated by Quick Objects are ready for Web Services, Windows Communication Foundation and Remoting. Comprehensive data access and modification capabilities are complemented by a very flexible object model that allows developer to specify and control every aspect of CRUD operations. See below for a list of features.
History
Quick Objects
September 15, 2008 version 4.2 was released with enhanced support for Windows Forms visual databinding.
September 1, 2008 version 4.1 was released with support for Microsoft .NET Compact Framework.
August 1, 2008 version 4.0 was released with several new features. VistaDB,[1] Microsoft Access and MySQL were added to the list of supported databases. Quick Objects designer added support for adding multiple custom templates for code generation. V4.0 also added support for LINQ and enabled the capability to specify queries in LINQ and run them against any of the supported databases.
April 7, 2008 version 3.5 was released with a new Free edition of the product called Community Edition. In addition to the Community Edition, the Quick Objects Designer also added a visual validation designer. Business Logic Framework also introduced support for databases with multiple schemas, and introduced support for aggregate sub queries.
March 3, 2008 version 3.3 was released with support for Visual Studio 2008.
October 30, 2007 a major release of Quick Objects V3 was released with the addition of the validation framework among other features. V3 also introduced support for disconnected mode and delayed synchronization. A new component called Quick Objects Data Source for ASP.NET[2] was introduced in V3 as well.
April 25, 2007 Quick Objects version 2.2 was released to public.
Quick Objects components for .NET Framework
Component | Description | |
---|---|---|
Database Access Library | Database Access Library is a database independent library that provides an easy to use API to work any of the supported databases. Custom SQL statements, Stored procedures and views are all supported. Database Access Library provides built in support for connection sharing, transactions and even has the capability to get the underlying database schema. | |
Business Logic and Validation Framework[3] | Business Logic Framework is a library of reusable classes that incorporate all the logic needed to work with any of the underlying databases. The Business Logic Framework extends the power in the Database Access Library and takes full advantage of the database independent design and support for connection sharing and transactions. Business Logic Framework also offers a type system that provides a consistent way to work with data types and still handle null values from databases. Business Logic Framework also provides a comprehensive capability to perform automatic validation on data being saved. | |
Data Source for ASP.NET[4] | Provides Design Time support in ASP.NET 2.0 or later. Works with standard .NET controls as well third-party controls such as Telerik, Infragistics, DevExpress, etc. | |
TimeZones Library[5] | TimeZones library provides easy way to translate DateTime values between various Timezones. TimeZones library also works with Business Logic Framework for automatic DateTime conversion to the desired Timezone. | |
Quick Objects Designer[6] | Designer application provides an interface to connect and fetch the schema from any of the supported databases. The designer also provide the ability to customize and generate code specific to the database. Custom templates can also be written using a syntax similar to ASP.NET and plugged into the project in Designer application. | |
Quick Objects features
Feature | Description | |
---|---|---|
Powerful Object Model | Complete data in a supported database is accessible via a powerful object model. Eliminates the need to write SQL statements or Stored procedures. | |
Centralized Business Logic | The Business Logic Framework makes it very easy to centralize all the business logic. | |
LINQ Support | LINQ can be used to specify select queries, and can also be used to specify criteria information for bulk delete or update operations. | |
Code Generation | Designer application can be used to generate code for any of the supported databases. | |
Customizable | Designer application allows for customization of various aspects of the generated code. | |
Extensible | Code generation can be extended by adding custom templates. Generated code from the provided templates can be extended by plugging in partial classes with custom logic in them. | |
Role Based Security/Permissions | Permission providers can be plugged in for exercising granular control over objects and enforcing business rules. Virtually any type of role/permission storage can be supported easily. | |
Disconnected Mode and Multi-level Sync | Objects can work in a disconnected mode and retain their changes for synchronization at a later stage. Synchronization can automatically take care of any relationships and primary key generations. | |
Validation | Validation can be specified in the Designer application or in the code. | |
Event Model | Comprehensive event model is available to take complete control over data operations or validations. | |
Calculated Columns | Calculated columns can be created at multiple stages and they can also be specified using LINQ syntax. | |
Strongly Typed Object Model | Entire database or selected objects can be strongly typed to gain full advantage of IntelliSense and compiler checking. | |
BLOBs and XML Field Support | XML Fields and BLOBs are fully supported. | |
Support for Complex Joins and Keys | All types of complex joins and keys are supported including Left, Right, and Outer joins. Keys with multiple columns are supported as well. | |
Database Independent | Eliminates the need to write database specific code and the same code base can be used against any of the supported databases without a recompile. | |
Stored procedures and Views | Supports Stored procedures and Views in a strongly typed manner. | |
Works Without Code Generation | Business Logic Framework can also be used without generating code, and the schema can be specified at runtime as well. | |
Transactions | Complete support for ADO.NET transactions. | |
Medium Trust Support | Works directly in medium trust and does not use reflection. | |
Server side and Virtual Paging | Depending on the underlying database server the objects can use server side paging or virtual paging to select only the requested rows. | |
Supported database servers
- Microsoft SQL Server / SQL CE
- Microsoft Access
- Oracle
- MySQL
- VistaDB[7]
See also
References
- ↑
- ↑
- ↑
- ↑
- ↑
- ↑ "Archived copy". Archived from the original on July 7, 2011. Retrieved November 13, 2008.
- ↑