This article needs additional citations for verification. (February 2024) |
Quick Objects is an object–relational mapping tool for the Microsoft .NET Framework, a built in framework for business logic and validation. The architecture for Quick Objects differs from other ORM tools. The focus of Quick Objects is to provide the advantages of code reuse, code generation and object relational mapping in a single tool set.
| 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] |
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. Quick Objects allows for comprehensive data access and modification, along with an object model that allows the developer to specify and control CRUD operations.
History edit
Quick Objects edit
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,[1] 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[2] 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 edit
| Component | Description | |
|---|---|---|
| Database Access Library | The Database Access Library is a database-independent library that provides an easy-to-use API to work with 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[3] | 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[2] | 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[4] | 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[5] | 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 edit
| Feature | Description |
|---|---|
| Object Model | Complete data in a supported database is accessible via an object model. This eliminates the need to write SQL statements or Stored procedures. |
| Centralized Business Logic | The Business Logic Framework allows one to centralize 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 | Quick Objects allows for basic code generation for supported databses. |
| 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 edit
- Microsoft SQL Server / SQL CE
- Microsoft Access
- Oracle
- MySQL
See also edit
References edit
- ^ "Archived copy". Archived from the original on 2008-09-11. Retrieved 2008-08-26.
{{cite web}}: CS1 maint: archived copy as title (link) - ^ a b "ASP.NET | Open-source web framework for .NET".
- ^ "ASP.NET | Open-source web framework for .NET".
- ^ "With whom and how you will meet? (For shaman king))))".
- ^ "Archived copy". Archived from the original on July 7, 2011. Retrieved November 13, 2008.
{{cite web}}: CS1 maint: archived copy as title (link)