MicroOrm.Dapper.Repositories 1.25.1

.NET 5.0 .NET Standard 2.0 .NET Framework 4.6.1
dotnet add package MicroOrm.Dapper.Repositories --version 1.25.1
NuGet\Install-Package MicroOrm.Dapper.Repositories -Version 1.25.1
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="MicroOrm.Dapper.Repositories" Version="1.25.1" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add MicroOrm.Dapper.Repositories --version 1.25.1
#r "nuget: MicroOrm.Dapper.Repositories, 1.25.1"
#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.
// Install MicroOrm.Dapper.Repositories as a Cake Addin
#addin nuget:?package=MicroOrm.Dapper.Repositories&version=1.25.1

// Install MicroOrm.Dapper.Repositories as a Cake Tool
#tool nuget:?package=MicroOrm.Dapper.Repositories&version=1.25.1

MicroOrm.Dapper.Repositories

ci NuGet NuGet License MIT

Description

If you like your code to run fast, you probably know about Micro ORMs. They are simple and one of their main goals is to be the fastest execution of your SQL sentences in you data repository. For some Micro ORM's you need to write your own SQL sentences and this is the case of the most popular Micro ORM Dapper

This tool abstracts the generation of the SQL sentence for CRUD operations based on each C# POCO class "metadata". We know there are plugins for both Micro ORMs that implement the execution of these tasks, but that's exactly where this tool is different. The "SQL Generator" is a generic component that generates all the CRUD sentences for a POCO class based on its definition and the possibility to override the SQL generator and the way it builds each sentence.

The original idea was taken from Diego García.

Installation

dotnet add package MicroOrm.Dapper.Repositories

Docs

Metadata attributes

[Key] From System.ComponentModel.DataAnnotations - Use for primary key.

[Identity] Use for identity key.

[Table] From System.ComponentModel.DataAnnotations.Schema - By default the database table name will match the model name but it can be overridden with this.

[Column] From System.ComponentModel.DataAnnotations.Schema - By default the column name will match the property name but it can be overridden with this.

[NotMapped] From System.ComponentModel.DataAnnotations.Schema - For "logical" properties that do not have a corresponding column and have to be ignored by the SQL Generator.

[Deleted], [Status] For tables that implement "logical deletes" instead of physical deletes. Use this to decorate the bool or enum.

[LeftJoin] Left join for property: Collection and object are supported.

[InnerJoin] Inner join for property: Collection and object are supported.

[RightJoin] Right join for property: Collection and object are supported.

[CrossJoin] - SQLite only Cross join for property: Collection and object are supported.

[UpdatedAt] Automatically set DataTime.UtcNow (You can use local date or define offset) for Insert and Update.

Notes

  • By default the SQL Generator is going to map the POCO name with the table name, and each public property to a column.
  • If the [Deleted] is used on a certain POCO, the sentence will be an update instead of a delete.
  • Supports complex primary keys.
  • Supports simple Joins.
  • For this moment, with MSSQL you can only use limit with offset if you call OrderBy first, otherwise limit will be ignored.
  • It has a problem when try to use GUID with dapper in Oracle. In this case it doesn't work. Look details: Dapper#633, Dapper#637

Maps

"Users" POCO:

[Table("Users")]
public class User
{
    [Key, Identity]
    public int Id { get; set; }

    public string ReadOnly => "test"; // because don't have set

    public string Name { get; set; }

    public int AddressId { get; set; }

    [LeftJoin("Cars", "Id", "UserId")]
    public List<Car> Cars { get; set; }

    [LeftJoin("Addresses", "AddressId", "Id")]
    public Address Address { get; set; }

    [Status, Deleted]
    public bool Deleted { get; set; }

    [UpdatedAt]
    public DateTime? UpdatedAt { get; set; }
}

"Cars" POCO:

[Table("Cars")]
public class Car
{
    [Key, Identity]
    public int Id { get; set; }

    public string Name { get; set; }

    public byte[] Data { get; set; }

    public int UserId { get; set; }

    [LeftJoin("Users", "UserId", "Id")]
    public User User { get; set; }

    [Status]
    public StatusCar Status { get; set; }
}

public enum StatusCar
{
    Inactive = 0,

    Active = 1,

    [Deleted]
    Deleted = -1
}

Example Implements the simple repository:

public class UserRepository : DapperRepository<User>
{
    public UserRepository(IDbConnection connection, ISqlGenerator<User> sqlGenerator)
        : base(connection, sqlGenerator)
    {

    }
}

Queries

Find by ID:

var user = await userRepository.FindAsync(x => x.Id == 5);

Query with limit:

var limit = 10u;
var users = await userRepository.SetLimit(limit).FindAllAsync();

Query with limit and offset:

var limit = 10u;
var offset = 5u;
var users = await userRepository.SetLimit(limit, offset).FindAllAsync();

Query with OrderBy:

var users = await userRepository.SetOrderBy(OrderInfo.SortDirection.DESC, x => x.CreatedAt).FindAllAsync();

Query with SetSelect:

var users = await userRepository.SetSelect(x => new {x.Id, x.Name}).FindAllAsync();

Find all users for AccountId equals to 3 and not logical deleted:

var allUsers = await userRepository.FindAllAsync(x => x.AccountId == 3 && x.Deleted != false);

Example with Asp.Net Core and D.I

Configure Services
//Your DB Provider
MicroOrmConfig.SqlProvider = SqlProvider.MySQL;
//Not required
MicroOrmConfig.TablePrefix = "db1_";
//Add generic SqlGenerator as singleton
services.AddSingleton(typeof(ISqlGenerator<>), typeof(SqlGenerator<>));
//Your db factory
services.AddSingleton<IDbConnectionFactory, DbFactory>(x => new DbFactory(appSettings.DbConnectionString));
Example implements BaseRepository with IDbConnectionFactory
public class BaseRepository<T> : DapperRepository<T> where T : class
{
    private readonly IDbConnectionFactory _factory;
    public BaseRepository(IDbConnectionFactory factory, ISqlGenerator<T> generator)
        : base(factory.OpenDbConnection(), generator)
    {
        _factory = factory;
    }

    protected IDbConnection GetConnection()
    {
        return _factory.OpenDbConnection();
    }
 }

License

All contents of this package are licensed under the MIT license.

Product Compatible and additional computed target framework versions.
.NET net5.0 is compatible.  net5.0-windows was computed.  net6.0 was computed.  net6.0-android was computed.  net6.0-ios was computed.  net6.0-maccatalyst was computed.  net6.0-macos was computed.  net6.0-tvos was computed.  net6.0-windows was computed.  net7.0 was computed.  net7.0-android was computed.  net7.0-ios was computed.  net7.0-maccatalyst was computed.  net7.0-macos was computed.  net7.0-tvos was computed.  net7.0-windows was computed. 
.NET Core netcoreapp2.0 was computed.  netcoreapp2.1 was computed.  netcoreapp2.2 was computed.  netcoreapp3.0 was computed.  netcoreapp3.1 was computed. 
.NET Standard netstandard2.0 is compatible.  netstandard2.1 was computed. 
.NET Framework net461 is compatible.  net462 was computed.  net463 was computed.  net47 was computed.  net471 was computed.  net472 was computed.  net48 was computed.  net481 was computed. 
MonoAndroid monoandroid was computed. 
MonoMac monomac was computed. 
MonoTouch monotouch was computed. 
Tizen tizen40 was computed.  tizen60 was computed. 
Xamarin.iOS xamarinios was computed. 
Xamarin.Mac xamarinmac was computed. 
Xamarin.TVOS xamarintvos was computed. 
Xamarin.WatchOS xamarinwatchos was computed. 
Compatible target framework(s)
Additional computed target framework(s)
Learn more about Target Frameworks and .NET Standard.

NuGet packages (3)

Showing the top 3 NuGet packages that depend on MicroOrm.Dapper.Repositories:

Package Downloads
Crystal.Dapper

This package contains the classes and methods to work with Dapper

GbLib.DapperOrm

DapperOrm

GenericCRUD

Don't repeat yourself! GenericCrud is a highly flexible library that provides your API with a skeleton for CRUD controllers without using EF. You can configure model validation, user permission validation etc.

GitHub repositories

This package is not used by any popular GitHub repositories.

Version Downloads Last updated
1.25.1 4,935 7/3/2023
1.25.0 33,963 2/26/2023
1.24.2 4,883 1/31/2023
1.24.1 31,307 1/4/2023
1.24.0 1,576 11/21/2022
1.23.2 15,857 10/16/2022
1.23.1 10,231 9/8/2022
1.23.0 11,526 7/14/2022
1.22.0 17,721 5/1/2022
1.21.0 22,091 2/9/2022
1.20.1 610 2/9/2022
1.20.0 2,524 1/29/2022
1.19.1 18,681 9/19/2021
1.19.0 7,349 8/26/2021
1.18.1 47,118 6/24/2021
1.18.0 8,178 5/21/2021
1.17.0 7,272 4/29/2021
1.16.2 21,569 3/29/2021
1.16.1 4,502 3/12/2021
1.16.0 23,216 2/18/2021
1.15.0 47,851 8/28/2020
1.14.1 102,483 3/1/2020
1.14.0 746 2/27/2020
1.13.0 1,010 2/18/2020
1.12.0 25,027 1/11/2020
1.11.0 25,615 11/14/2019
1.11.0-beta1 1,754 10/4/2019
1.10.0-beta3 13,035 4/26/2019
1.10.0-beta2 639 4/10/2019
1.10.0-beta1 16,060 8/25/2018
1.8.3 120,616 10/26/2017
1.8.2 2,218 9/16/2017
1.8.1 2,082 8/20/2017
1.8.0 1,540 7/18/2017
1.7.3 2,224 5/30/2017
1.7.2 1,257 5/25/2017
1.7.1 2,839 5/9/2017
1.7.0 1,403 5/8/2017
1.6.6 1,616 4/21/2017
1.6.5 1,211 4/19/2017
1.6.4 1,214 4/16/2017
1.6.3 1,339 4/5/2017
1.6.2 4,956 3/28/2017
1.6.1 8,259 3/14/2017
1.6.0 6,060 3/6/2017
1.6.0-beta5 1,131 2/18/2017
1.6.0-beta4 1,397 12/15/2016
1.6.0-beta3 940 12/14/2016
1.6.0-beta2 968 12/2/2016
1.6.0-beta1 939 12/1/2016
1.5.0 5,639 8/18/2016
1.4.2 3,922 7/20/2016
1.4.1 1,171 7/19/2016
1.4.0 1,455 7/11/2016
1.4.0-beta3 1,012 7/7/2016
1.4.0-beta1 1,618 2/23/2016
1.3.3 1,761 11/3/2015
1.3.2 1,251 10/22/2015
1.3.1 1,207 10/13/2015
1.2.3 1,355 9/25/2015
1.2.1 1,630 9/9/2015
1.2.0 1,615 8/31/2015
1.0.1 1,619 7/24/2015
1.0.0 1,581 7/7/2015