public IEnumerable <T> Query <T>(string sql, object param = null)
 {
     using (var connection = new PgSqlConnection(_connectionString))
     {
         connection.Open();
         var records = connection.Query <T>(sql, param);
         return(records);
     }
 }