A fast, lightweight .NET micro-ORM that automatically maps objects to databases with minimal configuration.
Insight.Database is a fast, lightweight micro-ORM for .NET that automates object-relational mapping with minimal configuration. It maps database results to objects automatically, supports stored procedures, SQL inlining, and complex relationships, reducing boilerplate code while maintaining high performance.
.NET developers building data access layers who want an intuitive, low-configuration ORM that works seamlessly with stored procedures and complex object graphs.
Developers choose Insight.Database for its automatic mapping capabilities, performance, and flexibility—it handles common database operations 'magically' while allowing fine-grained control when needed, without requiring extensive configuration.
Fast, lightweight .NET micro-ORM
Open-Awesome is built by the community, for the community. Submit a project, suggest an awesome list, or help improve the catalog on GitHub.
Maps database results to objects without configuration files or attributes, as shown with the Beer class example where no manual mapping code is needed.
Automatically implements repository interfaces like IBeerRepository for easy dependency injection and testing, reducing boilerplate.
Supports one-to-one, one-to-many, and nested object graphs automatically, demonstrated in the Query with Returns and ThenChildren examples.
Streams objects using BulkCopy protocol and handles table-valued parameters for high-performance data inserts, as shown in the BulkCopy and InsertBeer examples.
Version 8.0 removed unpopular database providers, potentially limiting use with less common databases and forcing manual workarounds.
While automatic for most scenarios, the README admits that 'wacky models' require non-scary but still manual configuration, contradicting the fully automatic claim.
Lacks database migration tools common in full ORMs like Entity Framework, requiring separate solutions for schema changes, which adds complexity.