32 lines
908 B
C#
32 lines
908 B
C#
using Dapper;
|
|
using Microsoft.Extensions.Configuration;
|
|
using System;
|
|
using System.Collections.Generic;
|
|
using System.Data;
|
|
using System.Data.SqlClient;
|
|
using System.Linq;
|
|
using System.Text;
|
|
using System.Threading.Tasks;
|
|
|
|
namespace EmployeeLibrary.Data;
|
|
|
|
public class SqlDataAccess : ISqlDataAccess
|
|
{
|
|
private readonly IConfiguration _config;
|
|
|
|
public SqlDataAccess(IConfiguration config)
|
|
{
|
|
_config = config;
|
|
}
|
|
|
|
public async Task<List<T>> LoadDataAsync<T, U>(string sql,
|
|
U parameters,
|
|
string connectionStringName = "Default")
|
|
{
|
|
|
|
using IDbConnection connection = new SqlConnection(_config.GetConnectionString(connectionStringName));
|
|
var rows = await connection.QueryAsync<T>(sql, parameters, commandType: CommandType.StoredProcedure);
|
|
return rows.ToList();
|
|
}
|
|
}
|