public void GetSites()
{
var siteNames = DataInFile.Select(d => d.Site);
Sites = _repostory.DbContext().Sites.AsQueryable().Where(s => siteNames.Contains(s.Name));
}
public void GetClients()
{
var clientIds = DataInFile.Select(d => d.ClientId);
Clients = _repostory.DbContext().Clients.AsQueryable().Where(c => clientIds.Contains(c.Id));
}