public async Task <PagedResult <ManagerListDTO> > GetManagerByCustomerId2(QueryParameters queryParameter) { string natFieldName = StaticDataHelper.GetNationalityFieldName(queryParameter.Lang); string query1 = $@"(SELECT ManagerId, CustomerId, FirstName + ' ' + FatherName + ' ' + GrandName as FullName, FirstNameEng + ' ' + FatherNameEng + ' ' + GrandNameEng as FullNameEng, Gender, 'Nationality' = (SELECT {natFieldName} FROM dbo.[Lookup] WHERE LookupId = M.Nationality) FROM [dbo].[Manager] M)"; IEnumerable <ManagerListDTO> query = await context.ManagerListDTO .Where(m => m.CustomerId == queryParameter.CustomerId) .FromSql(query1) .Paging(queryParameter.PageCount, queryParameter.PageNumber) .ToListAsync(); return(new PagedResult <ManagerListDTO>() { Items = query, ItemsCount = context.Manager.Count() }); }