Click here to Skip to main content
15,867,756 members
Articles / Programming Languages / C#
Article

DataQuicker (ORM) 0.9.4: Introduction

Rate me:
Please Sign up or sign in to vote.
4.54/5 (11 votes)
27 Sep 20053 min read 41.6K   599   21   2
DataQuicker helps build a clear application structure, accelerates developement, and decreases maintenance costs. It's more possible to provide our customer a perfect on-time project, and release us from over-time working and other delays.

Introduction

In any database application, the Data Access Layer takes part as a data agency between the database and the application. In .NET, usually we use ADO.NET in our DAL classes. However, DataQuicker extends the functionality and simplifies developing the Data Access Layer, and provides an efficient and simple framework to construct your application. Because of its structure, it’s very suitable for medium/small enterprise applications. Based on my past experience on DataQuicker, it’s convenient to build the MVC architecture with AJAX for web projects. As the Model part in MVC, it can reduce 40 percent work load at the least. (100% for DAL, 30% for business.) Because of its convenience, we can save energy for business design and coding, to pay more attention on the project design. For a company, this enables to provide our customers a perfect project on time. And for us (developers, testers, product managers and all project participators), it keeps us far away from overtime working or project delays.

Image 1

Image 2

DataQuicker supports transformation of data tables to the data access layer directly, and nearly needs no modification of code. Also, we can create validation expressions on a property of the DAL class by using the Validate classes. This will decrease your workload obviously. Besides the benefit in reduced durations, our project using DataQuicker is easy to maintain. Also, if we change the database schema, we only need to adjust the mapping DAL classes lightly.

Basically, I believe you can benefit from DataQuicker for free, and get a long term service and upgrade for new features.

History

  • Version 0.9.4 Updates.
    1. Obvious improvements on configuration settings, and also on its mechanism. The enhancement includes:
      1. Plugged assembly support.
      2. Cryptography on password, supports an external plugged cryptographic assembly to use customized encrypt/decrypt arithmetic.
      3. Flexible configuration settings for connection string combination.
      4. Configuration cache and its change monitoring.
    2. Add a new column type support – binary. It allows your reading/writing image, file and any other binary data from/into database.
    3. Adopt a new constructor instead of all CreateInstance methods defined in the DAL classes.
    4. Create provider factory to create provider object, and use a provider pool to cache provider objects. It’ll accelerate provider construction a lot.
  • Version 0.9.2 Updates.
    1. Removed all query conditions setting on FieldMapping/EntityMapping, but introduced a new class Query responsible for querying. So, in 0.9.2, we must refer to class Query for querying. It supports most aggregate functions and group-by clauses better than now. And it's possible to combine any SQL for your purpose.
    2. Changed the habit of operation, completely obeys CRUD (create, retrieve, update, delete) in this new version, integrated the interface IProvider.
    3. Improvements on the provider and the analyzer, uses IDbCommand and IDataParameter. That's more secure and efficient than the old version. It can prevent all potential attacks and defects in combining SQL.
    4. Modifications on the DAL design. Basically, if we only use CRUD, there is no necessary to care about the association of tables/views. When querying, we can create associations between tables/views dynamically. Aso, we only need to create a persistence layer for each table/view at the most.
    5. Supports multiple primary keys, but unfortunately, DataQuicker cannot manage multiple primary keys automatically. We're only allowed to set the DataQuciker managed primary key for a single primary key.
    6. Improved the performance of common kit methods.

License

This article has no explicit license attached to it but may contain usage terms in the article text or the download files themselves. If in doubt please contact the author via the discussion board below.

A list of licenses authors might use can be found here


Written By
President TCWH
China China
I've worked as a software architect and developer based on Microsoft .NET framework and web technology since 2002, having rich experience on SaaS, multiple-tier web system and website development. I've devoted into open source project development since 2003, and have created 3 main projects including DataQuicker (ORM), ExcelQuicker (Excel Report Generator), and RapidWebDev (Enterprise-level CMS)

I worked in BenQ (8 mo), Bleum (4 mo), Newegg (1 mo), Microsoft (3 yr) and Autodesk (5 yr) before 2012. Now I own a startup company in Shanghai China to deliver the exceptional results to global internet users by leveraging the power of Internet and the local excellence.

Comments and Discussions

 
GeneralFramework 2.0 Pin
jbatista.br11-Jun-07 1:56
jbatista.br11-Jun-07 1:56 
Generalgood Pin
Shiny Zhu6-Nov-06 23:19
Shiny Zhu6-Nov-06 23:19 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.