SQLite-net is an open source and light weight library providing easy SQLite database storage for .NET, Mono, and Xamarin applications. This version uses SQLitePCLRaw to provide platform independent versions of SQLite.
A high performance Micro-ORM supporting SQL Server, MySQL, Sqlite, SqlCE, Firebird etc. Major Sponsor: Dapper Plus from ZZZ Projects.
You hate verbatim SQL queries with zero type safety for your code but you love the speed? Dapper.FastCRUD is built around essential features of the C# 6 / VB that have finally raised the simplicity of raw SQL constructs to acceptable maintenance levels. These features leave no chance to mistypings or problems arising from db entity refactorings. Visual Studio 2019 or later is recommended.
IDbTransaction extension methods for Dapper: A high performance Micro-ORM supporting SQL Server, MySQL, Sqlite, SqlCE, Firebird etc.. --------------------------------------- This library is sponsored by ZZZ Projects: https://dapper-plus.net/ https://eval-expression.net/ https://entityframework-extensions.net/ ---------------------------------------
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.
LINQ to DB ASP.NET Core Extensions adds ability to configure ASP.NET Core application for Linq To DB usage.
FreeSql is the ORM in .NetCore, .NetFramework, And Xamarin. It supports Mysql, Postgresql, SqlServer, Oracle, Sqlite, Firebird, Clickhouse, DuckDB, TDengine, QuestDB, Odbc, Oledb, 达梦, 人大金仓, 南大通用, 虚谷, 神舟通用, 翰高, And Access
SQLite-net is an open source and light weight library providing easy SQLite database storage for .NET, Mono, and Xamarin applications. This version uses SQLitePCLRaw to provide platform independent versions of SQLite with the SQLCipher extension. This enables secure access to the database with password (key) access.
Shaolinq is a thoughtfully designed ORM and Linq provider for .NET Designed to perform super fast and be easy to use, Shaolinq's features also include: - First class schema-first ORM with WYSIWYG data access and minipulation. - First class LINQ support (not the basic kind you see in most other OSS projects). - Single trip updating of objects. - Support for Sqlite, MySql and Postgres. - Automatic database creation and schema migration. - Delete LINQ extension for batch server side deletes. - Full support for server side date functions (Date.DayOfWeek etc). - Easily extensible with a simple interface for adding support for other ADO.NET compatible databases. - Open Source!
Light, simple and fast convention-based code-first POCO ORM for SQLite. Support for Creating and Dropping Table Schemas from POCOs, Complex Property types transparently stored in schemaless text blobs in SQLite.
Expression表达式转换为SQL语句,支持SqlServer、MySql、Oracle、Sqlite、PostgreSql;基于Dapper实现了不同数据库对应的数据仓储Repository;
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.
T4 scaffolding templates to generate LINQ to DB data models for different databases. It provides scaffolding functionality and reference to linq2db main package only. To use Linq To DB in your project you should add reference to corresponding database provider(s) explicitly.
Shaolinq is a thoughtfully designed ORM and Linq provider for .NET Use this package to add Shaolinq and out-of-the-box MySql support. Designed to perform super fast and be easy to use, Shaolinq's features also include: - First class schema-first ORM with WYSIWYG data access and minipulation. - First class LINQ support (not the basic kind you see in most other OSS projects). - Single trip updating of objects. - Support for Sqlite, MySql and Postgres. - Automatic database creation and schema migration. - Delete LINQ extension for batch server side deletes. - Full support for server side date functions (Date.DayOfWeek etc). - Easily extensible with a simple interface for adding support for other ADO.NET compatible databases. - Open Source!
FreeSql 数据库实现,基于 Sqlite 3.0,支持 .NetCore、.NetFramework、Xamarin
Adds support for NodaTime types when using SQLite with Entity Framework Core.
Shaolinq is a thoughtfully designed ORM and Linq provider for .NET Use this package to add Shaolinq and out-of-the-box Sqlite support. Designed to perform super fast and be easy to use, Shaolinq's features also include: - First class schema-first ORM with WYSIWYG data access and minipulation. - First class LINQ support (not the basic kind you see in most other OSS projects). - Single trip updating of objects. - Support for Sqlite, MySql and Postgres. - Automatic database creation and schema migration. - Delete LINQ extension for batch server side deletes. - Full support for server side date functions (Date.DayOfWeek etc). - Easily extensible with a simple interface for adding support for other ADO.NET compatible databases. - Open Source!
Shaolinq is a thoughtfully designed ORM and Linq provider for .NET Use this package to add Shaolinq and out-of-the-box Postgres support (via Npgsql). Designed to perform super fast and be easy to use, Shaolinq's features also include: - First class schema-first ORM with WYSIWYG data access and minipulation. - First class LINQ support (not the basic kind you see in most other OSS projects). - Single trip updating of objects. - Support for Sqlite, MySql and Postgres. - Automatic database creation and schema migration. - Delete LINQ extension for batch server side deletes. - Full support for server side date functions (Date.DayOfWeek etc). - Easily extensible with a simple interface for adding support for other ADO.NET compatible databases. - Open Source!
.NET Standard 2.0 version of ServiceStack.OrmLite.Sqlite
LinqConnect is a fast, lightweight, and easy to use LINQ to SQL compatible ORM solution, supporting SQL Server, Oracle, MySQL, PostgreSQL, and SQLite. It allows you to use efficient and powerful data access for your .NET Framework, or .NET Core applications supporting Code-First, Model-First, Database-First or mixed approaches. This package contains the .NET Standard/.NET Core compatible assemblies. This package contains only runtime features of LinqConnect. LinqConnect is also provided as an installation package (exe), which installs runtime assemblies for Full .NET Framework and a set of design-time tools, integrated into Visual Studio. It also includes visual ORM designer for LinqConnect ORM models. Besides, this installer generates the trial key files required for using this package on a trial basis. You can download it at www.devart.com.
T4 scaffolding templates for SQLite database to generate LINQ to DB data models. It provides only scaffolding functionality and to use Linq To DB in your project you should add reference to linq2db nuget and corresponding database provider explicitly.
Shaolinq is a thoughtfully designed ORM and Linq provider for .NET Use this package to add Shaolinq and out-of-the-box Postgres support (via the DotConnect ADO.NET Postgres provider). Designed to perform super fast and be easy to use, Shaolinq's features also include: - First class schema-first ORM with WYSIWYG data access and minipulation. - First class LINQ support (not the basic kind you see in most other OSS projects). - Single trip updating of objects. - Support for Sqlite, MySql and Postgres. - Automatic database creation and schema migration. - Delete LINQ extension for batch server side deletes. - Full support for server side date functions (Date.DayOfWeek etc). - Easily extensible with a simple interface for adding support for other ADO.NET compatible databases. - Open Source!
This is a special version of SQLite-net-pcl that does not include a SQLitePCLRaw bundle. It is meant to give you all the power of SQLite-net but with the freedom to choose your own provider. Please use the package sqlite-net-pcl if you have no idea what any of this means.
cyq.data is a high-performance and the most powerful orm.(.NET 最好用的ORM数据层框架,木有之一!支持.NET所有版本、支持.NET Core所有版本)Support:Mssql、Mysql、Oracle、Sybase、Postgres、DB2、FireBird、Sqlite、DaMeng(达梦)、KingBaseES(人大金仓)、Txt、Xml、Access、Excel、FoxPro、Redis、MemCache。 (开源地址:https://github.com/cyq1162/cyqdata)
Shaolinq is a thoughtfully designed ORM and Linq provider for .NET Use this package to add Shaolinq and out-of-the-box MySql support. Designed to perform super fast and be easy to use, Shaolinq's features also include: - First class schema-first ORM with WYSIWYG data access and minipulation. - First class LINQ support (not the basic kind you see in most other OSS projects). - Single trip updating of objects. - Support for Sqlite, MySql, Postgres and SQL Server. - Automatic database creation and schema migration. - Delete LINQ extension for batch server side deletes. - Full support for server side date functions (Date.DayOfWeek etc). - Easily extensible with a simple interface for adding support for other ADO.NET compatible databases. - Open Source!
Version of OrmLite Sqlite that uses Microsoft.Data.Sqlite
For cross-platform Sqlite use ServiceStack.OrmLite.Sqlite instead. Light, simple and fast convention-based code-first POCO ORM for SQLite. Support for Creating and Dropping Table Schemas from POCOs, Complex Property types transparently stored in schemaless text blobs in SQLite.
SQLite-net is an open source and light weight library providing easy SQLite database storage for .NET, Mono, and Xamarin applications. This version uses SQLitePCLRaw to provide platform independent versions of SQLite.
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.
Simple database wrapper for Microsoft SQL Server, MySQL, PostgreSQL, and Sqlite. written in C# supporting dynamic query building and nesting using expressions. Refer to other DatabaseWrapper packages if you only need support for one database type.
This package is deprecated. Use the new ServiceStack.OrmLite.Sqlite.Windows NuGet package which supports both x86/x64 architectures.
A cross-platform, fully asynchronous fork of the popular PetaPoco micro-ORM. Supports SQL Server, Oracle, MySQL, PostgreSQL, SQLite, and SQL Server CE. Runs on .NET Framework (4.5 and above), .NET Core (1.0 and 2.0), Mono, Xamarin (iOS, Mac, and Android), and UWP.
This package is deprecated. Use the new ServiceStack.OrmLite.Sqlite.Windows NuGet package which supports both x86/x64 architectures.
EntityWorker is an object-relation mapper(ORM) that enable .NET developers to work with relations data using objects. EntityWorker is an alternative to entityframwork. is more flexible and much faster than entity framework. And it have support to multiple providers like mssql, sqlite and postgressql. Note: We had come a long way now. Linq to SQL is working well now. Please provide any information on bugs or improvement you may find or think of.