bstrapper.cs

protected override void ConfigureApplicationContainer(TinyIoCContainer container)
  {
      //base.ConfigureApplicationContainer(container); //Prevent assembly scanning
      container.Register<IDbConnectionProvider, PostgresConnectionProvider>();
  }

IDbConnectionProvider.cs

public interface IDbConnectionProvider
    {
       IDbConnection GetConnection();
    }

pgprovider.cs

public class PostgresConnectionProvider : IDbConnectionProvider
    {
        private readonly string connectionString;

        public PostgresConnectionProvider()
        {
            this.connectionString = ConfigurationManager.ConnectionStrings["blah"].ConnectionString;
        }
        public IDbConnection GetConnection()
        {
            var connection = new NpgsqlConnection(this.connectionString);
            connection.Open();
            return connection;
        }
    }

repo.cs

        public UserRepository(IDbConnectionProvider dbConnectionProvider)
        {
            this.dbConnectionProvider = dbConnectionProvider;

        }

        public VQUser GetVQuser(int id)
        {
            using (var dbConnection = this.dbConnectionProvider.GetConnection())
            {
                return dbConnection.Query<User>(
                    UserSql + " where u.id = @id",
                    new { id = id }).FirstOrDefault();
            }
        }