SnapObjects ORM makes .NET development a snap! It is unbelievably simple yet does not skimp on features. It gives you full control over generated SQL. And it performs practically like ADO.NET.
Simple to code advanced functionality, and data access is in models to minimize maintenance effort.
.NET objects are used as query criteria in a type-safe manner, and testing APIs are provided to verify SQL.
SQL generation is controlled through a comprehensive set of model attributes, or code raw SQL if preferred.
Relationships are defined while coding (not pre-defined) and only persist for a particular query.
Queries, updates, and actions can be tracked, and then transaction management is automatically applied.
There is little overhead on top of ADO.NET, and queries, updates, and actions are executed in bulk.
Website: https://www.appeon.com/products/snapobjects.html