Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
CoreSpider-EmployeeRepository
public class EmployeeRepository
{
public IDbConnection connection
{
get
{
return new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);
}
}
public async Task<object> GetEmployeeList()
{
object result = null;
try
{
using (IDbConnection con = connection)
{
string Query = "SELECT EmpID, EmpName, Mobile, PresentAddress, Area, City, Country, Qualification, Email" +
" from EmployeeDetails";
con.Open();
DynamicParameters param = new DynamicParameters();
result = await con.QueryAsync<Employee>(Query, param, commandType: CommandType.Text);
}
return result;
}
catch (Exception ex)
{
throw ex;
}
return result;
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.