TheOne.OrmLite - Fast, Simple, Typed ORM for .NET

Usage

First install the NuGet package of the RDBMS you want to use, e.g:

PM> Install-Package TheOne.OrmLite.SqlServer

All NuGet packages and available Dialect Providers:

• TheOne.OrmLite
• TheOne.OrmLite.SqlServer, supports net46 and netstandard2.0
  • SqlServerDialect.Provider : SQL Server 2008
  • SqlServer2008Dialect.Provider : SQL Server 2008
  • SqlServer2012Dialect.Provider : SQL Server 2012
  • SqlServer2014Dialect.Provider : SQL Server 2014
  • SqlServer2016Dialect.Provider : SQL Server 2016
  • SqlServer2017Dialect.Provider : SQL Server 2017+
• TheOne.OrmLite.SqlServer.Converters, net46 only
  • Sql Server SqlHierarchyId, SqlGeography, SqlGeometry support with Microsoft.SqlServer.Types
• TheOne.OrmLite.Sqlite, supports net46 and netstandard2.0
  • SqliteDialect.Provider : Sqlite with System.Data.SQLite.Core
• TheOne.OrmLite.PostgreSql, supports net46 and netstandard2.0
  • PostgreSqlDialect.Provider : PostgreSql with Npgsql
• TheOne.OrmLite.MySql, supports net46 and netstandard2.0
  • MySqlDialect.Provider : MySql with MySql.Data
• TheOne.OrmLite.MySqlConnector, supports net46 and netstandard2.0
  • MySqlConnectorDialect.Provider : MySql with MySqlConnector
• TheOne.OrmLite.Oracle, supports net46 and netstandard2.0
  • OracleDialect.Provider : Oracle with Oracle.ManagedDataAccess and Oracle.ManagedDataAccess.Core

To configure OrmLite you need the DB Connection string along the Dialect Provider of the RDBMS you're connecting to, e.g:

var dbFactory = new OrmLiteConnectionFactory(connectionString, SqlServerDialect.Provider);

If you're using an IOC you can register OrmLiteConnectionFactory as a singleton, e.g:

container.Register<IDbConnectionFactory>(c => new OrmLiteConnectionFactory(":memory:", SqliteDialect.Provider));

You can then use the dbFactory to open ADO.NET DB Connections to your database.

using (var db = dbFactory.Open()) {
    db.CreateTable<Poco>();

    db.Insert(new Poco { Id = 1, Name = "Seed Data"});

    var result = db.SingleById<Poco>(1);
    result.ToJson(); // = { "Id": 1, "Name": "Seed Data" }
}

Examples

Change connection strings in Config.cs as necessary.

• Create Table
• Select
• Insert
• Update
• Delete
• Soft Delete
• Shippers Example
• Customer Orders Use Case
• ApiSqlServerTestsAsync.cs
• See unit tests for more api examples

Logging

See LibLog