public T ReadFirst <T>(string query, object queryParams, string connectionString)
{
using (IDbConnection connection = new SqlConnection(connectionString))
{
if (connection.State != ConnectionState.Open)
{
connection.Open();
}
return(connection.QueryFirst <T>(query, queryParams));
}
}
public T ReadFirstSP <T>(string query, object queryParams, string connectionString)
{
using (IDbConnection connection = new SqlConnection(connectionString))
{
if (connection.State != ConnectionState.Open)
{
connection.Open();
}
return(connection.QueryFirst <T>(query, queryParams, commandType: CommandType.StoredProcedure));
}
}