SQLite ORM

A high performance Micro-ORM supporting SQL Server, MySQL, Sqlite, SqlCE, Firebird etc. Major Sponsor: Dapper Plus from ZZZ Projects.

LINQ to DB is a data access technology that provides a run-time infrastructure for managing relational data as objects.

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.

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.

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.

LINQ to DB is a data access technology that provides a run-time infrastructure for managing relational data as objects.

A generic and dynamic SQL data adapter, allowing you to generate SQL dialects, specific to your database type, such as MySQL or SQL Server. This is the core base class data adapter for Magic. To use package go to https://polterguy.github.io

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.

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!

FluentData is a Micro ORM that makes it simple to select, insert, update and delete data in a database. It gives the developer the power of ADO.NET but with the convenience of an ORM. It has a simple to use fluent API that uses SQL - the best and most suitable language to query data, and SQL or fluent builders to insert, update and delete data.

Deprecated. Use ServiceStack.OrmLite.Sqlite package instead.

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.

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)

SQLitePCL.pretty wraps the C like SQLiteAPI provided by SQLitePCL.raw with a friendly C# object oriented API. Notable features include support for using LINQ expressions on SQL query results, SQLite events exposed as C# events, and the ability to take advantage of advance SQLite features, such as collation, aggregate, scalar, and commit hook functions. For asynchronous query support, an additional companion API is available. See: https://www.nuget.org/packages/SQLitePCL.pretty.Async/ A simple table mapped ORM is also available. See https://www.nuget.org/packages/SQLitePCL.pretty.Orm/

PetaPoco.NetCore is a fork of PetaPoco based, add .netcore support,support .netframework and .netcore,petapoco is A high performance Micro-ORM on dotnet supporting SQL Server, MySQL, Sqlite, SqlCE, Firebird etc,support a query and map,and support Multi Mapping, Multiple Results

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.

(OBSOLETE)

A hybrid .NET ORM library for SqLite.

This package is deprecated. Use the new ServiceStack.OrmLite.Sqlite.Windows NuGet package which supports both x86/x64 architectures.

Lightweight multi-platform ORM for mobile, desktop and servers. A data provider is required to use this library. Providers for Sqlite, SQL Server and MySql are available on Nuget.

Business Logic Toolkit SQLite Data Provider for .NET

This package is deprecated. Use the new ServiceStack.OrmLite.Sqlite.Windows NuGet package which supports both x86/x64 architectures.

Lightweight multi-platform ORM for mobile, desktop and servers. Data providers for Sqlite, SQL Server, MySql and Postgres are available as separate Nuget packages

.NET's best ORM data layer framework, one of the wood, low-key continuous update for 15 years! In the tank. Net Framework 2.0+, supported. Net Core 2.1+ supports a variety of databases, built-in database read/write separation, distributed cache, distributed locks, etc（.Net 最好用的ORM数据层框架，木有之一，低调持续更新15年！支持.Net Framework 2.0+，支持.Net Core 2.1+，支持多种数据库，自带数据库读写分离，分布式缓存，分布式锁等，开源地址：https://github.com/cyq1162/cyqdata）

SmartDb.NetCore是一套基于ADO.Net和DoNetCore对 SqlServer、MySql、SQLite、PostgreSql数据库支持的快速开发和轻量级ORM框架。 包NuGet地址：https://www.nuget.org/packages/SmartDb.NetCore 框架Git开源地址：https://github.com/joyet/SmartDb.NetCore 框架博客地址：https://www.cnblogs.com/joyet-john/articles/9295985.html#4021708 联系邮箱：joyet@qq.com

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.

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.

ELinq 是一个轻量简单易用的开源Linq ORM数据访问组件，支持Nullable类型和枚举类型，对Linq的谓词提供了完美的支持，支持根据实体类自动建库建表建关系，支持根据数据库通过T4模版自动生成实体代码，旨在让绝大部份的主流数据库都使用 Linq 来进行程序开发，让开发人员访问数据库从SQL中解放出来，易学易用上手快，配置简单，并且提供了源代码下载，方便定制。支持多数据库，目前支持Access、SQLServer、SqlCE、SQLite、MySQL、ORACLE，未来还会支持更多的数据库。

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.

Deprecated. Use the strong named ServiceStack.OrmLite.Sqlite.Windows package instead.

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!

* Generate SQL code for Create and Drop tables, columns, indexes, and foreign keys * Generate SQL code for Insert, Select, Delete, Update, Create & Drop operations, without writing SQL code yourself * Select operation is capable of using joins, aggregation, group by, sort, limit, pretty much everything supported

Converter Helpers for dynamic, ExpandoObject, IEnumerable, IDictionary, DataTable and etc.

The package Provides a solution for the UnitOfWork patterns together with inversition of control. It is the core abstractions, interfaces and core classes that can be used for any ORM. 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... Utilize this package with: https://www.nuget.org/packages/Smooth.IoC.Dapper.Repository.UnitOfWork/ 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. * 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+

Access a database without an ORM and subscribe to database change events in C#

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!

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 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!

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!

* Generate SQL code for Create and Drop tables, columns, indexes, and foreign keys * Generate SQL code for Insert, Select, Delete, Update, Create & Drop operations, without writing SQL code yourself * Select operation is capable of using joins, aggregation, group by, sort, limit, pretty much everything supported

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.

A high performance Micro-ORM supporting SQL Server, MySQL, Sqlite, etc..

A cool little wrapper for SQLite based on Dapper.

Sumo.Data.Orm is a light-weight, IoC capable ORM. Database specific support libraries are available. SQLite: Sumo.Data.Sqlite and Sumo.Data.Schema.Sqlite. Microsoft Sql Server: Sumo.Data.SqlServer and Sumo.Data.Schema.SqlServer.

Daterpillar is a data access and transformation technology for new applications.

A high performance Micro-ORM supporting SQL Server, MySQL, Sqlite, SqlCE, Firebird etc..

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+.

Daterpillar is a miro-orm that currently supports SQL Server, MySQL and SQLite. The library helps you to do the following. * Generate a database schema from classes marked with specific attributes. * Construct SQL queries. * Construct SQL commands. ******************* * USAGE * ******************* 1- Generating schemas. The package ships with a msbuild target that runs before the build target. When executed the target will generate a xml file (<asseblyName>.schema.xml) in the project output directory. You can specify which classes are included in the xml file decorating them will attributes. example: [Table] public class User { [Column] public int Id { get; set; } [Column] public string Name { get; set; } } 2- Constructing SQL queries The Query class contain methods to help create SQL queries. There is also a Query<T> class that uses relfection to build the queries where as the Query class uses plain old string concatenation. example: var query = new Query<User>(Syntax.MySQL) .SelectAll() .Where(x=> x.Name == "john"); or var query = new Query(Syntax.MySQL) .SelectAll() .Where("name='john'"); output: SELECT * FROM User Where Name='john'; 3- Constructing SQL commands The library contain several extension methods to generate commands from objects. example: var user = new User() { Id = 12, Name = "john" }; var insertCmd = user.ToInsertCommand(); output: INSERT INTO User (Id, Name) VALUES ('12', 'john'); var users = new User[] { ... }; var insertCmd = users.ToInsertCommand(); output: output: INSERT INTO User (Id, Name) VALUES ('12', 'john'), ...

Flexible, simple, feature complete, multi-database, multi-platform ORM. Works with any class, any naming convention, and most used databases. ## Features * Works on top of OKHOSTING.SQL which give us access to MySql, SQLite and "DataBase web service" in mobile, and MySql, SQLite, SQL Server and PostgresSQL on desktop * Real POCOs, you don't need use "special classes", you can use any class you already have * Supports every database schema you want to use. You dont need a "special schema" * Supports any inheritance strategy you desire, and any one to many and many to many relationships you need * Class name and table name can be different, the same goes for properties and columns * Supports single and multi column primary keys, and foreign keys * You won't have to write SQL never again, unless you want to * Works on Windows, Linux, Mac, Android, iOS, Windows Phone and Universal Windows Platform * Allows you to create complex select operations, strongly typed, that include joins, limits, order, aggregated funcionts, group by * Very fast, light and small * Pretty easy to use Please visit: https://github.com/okhosting/OKHOSTING.ORM

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