Db Connection

MCMateus Cerqueira

11/18/2023

Good afternoon guys, I need some help setting up the database connection for my project. I have the knowledge to do it in an amateur way, but a few months ago I started a course and I feel that things are evolving, and in this course we haven't gotten to the implementation of the Db in the project, and to test and get ahead I've been trying to figure out the best way to do it. My project is divided into - Application (Services/Dtos/Contracts). - Domain. - Infra (Data/IoC/Contracts). - Presentation (Asp.Net MVC). The big question for me is how I'm going to make the connection and where. I don't intend to use the Entity Framework just yet I'd be grateful if anyone could shed some light on this.

JJP

11/18/2023

What database are you attempting to connect to. Usually there'll be a database provider that handles communication with whatever your db is. e.g. for postgres, it's https://www.npgsql.org/

Aarion

11/18/2023

Expanding on this, some sample code for creating a db connection on this:

// Program.cs
services.AddSingleton<IDbConnectionFactory>(_ => new NpgSqlConnectionFactory(connectionString));

// FactoryClass.cs
public interface IDbConnectionFactory
{
    Task<IDbConnection> CreateConnectionAsync(CancellationToken token = default);
}

internal class NpgSqlConnectionFactory(string connectionString) : IDbConnectionFactory
{
    public async Task<IDbConnection> CreateConnectionAsync(CancellationToken token = default)
    {
        var connection = new NpgsqlConnection(connectionString);
        await connection.OpenAsync(token);
        return connection;
    }
}

// Program.cs
services.AddSingleton<IDbConnectionFactory>(_ => new NpgSqlConnectionFactory(connectionString));

// FactoryClass.cs
public interface IDbConnectionFactory
{
    Task<IDbConnection> CreateConnectionAsync(CancellationToken token = default);
}

internal class NpgSqlConnectionFactory(string connectionString) : IDbConnectionFactory
{
    public async Task<IDbConnection> CreateConnectionAsync(CancellationToken token = default)
    {
        var connection = new NpgsqlConnection(connectionString);
        await connection.OpenAsync(token);
        return connection;
    }
}

The connection string ideally should be securely stored. There's some additional info on exactly how to do that here There are cloud secrets managers like AWS Secrets Manager, there's dotnet user-secrets, there's Environment Variables, the least "secretive" next to hardcoding it would be storing it in appsettings.json (This is generally discouraged) If you're not using Entity Framework you could look into Dapper

Looking for more? Join the community!

Db Connection

Join Server

Db Connection

Join Server

Want results from more Discord servers?

Add your server

Recommended Posts

Can't read property in code behind```cs @page "/weather" @attribute [StreamRendering] <PageTitle>Weather</PageTitle> <h1>Weather</h1 RabbitMQ starting service issuePlease guys I had `RabbitMQ` running fine, but after restarting my computer the RabbitMQ won't be st Exception Unhandled : Could not load file or assembly 'Serilog.Extensions.HostingWhen I run my application, this exception is thrown even before the start of debugging. System.IO.Fi got this code that i wrote the get all score and print end score but i didnt read right help meexem is 40% assigments is 30% and participation is 30%Assistance regarding deciding on what to use.Hello there, I want to port one of my macOS apps to a native windows app and would like to ask which Help deciding Next.js/Node.js vs .NET API back-endHello. I really want to use .NET as my API back-end for a practice app I'm building. However, I do how do i make it so when i press it this happens and if i do it again another thing happensive made a code in winforms so when i press with my left mouse button it hides everything, how do i Can't access object attributes using X.PagedListI have a search field that returns a list of movies. It works fine if I reference the model as @Movi