DataQuicker ORM 0.9.2 Released (Open Source Project)

In a Database application, Data Access Layer acts as a bridge between the database (Relational Universe) and Business Objects (Business Domains); and in .NET world, more often than not, these are built as an extension to ADO/.NET Datasets/Data tables.  

DataQuicker extends the function and simplifies the development for building Data Access Layer, and provides the efficient and simple framework to construct your application. Because of its structure, it’s very suitable for medium and/or small size database projects. Based on my past experience on DataQuicker, it’s convenient to build MVC architect with AJAX for web project. For Model part of MVC, it can reduce 40 percent work loading at least. (100 percent for DAL, 30% for business)

DataQuicker supports conversion from data table to data access layer directly, nearly needs no modification. Of course, you can enhance the validation on property of DAL, such as using ValidateAttribute. 

At last, your project will be easily to maintain when using DataQuicker. Even you change a database, the cost is very low, only needs to change configuration in DataQuicker.config.

If you’re interesting in DataQuicker, please download it for see more.  

Version 0.9.2 Updates

Download Full Source And Demo Here: https://files.cnblogs.com/lovinger2000/DataQuicker%200.9.2.zip

1, Remove all query conditions setting on FieldMapping/EntityMapping, but found a new class Query responsible for querying. So, in 0.9.2, we must refer to class Query for querying. It supports almost aggregate functions, group by clauses better than now. And it's possible to combine any SQL for your purpose.

2, Change the habit of operation, completely obey s CRUD (createm retrieve, update, delete) are adopted in this new version, integrated in interface IProvider.

3, Improvements on provider and analyzer, use IDbCommand and IDataParameter. That's more secure and efficient than old version. It can prevent all potential attacks and defects in combining SQL.

4, Modifications on DAL design. Basically, if we only CRUD, there is no necessary to care about association of tables/views. When querying, if we can create associations between tables/views dynamically when querying. Any more, we only need to create a persistence layer for each table/view at most.

5, Supports multiple primary key, but unfortunately, DataQuicker cannot manage multiple primary key automatically. We're only allowed to set DataQuciker managed primary key for single primary key.

6, Improve the performance of common kit methods.

…

By the way, the version 0.9.2 is more stable than 0.9.1. And based on my performance testing, 0.9.2 is 25 percent higher than old one.

Forecast

The main upgrades for 0.9.3 are as follows,
1, Support Image/File column, for saving/reading binary data in database;
2, Use Configuration Block (Core of Microsoft Enterprise Block) instead of configuration now;
3, New code generate tool, it will be more convenient and handsome than now.

Donation: Indeed, we're absent of financing, if you donate for DataQuicker, we will try out best to contribute for appreciating you. And give you timely support when you need. You can contact me by email, and get my bank account or postal code and address.  

Author: Eunge

Email: eudev.net@yeah.net

My Blog: http://lovinger2000.cnblogs.com