Subsonic DAL
Subsonic is my favorite library for creating data access layers in asp.net.
- It creates properties to the related entities/tables in the database, some people like to call this feature Deep Properties!
- no need to create CRUD stored procedures for every table in the db
- you can do queries on the fly, WHERE clauses, ORDER BY clauses and aggregate functions
- It’s open-source and free
- the classes are generated using a tool, no more tedious DAL writing
- for your convenience you get “Scaffolding forms”.
- it uses parameterized dynamic sql, which makes all those great features above possible
- It has providers for MS Sql Server and MySQL
If you are an asp.net developer you should give it a try, or at least check it out, it’ll be worth your while.