public async Task <CompanyList> Get(CompanyList companyList)
{
StringBuilder query = new StringBuilder();
Dictionary <string, object> queryParams = new Dictionary <string, object>();
List <string> whereParams = new List <string>();
query.Append(sqlQueryBase);
var connection = _session.Connection;
var list = await connection.QueryAsync <Company>(query.ToString());
companyList.AddList(list.AsList());
return(companyList);
}
