praeclarum/sqlite-net
Sqlite Net
sqlite-net ist ein leichtgewichtiger Object-Relational Mapper (ORM) und Datenzugriffsschicht für SQLite. Es bietet Tools zum Übersetzen von Anwendungsklassen in Datenbanktabellen, zum Verwalten von Datensätzen über einen Entity-Mapper und zur Implementierung lokaler Datenpersistenz.
Die Bibliothek enthält einen verschlüsselten Wrapper, der Datenbankdateien mittels Verbindungsschlüsseln und nativen Verschlüsselungskonfigurationen sichert. Sie verfügt zudem über eine Datenzugriffsschicht, die sowohl synchrone als auch asynchrone Operationen unterstützt, um die Anwendungsreaktionsfähigkeit während des Festplattenzugriffs aufrechtzuerhalten.
Das Projekt deckt eine Reihe von Datenbankmanagement-Funktionen ab, einschließlich automatischer Tabellengenerierung aus Klassendefinitionen, entity-basierten CRUD-Operationen und prädikatbasierten Abfragen. Es ermöglicht zudem die Ausführung von rohem SQL mittels parametrisierter 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.
