Norm.net 2.0.0

Norm micro orm

The fastest database mapper for .NET Standard 2.1

the website with tutorial currently under construction

Performances

See detailed perfomance benchmarks compared to Dapper at performance tests page.

Testing

250 tests for SqlServer, PostgreSQL, SQLite and MySql

Local testing

• Under each test project there is a testsettings.json.
• Copy this file and rename it to testsettings.local.json. It will be ignored by git.
• Set the key Default to the value of your actual, local connection string.
• The key TestDatabase contains the name of the test database, which is created and dropped on each testing session, so be careful about that.
• Run dotnet test

Usage

Get it on Nuget

> dotnet add package Norm.net

Use in project

using Norm;

// Start using database connection extensions. Some examples:

// Map results to record:
public record MyRecord(int Id, string Foo, string Bar);
// ...
var records = connection.Query<MyRecord>("select id, foo, bar from my_table");

// Map results to class:
public class MyClass { public int Id { get; init; } public string Foo { get; init; } public string Bar { get; init; } };
// ...
var records = connection.Query<MyClass>("select id, foo, bar from my_table");

// Map single values from tuple to variables:
var (id, foo, bar) = connection.Single<int, string, string>("select id, foor, bar from my_table limit 1");

// Map to enumerable of named tuples:
IEnumerable<(int id, string foo, string bar)> results = connection.Read<int, string, string>("select id, foor, bar from my_table");

// Asynchronously stream values directly from database
await foreach(var (id, foo, bar) in connection.ReadAsync<int, string, string>("select id, foor, bar from my_table"))
{
    //...
}

// etc...

Currently supported platforms

• .NET Standard 2.1

Support

This is open-source software developed and maintained freely without any compensation whatsoever.

If you find it useful please consider rewarding me on my effort by buying me a beer🍻 or buying me a pizza🍕

Or if you prefer bitcoin: bitcoincash:qp93skpzyxtvw3l3lqqy7egwv8zrszn3wcfygeg0mv

Licence

Copyright (c) Vedran Bilopavlović - VB Consulting and VB Software 2020 This source code is licensed under the MIT license.