public IEnumerable <T> ExecuteQuery <T>(string storeName, BaseDynamicParameters parameters) where T : class
{
try
{
using (var connection = GetConnection())
{
IEnumerable <T> result = SqlMapper.Query <T>(connection, storeName, parameters, commandType: CommandType.StoredProcedure);
return(result);
}
}
catch (Exception ex)
{
LogManager.LogError("Execute Query", ex);
return(new List <T>());
}
}
public bool ExecuteNoneQuery(string storeName, BaseDynamicParameters parameters)
{
try
{
using (var connection = GetConnection())
{
SqlMapper.Execute(connection, storeName, param: parameters, commandType: CommandType.StoredProcedure);
return(true);
}
}
catch (Exception ex)
{
LogManager.LogError("Execute None Query", ex);
return(false);
}
}
