praeclarum/sqlite-net
Sqlite Net
sqlite-net is a lightweight object-relational mapper and data access layer for SQLite. It provides tools for translating application classes into database tables, managing records through an entity mapper, and implementing local data persistence.
The library includes an encrypted wrapper that secures database files using connection keys and native encryption configurations. It also features a data access layer that supports both synchronous and asynchronous operations to maintain application responsiveness during disk access.
The project covers a range of database management capabilities, including automatic table generation from class definitions, entity-based CRUD operations, and predicate-based querying. It also allows for the execution of raw SQL using parameterized statements.
Features
- Local Persistence Layers - Enables local data persistence by saving application state to a local SQLite file.
- Database Table Generation - Automatically generates database tables based on the definitions provided in entity classes.
- Entity CRUD Management - Provides a comprehensive set of tools for performing CRUD operations using mapped entities.
- Local Database Security - Protects sensitive local data using encryption keys to prevent unauthorized file access.
- Object-Relational Mapping - Implements object-relational mapping to manage data storage without extensive manual SQL.
- SQL Data Access Layers - Implements a data access layer for executing parameterized SQL and managing database operations.
- SQLite Integration - Integrates SQLite database functionality to store and retrieve data using defined object models.
- SQLite ORMs - Functions as a lightweight object-relational mapper for translating application classes into SQLite tables.
- Object Mappings - Includes a lightweight mapping layer that translates application objects into database tables.
- Struct-to-Row Mappers - Maps application data structures to database columns for type-safe record insertion.
- Async-Await ORM Cores - Provides an asynchronous database wrapper that prevents UI thread blocking during disk access.
- Database File Encryption - Secures database files using symmetric encryption keys applied during the connection handshake.
- Parameterized Query Bindings - Implements parameterized query bindings to prevent SQL injection attacks and improve performance.
- Asynchronous Data Loading - Supports non-blocking retrieval and storage of data to keep the application responsive.
- Raw SQL Execution - Allows the execution of raw SQL commands with parameter binding for complex data manipulation.
- Lambda-to-SQL Generators - Converts lambda expressions into SQL WHERE clauses to enable filtering without writing raw queries.
- Attribute-Based Mappings - Uses custom metadata attributes to map application class properties to database columns.
- Object Mapping - Translates database rows into objects by analyzing class structures at runtime via reflection.
- Transparent File Encryption - Provides a wrapper that secures the SQLite database file using connection keys and native encryption configurations.
- Transparent Encryption Wrappers - Provides a transparent encryption wrapper that secures the database file using connection keys.
- Database Predicate Builders - Allows retrieval of datasets using predicates and ordering clauses to avoid manual SQL.
- Data Storage - Minimalist library for SQLite database access.
