Quickly Implement Dapper Injection

Create a static class to inject Dapper services.

    /// <summary>
    /// Inject Dapper
    /// </summary>
    public static class DapperService
    {
        /// <summary>
        /// Inject Dapper
        /// </summary>
        public static IServiceCollection AddDapperContext(this IServiceCollection services, string connectStr)
        {
            services.AddTransient<IDbConnection, SqliteConnection>(context =>
            {
                return new SqliteConnection(connectStr);
            });
            return services;
        }
    }

In the Startup.ConfigureServices method, add

          services.AddDapperContext($"filename=./Test.db");

Usage example

  public class TestController : ControllerBase
    {
        private readonly IDbConnection _dapperContext;

        /// <summary>
        /// Constructor
        /// </summary>
        /// <param name="dapperCon"></param>
        public TestController(IDbConnection dapperCon)
        {
            _dapperContext = dapperCon;
        }