Software:Quick Objects

Quick Objects

Developer(s)	Akal Tech [1]
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	[2]

Quick Objects is a powerful object–relational mapping tool for Microsoft .NET Framework, 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.

LINQ is fully supported and it 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 an object model that allows the developer to specify and control every aspect of the CRUD operations.

History

Quick Objects

On September 15, 2008, Version 4.2 was released which included enhanced support for Windows Forms visual databinding.

On September 1, 2008, Version 4.1 was released with support for Microsoft .NET Compact Framework.

On August 1, 2008, Version 4.0 was released with several new features. VistaDB, Microsoft Access and MySQL were added to the list of supported databases. Quick Object's 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.

On 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.

On March 3, 2008, Version 3.3 was released with support for Visual Studio 2008.

On 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 was introduced in V3 as well.

On April 25, 2007, Quick Objects version 2.2 was released to the public.

Quick Objects components for .NET Framework

Component	Description
Database Access Library	The 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. The Database Access Library also provides built-in support for connection sharing, transactions and has the capability to get the underlying database schema.
Business Logic and Validation Framework	The Business Logic Framework is a library of reusable classes that incorporates all the logic needed to work with any of the underlying databases. The Business Logic Framework extends the power in the Database Access Library, taking 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. The Business Logic Framework also provides a comprehensive capability to perform automatic validation on data being saved.
Data Source for ASP.NET	It provides Design Time support in ASP.NET 2.0 or later. Works with standard .NET controls as well as third-party controls such as Telerik, Infragistics, DevExpress, etc.
TimeZones Library	The TimeZones library provides an easy way to translate Date and Time values between various time zones. The TimeZones library also works with the Business Logic Framework for automatic Date and Time conversion to the desired time zone.
Quick Objects Designer	The Designer application provides an interface to connect and fetch the schema from any of the supported databases. The Designer also provides 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 the Designer application.

Quick Objects features

Feature	Description
Powerful Object Model	Complete data in a supported database is accessible via a powerful object model. This 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	The 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

See also

• List of object–relational mapping software

External links

• [3]