❔ Dapper Unit Of Work

So I'm setting up a simple UnitOfWork with dapper

For that we need to have a scoped Transaction and Connection

    public DapperContext(IConfiguration configuration)
    {
        var connectionString = configuration.GetConnectionString("DefaultConnectionString");
        Connection = new NpgsqlConnection(connectionString);
        Connection.Open();
        Transaction = Connection.BeginTransaction();
    }

    public DapperContext(IConfiguration configuration)
    {
        var connectionString = configuration.GetConnectionString("DefaultConnectionString");
        Connection = new NpgsqlConnection(connectionString);
        Connection.Open();
        Transaction = Connection.BeginTransaction();
    }

we register this as

services.AddScoped<IDapperContext, DapperContext>();

services.AddScoped<IDapperContext, DapperContext>();

I have to open connection with

Connection.Open();

Connection.Open();

before creating a transaction though

My question is how good of an idea is this?

Is there any better way of doing this without blocking?

C#•3y ago•

5 replies

Byte

❔ Dapper Unit Of Work

So I'm setting up a simple UnitOfWork with dapper

For that we need to have a scoped Transaction and Connection

    public DapperContext(IConfiguration configuration)
    {
        var connectionString = configuration.GetConnectionString("DefaultConnectionString");
        Connection = new NpgsqlConnection(connectionString);
        Connection.Open();
        Transaction = Connection.BeginTransaction();
    }

    public DapperContext(IConfiguration configuration)
    {
        var connectionString = configuration.GetConnectionString("DefaultConnectionString");
        Connection = new NpgsqlConnection(connectionString);
        Connection.Open();
        Transaction = Connection.BeginTransaction();
    }

we register this as

services.AddScoped<IDapperContext, DapperContext>();

services.AddScoped<IDapperContext, DapperContext>();

I have to open connection with

Connection.Open();

Connection.Open();

before creating a transaction though

My question is how good of an idea is this?

Is there any better way of doing this without blocking?

❔ Dapper Unit Of Work

Similar Threads

❔ Dapper Unit Of Work

Similar Threads

Similar Threads

Similar Threads