Install-Package Dapper.Builder.Autofac

dotnet add package Dapper.Builder.Core

     services.AddDapperBuilder(
       new CoreBuilderConfiguration
        {
          DatabaseType = DatabaseType.SQL,
          DbConnectionFactory = (ser) => new SqlConnection("server=(local)")
        });

     builder.RegisterModule(new DapperBuilderModule(new AutofacBuilderConfiguration() {
         DatabaseType = DatabaseType.SQL,
         DbConnectionFactory = (ser) => new SqlConnection("server=(local)")
    }));

public class SomeRepository : ISomeRepository {

  private readonly IQueryBuilder<SomeClass> _query;
  public SomeRepository (IQueryBuilder<SomeClass> query) { _query = query; }

  public async Task<IEnumerable<SomeClass>> GetSomeSimpleStuff () {
      return await _query.Columns (
              nameof (SomeClass.SomeColumnId),
              nameof (SomeClass.AnotherColumn))
          .Where (sc => sc.Date < DateTime.Now.AddDays (-5))
          .SortDescending (sc => sc.CreatedDate).ExecuteAsync ();
  }

  public async Task<IEnumerable<SomeClass>> GetSomeComplexStuff () {
      return await _query.
          .SubQuery<SomeOtherClass> (q =>
              q.Columns (nameof (SomeOtherClass.Id))
              .Alias ("soc")
              .Top (1)
              .ParentAlias<SomeClass> ("sc")
              .Where<SomeClass> ((sc, soc) => sc.SomeId == soc.SomeOtherId)
              , "SubQueryAlias1")
          .SubQuery<SomeOtherClass> (q =>
              q.Top (1)
              .Columns (nameof (SomeOtherClass.Amount))
              .Alias ("soc")
              .ParentAlias<SomeClass> ("sc")
               , "SubQueryAlias2")
          .Alias ("sc")
          .Join<SomeOtherOtherClass> (((sc, sooc) => sooc.SomeClassId == sc.Id))
          .GroupBy ((sc) => sc.SomeId).ExecuteAsync();

  }

    public async Task UpdateAdminData(IUser user)
        queryBuilder.Top(20);
            if(user is IAdmin){
                ApplyAdminPipes(queryBuilder); 
        } else {
            ApplyUserPipes(queryBuilder);
        }
        await queryBuilder.ExecuteUpdateAsync(user);
    }