Overview

Dalc is a simple, lightweight, fast and DB-independent data layer for working with the relational data. Main features:

• Database DALC implementation based on ADO.NET
• Custom SQL dataviews on data layer (transparent for application)
• Abstract query structure
• relational expressions (compact query representation) parser
• LINQ support
• Optimized for performance (custom SQL command generator, datareaders)
• MS SQL specific optimizations (TOP, varchar/nvarchar handling, params etc)
• Data-layer permissions for Create/Retrieve/Update/Delete operations
• Data-layer caching mechanism that supports SqlCacheDependency
• new DALC-based RDB-to-RDF bridge (semantic access to SQL-databases) is available!

Supported ADO.NET API

Right now DALC has factories for following ADO.NET implementations:

• MS SQL 2000/2005/2005/Express(2005,2008)
• MySQL 5.1 (using MySqlConnector)
• ODBC
• OLEDB

API

Central interfaces are located in the NI.Data.Dalc namespace:

• IDalc provides a basic API for working with the relational data
• DbDalc implementation based on ADO.NET
• DatasetDalc implementation based on the in-memory DataSet as a data storage
• IQuery encapsulates a simple query for the relational data.
• The Query class is a default implementation of the query structure

Examples

• Some simple examples like how to select, insert, update and delete data with DALC
• NReco Web Application Sample illustrates how DALC can be used in real-world ASP.NET applications.

Links

• DALC Class Diagram
• ADO.NET (MSDN)