private FormattableString CreateQueryWithConditionsForUserApplication(UniversityFilterForUserApplicationInSql filter)
{
string sqlQuery = $@"
SELECT
[Universities].[Id] as Id
, [Universities].[ExternalId] as ExternalId
, [Universities].[IsGoverment] as IsGoverment
, [Universities].[Name] as Name
, [Universities].[RegionId] as RegionId
, [Universities].[ShortName] as ShortName
, [Universities].[AverageMark] as AverageMark
FROM Universities
INNER JOIN (SELECT * FROM Regions
WHERE [Name] IN ({filter.GetFormatNumbersForSqlQuery()})
) as RegionTbl ON RegionTbl.Id = Universities.RegionId
WHERE AverageMark <= {{{filter.ParameterNumberForAvarageMark}}}";
return(FormattableStringFactory.Create(sqlQuery, filter.GetParametersForSql()));
}
public async Task <List <University> > GetAllForUserUniversityBySql(UniversityFilterForUserApplicationInSql filter) => await _currentRepo .FromSqlInterpolated(CreateQueryWithConditionsForUserApplication(filter)) .Include(e => e.Region) .ToListAsync();
