An Aspire client integration for the Microsoft.EntityFrameworkCore.Sqlite package.
A fluent ORM and Database Reflection Library for PostgreSQL.
Fast and robust layer for accessing databases. SQL Server, MySQL, Aurora, MariaDB, Sqlite and PostgrSQL. Designed for people that prefer to use stored procedures but works equally well for ad-hoc queries. Does not generate SQL statements from LINQ expressions.
ORM and LINQ Provider. Features: Auto Mapping, Generate Classes from Tables, Generate Tables from Classes, Synchronize Classes to Tables, Generic ADO.NET Wrapper, LINQ Provider support for SQL Server, Oracle, MySQL, VistaDB, Firebird, SQLite, and Microsoft Access.
The package Provides a solution for the Repository and UnitOfWork patterns together with inversition of control. On the project site there are examples of Autofact, Castle.Windsor, Ninject, Simpleinjector, StructureMap, and Unity integration. The IoC framework is not an issue... It is ment to integrate nice and smooth like... The project uses tor its repository work Dapper as ORM and Dapper.FactCRUD for fluentness. But you can use is as a foundation and with any IDbConnection and IDbTransient framework you like. The library gives you the building blocks to: * Create Sessions from the IDbFactory in your methods, IDbFactory should be injected into your class's. As Session extends IDbConnection and will Open on the factory spawning the session and dispose the connection on disposal of the connection. * Your Sessions can create UnitOfWork's. As Session extends IDbConnection and will Open on the factory spawning the session and dispose the connection on disposal of the connection. * If your logic just needs "just a" UnitOfWork with a session that has the same scope, the factory can create it for you. * The IRepository and abstract concrete class should be used on your individual repository classes to provide simple and basic calls. But ofcasue you can add all the queries you want into your Repositories and use the dapper and dapper.FastCRUD (or any other extensions) functionality provided to you. * The repository abstract classes use Dapper.FastCRUD to give you a fluent ORM experience with the most common calls. * This library does not lock you to using dapper and FastCRUD, you can use any library you like that extends IDbConnection and IDbTransation, and still use the IDbFactory, ISession and IUnitOrWork. * Implemented for .net 4..0, .net 4.5.2, .net 4.6.1, .net 4.7.1+, .net 1.6 standard, .net 2.0 standard+.
dotConnect for SQLite is a high-performance ORM enabled data provider for SQLite that builds on ADO.NET technology. The provider works with .NET Frameworks 2.0+, .NET Core 2.0+, .NET 5+. It supports a wide range of SQLite-specific features, such as a variety of built-in encryption methods, including TripleDES, Blowfish, AES128, AES192, AES256, Cast128, and RC4. We provide integration with advanced encryption solutions such as SQLiteCrypt and SQLCipher, which typically require separate licenses but are included in our product at no extra cost. Additionally, it supports user-defined functions, CEROD, support for enabling SQLite extensions with connection string parameters, and others. More information at https://www.devart.com/dotconnect/sqlite/ License dotConnect for SQLite is available in several editions https://www.devart.com/dotconnect/sqlite/ordering.html The NuGet package initiates the retrieval of an activation key from the Devart website. This key is required to activate the product for a free trial. Key Features * Built-in SQLite Encryption: Supports robust encryption for your SQLite databases such as TripleDES, Blowfish, AES128, AES192, AES256, Cast128, RC4. * Easy Connection: Allows your application to work with SQLite. * ASP.NET Core: Supports ASP.NET Core Identity. * Performance: Uses many SQLite-specific performance features and optimizations to ensure the highest performance. * Monitoring: Allows per-component tracing of database events with a free dbMonitor application. * Support and updates: Enjoy dedicated support team for prompt issue resolution and regular updates to keep your software running smoothly and securely.
SQLite-net is an open source and light weight library providing easy SQLite database storage for .NET, Mono, and Xamarin applications. This version uses P/Invokes to the "sqlite3" native library provided by the operating system. This works on Xamarin.iOS, Xamarin.Mac, Wilderness Labs' Meadow, and any other platform that has a "sqlite3" library in the path.
ELinq 是一个轻量简单易用的开源Linq ORM数据访问组件,支持Nullable类型和枚举类型,对Linq的谓词提供了完美的支持,支持根据实体类自动建库建表建关系,支持根据数据库通过T4模版自动生成实体代码,旨在让绝大部份的主流数据库都使用 Linq 来进行程序开发,让开发人员访问数据库从SQL中解放出来,易学易用上手快,配置简单,并且提供了源代码下载,方便定制。支持多数据库,目前支持Access、SQLServer、SqlCE、SQLite、MySQL、ORACLE,未来还会支持更多的数据库。
ORM for SQLite with data encryption. Supported Xamarin platforms: - Android - iOS 1. Just add [CryptoTable("TableName")] attribute to your class definition (Table) and [Encrypted] attribute to properties in your class that you want to be stored in a database file in encrypted view. 2. Generate your own personal encryption key, and pass it to CryptoSQLite library. 3. CryptoSQLite will encrypt all properties that have '[Encrypted]' attribute automatically when you are adding (updating) elements to your Table and decrypt all [Encrypted] properties when you are getting elements from a Table in the database file. Last updates: In 3.0.2 version .NET Standard compatibility added and fixed minor issues
Simple Get, GetList, GetListPaged, Insert, Update, Delete, DeleteList, and RecordCount extensions for Dapper. Uses smart defaults for attribute free classes but can be overridden as needed. By default uses Id column as the primary key but this can be overridden with an attribute By default queries the table matching the class name but this can be overridden with an attribute By default queries the column matching the property name but this can be overridden with an attribute - Supports SQL Server, PostgreSQL, SQLite, and MySQL - Includes async methods when targeting .Net 4.5
Several XPO Related Helper classes and abstract DX.Data.IDataStore implementation for use with XPO with FluentValidation and no Mapping logic
PostgreSQL helper slots for Magic allowing you to easily connect to a PostgreSQL database, and read, update, delete and insert into your database. To use package go to https://polterguy.github.io
Supported databases: Sql Server, Sql Azure, My Sql, Sqlite, Oracle, PostgreSql, DB2\LUW, Firebird. Fast, small and simple, and very little code needed to perform database actions. Ability to write and run all code unchanged on multiple database vendors. No configuration, no mapping files, no inheritance requirements, no object tracking or caching, just objects and code. Supports writes, updates, or upserts with out the need to write sql, just write your queries for the parent objects. Totally disconnected writes, they can move across application boundaries. Write your own queries, the orm just maps the results. Full transaction support, make multiple calls inside a single transaction. Read and Write isolation, you must use different object for reads and writes. Built in history and performance tracking support. Error tracking, extensive commitment to helping developers understand all exceptions thrown, extensive detailed error messages are provide when possible. Supports change tracking, so the database is only involved when you decide it's necessary. Encryption, allows data to be encrypted prior to writes, and allows un-encryption with loads. Validation support, extensive support for System.ComponentModel.DataAnnotations with the ability to extend and create custom validation with enforcement from the orm. Processing Intercept Support, do special work prior to insert, update, or delete, or after load. Parallel support, run multiple queries in parallel to increase performance. Debugging, all sql is traced out with the parameters and values to aid trouble-shooting. Queries can contain locators which are provided in exceptions. Developer control, all the object creates are overidable, and most methods can be overridden. Supports mutable flat, pure immutable types or hierarchical objects, or objects with children or child properties. Interface abstraction by allowing you to query and retrieve interface types while loading concretes types.
This is the SQLite driver for TranceSQL. TranceSQL provides an easy to use, high performance data access interface for SQL databases. It is minimally abstract compared to ORMs such as Entity Framework. When using TranceSQL, queries are constructing using a structured API that closely resembles the final SQL query.
Extends ADONetHelper library to Sqlite
XPO Based abstract storage provider for ASP.NET Identity
WEF is based on the c # data entity framework supports MSQSqlServer, MySql, Orcalce, etc of conventional database and fast development, which integrates a large amount of data set under the development experience of tools, such as the Lambada without SQL query expression, add and delete, entity cloning, bulk and the parameters of the table, transaction, round of entities or stored procedures, SQL entities, etc. WEF 是基于C#的数据实体框架,支持MSQSqlServer、MySql、Orcalce等等常规的数据库的快捷开发,其中集成了大量数据开发经验下的工具类集合,比如Lambada表达式查询、无sql的增删改查、实体克隆、批量、多表、事务、参数、SQL转实体或存储过程转实体等。
Common extensions methods, helper classes, components, nano systems, and common patterns
Nhibernate based Repository with facilities. Supports: SqlServer, MySql, Sqlite, PostgreeSql
SQLWrapper makes it easier to create code wrappers for SQL queries. It's a powerful tool that helps speed up development by reducing the need for manual coding. It works with databases various SQL database (MySQL, MariaDB, ...), checking the syntax and performance of SQL queries before you execute them. It's important to note that SQLWrapper isn't like other tools that map objects to database tables (ORMs). Instead, it directly generates code from your SQL queries and database structure, which performs better than tools like LINQ, EntityFramework, dapper, ... and doesn't have the same limitations. One feature is that it can look at your database's structure to check if your SQL queries are correct, and it can create an XML file listing all the data your queries need and return. Then, you can use XSLT templates to turn that XML into code in languages like C#, and more. Overall, DAIKOZ.SQLWrapper is a handy tool for making SQL code easier to work with, saving time, and helping you write better code.
.NET Persistence API (also called NPersistence or NPA) is a ORM framework which also enables entity mapping useing annotations!! The project is based on JAVA's JPA and offers applications to use a standard API for their ORM operations. In this package, NPA is implemented by NHibernate. This package also contains SQLITE embedded DB so you can start working with no need to install a DB.
A generic implementation of Dapper, a high performance Micro-ORM supporting SQL Server, MySQL, Sqlite, SqlCE, Firebird etc...
dotConnect for SQLite is a high-performance ORM enabled data provider for SQLite that builds on ADO.NET technology. The provider works with .NET Frameworks 2.0+, .NET Core 2.0+, .NET 5+. It supports a wide range of SQLite-specific features, such as a variety of built-in encryption methods, including TripleDES, Blowfish, AES128, AES192, AES256, Cast128, and RC4. We provide integration with advanced encryption solutions such as SQLiteCrypt and SQLCipher, which typically require separate licenses but are included in our product at no extra cost. Additionally, it supports user-defined functions, CEROD, support for enabling SQLite extensions with connection string parameters, and others. More information at https://www.devart.com/dotconnect/sqlite/ License dotConnect for SQLite is available in several editions https://www.devart.com/dotconnect/sqlite/ordering.html The NuGet package initiates the retrieval of an activation key from the Devart website. This key is required to activate the product for a free trial. Key Features * Built-in SQLite Encryption: Supports robust encryption for your SQLite databases such as TripleDES, Blowfish, AES128, AES192, AES256, Cast128, RC4. * Easy Connection: Allows your application to work with SQLite. * ASP.NET Core: Supports ASP.NET Core Identity. * Performance: Uses many SQLite-specific performance features and optimizations to ensure the highest performance. * Monitoring: Allows per-component tracing of database events with a free dbMonitor application. * Support and updates: Enjoy dedicated support team for prompt issue resolution and regular updates to keep your software running smoothly and securely.
The official collection of get, insert, update and delete helpers for Dapper.net. Also handles lists of entities and optional "dirty" tracking of interface-based entities, Support for multiple databases: SQL Server, MySQL, Sqlite, Postgresql, Oracle...
A lightweight generic entities cacheable repository using Dapper
A small library that help you convert LinQ lambda expression into raw SQL queries with strongly type manner.
SimpleAccess.SQLite intial documentation is available at https://goo.gl/pQzzCr
SQLite-Net Extensions is a very simple ORM that provides cascade operations, one-to-one, one-to-many, many-to-one, many-to-many, inverse and text-blobbed relationships on top of the sqlite-net library.
Configure databases in Prius ORM to connect to SQLite databases. Defines the server type 'SQLite' that you can use in your Prius ORM configuration file.