DapperLib/Dapper

Features

• Object-Relational Mappers - Functions as a high-performance micro-ORM that maps database query results directly to strongly-typed objects.
• Data Access and Querying - Maps database query results to strongly-typed objects with minimal overhead for high-performance data access.
• Raw SQL Execution - Executes custom SQL statements and stored procedures directly against a database for full control.
• Row Mapping Logic - Automatically projects returned database rows into strongly typed objects for easier data handling.
• Object-Relational Mapping - Maps database query results to strongly-typed objects with support for both buffered and streaming retrieval.
• Query Parameterization - Ensures security and performance by separating SQL command strings from data values using database-native parameter binding.
• Query Parameter Filters - Maps object properties to SQL query parameters to prevent injection attacks and simplify data passing.
• Dynamic Mapping Engines - Uses runtime code generation to create high-performance instructions that map database result sets directly to object properties.
• Object Mappers - Automates the translation of database rows into application objects using extension methods on standard database connection interfaces.
• Asynchronous Database Command Execution - Runs database commands without blocking the main execution thread to allow for parallel processing.
• Asynchronous Database Drivers - Performs database operations using non-blocking calls to improve application responsiveness.
• Bulk Data Operations - Provides high-performance batch insert and update operations to minimize database round-trips.
• SQL Query Execution - Performs database operations without blocking the main execution thread to improve system performance.
• Database Query Joins - Retrieves single or multiple records with support for joins, grouping, and ordering.
• Database Schema Mapping - Translates database query results into objects using metadata attributes for mapping.
• Database Transactions - Groups multiple database operations into a single unit of work that ensures data integrity.
• Entity Mappings - Defines reusable rules for mapping application objects to database tables for consistent data access.
• Multi-Table Result Mappers - Retrieves data from multiple related tables in one query and assembles them into nested object structures using custom logic.
• Database Access Extensions - Extends standard database connection interfaces with fluent methods to provide an intuitive data access layer.
• Asynchronous Execution - Performs database operations without blocking the main execution thread using non-blocking data retrieval.
• Database Abstraction Layers - Provides a lightweight abstraction layer that decouples application code from specific database provider implementations.
• Object Relational Mappers - Simple and high-performance object mapper for .NET.
• Batch Data Operations - Performs batch create, update, or delete operations on database records to improve performance for large volumes of data.
• Atomic Transactions - Groups multiple database operations into atomic units of work with manual commit and rollback support.
• CRUD Interfaces - Automates create, read, update, and delete operations on database tables using extension methods.
• Runtime Metadata Inspectors - Analyzes object models at execution time to dynamically construct SQL queries without requiring pre-compiled configurations.
• Object-Relational Mapping Relations - Joins parent and child records automatically to populate navigation properties in object models.
• Result Streaming APIs - Streams database query results row-by-row to minimize memory consumption.
• Single Record Retrievers - Fetches single database rows and maps them to strongly-typed objects.
• SQL Utilities - Constructs SQL statements dynamically at runtime by inspecting object models and mapping properties to database columns.
• Stored Procedures - Maps database query results to objects by invoking stored procedures with parameters.
• Column Mappings - Allows overriding default conventions for table names, column names, and keys to match specific database schema requirements.
• Collection Parameter Handlers - Expands arrays or lists into SQL IN clauses automatically to query multiple values in a single database operation.
• Database Command Interfaces - Executes SQL statements like insert, update, or delete and returns the count of affected rows.
• Database Engines - Supports multiple database engines by generating provider-specific SQL syntax automatically.
• Database Query Execution - Maps query results to a standard data reader interface by executing SQL statements.
• Bulk Data Ingestion - Adds large collections of objects to database tables in a single operation.
• Record Insertion - Maps object properties to SQL parameters to perform record insertion into a database.
• Record Updating - Updates large collections of entities in a single database round trip to improve performance.
• Repository Context Managers - Organizes data access through centralized classes that manage database connections and repository instances.
• Result Set Search - Processes complex database responses containing multiple rows, scalar values, or distinct result sets.
• Multi-Result Set Fetching - Executes multiple queries in a single database command to retrieve distinct data sets efficiently.
• Multi-Result Set Parsers - Processes complex database responses containing multiple distinct data streams by iterating through sequential result sets in a single command.
• Asynchronous Task Processors - Implements non-blocking task patterns to ensure database operations remain responsive during high-latency I/O.
• Asynchronous Scalar Execution - Performs a database query in the background and returns the first column of the first row without blocking.
• Batch Insertion Interfaces - Processes collections of objects by iterating through them to execute individual insert statements.
• Hierarchical Data Insertion - Saves parent and child entities in a single operation by automatically managing relationships.
• Database Parameter Managers - Configures explicit parameter details including data types, sizes, and directions for stored procedures.
• Database Connectivity - Provides extension methods to integrate with diverse database providers through standard connection interfaces.
• Database Deletion Utilities - Removes large sets of entities from a database by mapping objects to primary keys or custom criteria.
• Inheritance Mappings - Parses database rows into specific object types based on discriminator columns to handle inheritance.
• Query Caching Strategies - Caches database query results to reduce latency and server load.
• SQL Generators - Automates the generation of SQL statements from object models to simplify data access tasks.
• SQL Query Builders - Translates language-integrated expressions into SQL queries to filter and paginate data.

Star history