TinyORM 2.0.2

.NET 8.0 This package targets .NET 8.0. The package is compatible with this framework or higher. .NET Framework 4.8 This package targets .NET Framework 4.8. The package is compatible with this framework or higher. 
dotnet add package TinyORM --version 2.0.2
                    


                    

                
NuGet\Install-Package TinyORM -Version 2.0.2
This command is intended to be used within the Package Manager Console in Visual Studio, as it uses the NuGet module's version of Install-Package. 
<PackageReference Include="TinyORM" Version="2.0.2" />
For projects that support PackageReference, copy this XML node into the project file to reference the package. 
<PackageVersion Include="TinyORM" Version="2.0.2" />
                    


                            Directory.Packages.props
                        

                    

                
<PackageReference Include="TinyORM" />
                    


                            Project file
For projects that support Central Package Management (CPM), copy this XML node into the solution Directory.Packages.props file to version the package. 
paket add TinyORM --version 2.0.2
                    


                    

                
#r "nuget: TinyORM, 2.0.2"
#r directive can be used in F# Interactive and Polyglot Notebooks. Copy this into the interactive tool or source code of the script to reference the package. 
#:package TinyORM@2.0.2
#:package directive can be used in C# file-based apps starting in .NET 10 preview 4. Copy this into a .cs file before any lines of code to reference the package. 
#addin nuget:?package=TinyORM&version=2.0.2
                    


                            Install as a Cake Addin
                        

                    

                
#tool nuget:?package=TinyORM&version=2.0.2
                    


                            Install as a Cake Tool

TinyORM

Simple, fast, and secure micro ORM for .NET NuGet

TinyORM by Stan Drapkin [sdrapkin at sdprime dot com]

Documentation: wiki

Features:

  1. Focused on SQL Server (any SqlClient-based db engine). Azure SQL is supported as well.
  2. Intuitive, tiny, simple API. This is usually the hardest part for libraries to get right.
  3. Does not obscure or reinvent T-SQL. If you prefer APIs that hide T-SQL incompetence, look elsewhere.
  4. Very fast. As fast as competition (Dapper, OrmLite, LLBLGen, EF Core, etc. benchmarks).
  5. Seamlessly transactional and safe. Transactions are not merely supported - they are the default.
    • XACT_ABORT=ON (automatic transaction rollback on runtime T-SQL errors).
    • Custom transaction scopes are declared via standard TransactionScope instance (created via TinyORM.DbContext.CreateTransactionScope() factory).
  6. Transparent connection management. One less thing to worry about and screw up. Never think about connections again.
  7. Task-based async API (ie. the API). All calls are buffered (focus on safety and fast connection release).
  8. POCOs or anonymous objects are fine. No inheritance, interface, or attribute requirements.
  9. Returns dynamic entities which can be consumed directly, or projected to statically-typed objects (fast!).
    • Either strict (perfect-match) or relaxed (best-effort) projection of dynamic to statically-typed objects.
  10. Full parameterization, with parameter list expansion (ex. WHERE Id IN (@IdList)). This also helps prevent SQL injection.
    • CHAR, VARCHAR, NCHAR, NVARCHAR support for string parameters.
  11. Single or multiple Result Sets.
  12. Snapshots provide change-tracking, with UPDATE T-SQL generation for partial updates.
  13. Intelligent batched *bulk* command sequences via QueryBatch (not just for INSERT - for all CREATE/UPDATE/DELETE/MERGE commands).
  14. Streaming data-out support (ex. streaming out BLOBs/files).
  15. Auditing
    • Caller identity tracking (which user made the call?).
    • Callsite tracking (which source code filename, method, and line# made the call?).
  16. Helpers for CREATE, UPDATE, DELETE, and UPSERT T-SQL generation.
  17. SequentialGuid generator for fragmentation-free, unique, unguessable, code-generated clustered uniqueidentifier indexes.
  18. c# 10.0 in safe mode. Compiled any cpu for .NET 4.5.2+ and NetStandard 2.0/.NET Core 2.0+.
  19. Tiny codebase. Tiny ~45k .dll.
  20. TinyORM on NuGet (Install-Package TinyORM).
  21. MS-PL (Microsoft Public) license. If MS-PL does not suit you, contact me.

If you are serious about SQL Server, give TinyORM a try (even if you're a Dapper fan).

Simple TinyORM query

var db = DbContext.Create(connString);
var query = await db.QueryAsync("select [Answer] = @a + @b", new { @a = 123, @b = 2 });

Console.WriteLine(query.First().Answer); // prints "125"

static string connString = "Data Source=.\\SQL2012; Initial Catalog=tempdb; Integrated Security=True;";

Nature graphic by Freepik is licensed under CC BY 3.0.

Product Compatible and additional computed target framework versions.
.NET net8.0 is compatible.  net8.0-android was computed.  net8.0-browser was computed.  net8.0-ios was computed.  net8.0-maccatalyst was computed.  net8.0-macos was computed.  net8.0-tvos was computed.  net8.0-windows was computed.  net9.0 was computed.  net9.0-android was computed.  net9.0-browser was computed.  net9.0-ios was computed.  net9.0-maccatalyst was computed.  net9.0-macos was computed.  net9.0-tvos was computed.  net9.0-windows was computed.  net10.0 was computed.  net10.0-android was computed.  net10.0-browser was computed.  net10.0-ios was computed.  net10.0-maccatalyst was computed.  net10.0-macos was computed.  net10.0-tvos was computed.  net10.0-windows was computed. 
.NET Framework net48 is compatible.  net481 was computed. 
Compatible target framework(s)
Included target framework(s) (in package)
Learn more about Target Frameworks and .NET Standard.

NuGet packages

This package is not used by any NuGet packages.

GitHub repositories

This package is not used by any popular GitHub repositories.

Version Downloads Last Updated
2.0.2 205 2/12/2025
2.0.0 213 12/11/2024
1.3.7 284 1/16/2024
1.3.6 1,331 11/9/2022
1.3.5 757 2/1/2022
1.3.4 600 1/29/2022
1.3.3 6,056 9/29/2020
1.3.2 889 2/20/2020
1.3.1 1,081 1/3/2020
1.3.0 2,269 10/24/2019
1.2.7067.20307 3,540 5/8/2019
1.1.6898.20236 1,625 11/20/2018
1.1.6862.24420 986 10/15/2018
1.1.6848.28993 1,027 10/1/2018
1.1.6701.26060 2,146 5/7/2018
1.1.6528.30785 1,437 11/15/2017
1.1.6326.31656 1,985 4/27/2017
1.0.6314.33866 1,299 4/15/2017
1.0.6310.25316 1,310 4/11/2017
1.0.6309.30883 1,318 4/10/2017
1.0.5 1,358 3/23/2017
1.0.4 1,300 3/21/2017
1.0.3 1,340 1/25/2017
1.0.2 1,337 1/4/2017

Switched to Microsoft.Data.SqlClient [https://techcommunity.microsoft.com/blog/sqlserver/announcement-system-data-sqlclient-package-is-now-deprecated/4227205].
Retargeted for [net8.0+] (modern use) and [net48] (legacy use).
Tested with Microsoft.Data.SqlClient 6.0.1 (https://learn.microsoft.com/en-us/sql/connect/ado-net/introduction-microsoft-data-sqlclient-namespace).
DbContext.Create() gets a new SqlConnectionOverrides parameter (https://learn.microsoft.com/en-us/dotnet/api/microsoft.data.sqlclient.sqlconnectionoverrides).
Added support for System.DateOnly and System.TimeOnly (.NET 8+).