public IEnumerable <Office> GetOffices(string searchPattern)
// to avoid additional allocations
=> context.Query <Office>($@"select * from Offices where lower(Address) like lower('%{searchPattern}%')");
public IEnumerable <Office> GetOffices(string searchPattern)
// to avoid additional allocations
=> context.Query <Office>($@"select * from Offices where lower(Address) like lower('%{searchPattern}%')");