ThomasDataAdapter.SqlServer 2.1.0

ThomasDataAdapter

It Works matching class fields againts result set returned by database query. There are simple configurations for applications that need fast response time without must deal with database DbConnections and DbCommands.

Features released 2.1.0:

• Set a unique signature for each database settings that must instantiate statically a database context whenever you want.
• Straightforward manner to match typed and anonymous types to query parameters.
• Transaction support using lambda expressions.
• Attributes to match parameter direction and size to configure DbParameter.
• Optional Cache layer to boost application performance having control what will be stored, updated and removed.
• Cache refresh throught a key identifier to allow refresh whenever you want update the cached data without use original query.

Nuget : https://www.nuget.org/packages/ThomasDataAdapter.SqlServer/

Basic configuration in startup.cs :

using Thomas.Database.SqlServer;
.
.
.
SqlServerFactory.AddDb(new DbSettings 
{
    Signature = "mssqldb1",
    StringConnection = @"Data Source={SourceName};Initial Catalog={database};User ID={User};Password={Pass}"
});

Custom configuration :

using Thomas.Database.SqlServer;
.
.
.
SqlServerFactory.AddDb(new DbSettings { 
    Signature = "mssqldb1",
    StringConnection = @"Data Source={SourceName};Initial Catalog={database};User ID={User};Password={Pass}",
    DetailErrorMessage = true,
    ConnectionTimeout = 300,
    SensitiveDataLog = true
 });

How to use it?

public class UserOffice
{
    private readonly IThomasDb _db;

    public User()
    {
        _db =  DbFactory.CreateDbContext("mssqldb1");
    }

    public IEnumerable<User> GetUsers() => _db.ToList<User>("dbo.GetPeople");
    public void SaveUser(User person) =>_db.Execute(person, "dbo.Save");
    public void UpdateUser(string id, int age) => _db.ExecuteOp(new { id = id, age = age}, "dbo.Update");
    public Tuple<IEnumerable<User>, IEnumerable<Office>> ProcessData() => _db.ToTupleOp<User, Office>("dbo.Process");

    public bool ActiveOffice(decimal officeId)
    {
        return _db.ExecuteTransaction((db) =>
        {
            db.Execute($"UPDATE User SET Active = 1 WHERE OfficeId = @OfficeId", new { OfficeId = officeId });
            db.Execute($"UPDATE Office SET Active = 1 WHERE OfficeId = @OfficeId", new { OfficeId = officeId });
            return db.Commit();
        });
    }
}

Options to configure:

• Culture: Default 'en-US' (resource : https://docs.microsoft.com/en-us/openspecs/windows_protocols/ms-lcid/a9eac961-e77d-41a6-90a5-ce1a8b0cdb9c)
• StringConnection: This can be combine optionally with User and Password.
• DetailErrorMessage: Default false, return detail information when errors ocurrs and also parameters values.
• HideSensibleDataValue: Default false, hide sensible data value in error message and log.
• ConnectionTimeout : Default 0, time out for database request.

Perfomance

The benchmark is in project Thomas.Tests.Performance

dotnet run -p .\Thomas.Tests.Performance\ -c Release -f net5.0 -- -f * --join

BenchmarkDotNet=v0.13.0, OS=Windows 10.0.19042.1466 (20H2/October2020Update)
Intel Core i7-8550U CPU 1.80GHz (Kaby Lake R), 1 CPU, 8 logical and 4 physical cores
.NET SDK=5.0.404
  [Host]     : .NET Core 3.1.22 (CoreCLR 4.700.21.56803, CoreFX 4.700.21.57101), X64 RyuJIT
  ShortRun   : .NET Core 3.1.22 (CoreCLR 4.700.21.56803, CoreFX 4.700.21.57101), X64 RyuJIT
  Job-QAXZEQ : .NET Core 3.1.22 (CoreCLR 4.700.21.56803, CoreFX 4.700.21.57101), X64 RyuJIT

Namespace=Thomas.Tests.Performance.Benchmark  Type=ThomasDataAdapterBenckmark