The CA.Blocks.DataAccess is a lightweight .NET library designed specifically for Onion and CQRS type architectures to extract and work with relational databases. The base premise is reducing the object–relational impedance mismatch that exists between the relational world and the object world of .NET. The design focuses on making the datatype translations more seamless, moving from dataset and tables type structures into objects, and from .NET types into SQL parameters.
The CA.Blocks.DataAccess is not trying to be a an ORM like Entity framework for NHibernate and hiding the SQL. The base classes have never been designed to be any form of ORM. In fact using the blocks you will be working directly with the underlying SQL. There is no magic projection for queries or magic save to have changes to classes back to entities in the DB. Whilst there are helper functions you are 100% in control the database interactions.
Using the blocks allows full control of the SQL. If you don’t want to work with SQL then this is not the library for you. The Blocks allow you to work directly with the SQL code whilst providing a good structure to reduce the impedance mismatch between the two technologies allowing the developer to move from the C# types into SQL parameters and then SQL into the C# types.
CA.Blocks.DataAccess grew out of projects I been working on since 2003. and have been well tested. They have evolved as the .NET framework as evolved. After trying to switch to Entity framework and n-Hibernate I came back to the CA.Blocks.DataAccess for the simple reason it was lightweight and far more predictable. I found that whilst the Entity framework and n-Hibernate excel at CRUD type applications I was doing a lot of workarounds and conversions trying use and them in either CQRS, layered onion, and repository type Architectures. I have seen many code bases use Entity framework for data access in a Repository Pattern, any in most cases you end up writing more code in the object world to avoid working to a few SQL statements. A tell-tale sign is you using reflection or mapping to copy objects of similar structures across boundaries.