ALinq

Linq To Access, MS SQL, SQLite, MySQL, Oracle, Firebird ......

background
What is ALinq?
ALinq is an Enterprise-grade database LINQ provider,Stable, efficient and easy to use. The usage of ALinq is compatible with DLinq(Lint To SQL), if you are familiar with DLinq, you can master ALinq in few minute.Getting Started
Why use ALinq?

Incredible Productivity

Slash your data access code by a factor of 10. Drastically improve development time. Less mistakes in the DAL to fix.

Full Compatic With DLinq

ALinq is full compatible with DLinq(Linq to SQL), all the features in DLinq can be found in alinq, the ALinq API is same with DLinq's. it's means, All the knowlage about DLinq can directly applicable to ALinq .

Full Database Mapping

ALinq can map to all three database objects – Views, Stored Procedures and Tables. This means you can significantly improve your applications’ performance and security by fully utilizing the resources of your database server.

Powerful Linq Supported

Full SQL query can be supported. Support complex query, include sub query, jon query, and so on.... Support string, date function and so on ....See Samples

Database independent Code

Enjoy true portability for your application. ALinq support most of the commercial databases, such as Microsoft Access Database, Microsoft SQL Server, Oracle and MySQL, SQLite, Firebird.

Testability

All classes enhanced by ALinq are still normal CLR objects, and as such can be easily tested by state of the art unit tests. Moreover, SQL code can be traced by writing it to the console, in a text file or to the .NET tracing framework.

Caching

The ALinq .Net Object Relational Mapper has unique caching features to optimize the data handling: Connection Pool settings, Compiled Query Cache / Prepared Statement Cache, First Level Cache.

Generic Data Access

ALinq provides a unique technique to access the persistent data in a generic way without the need to use reflection. The technique significantly increases the speed of all read and write operations.