public List <UrlHistoryInfo> GetAllOtherUrls(Webpage webpage) { UrlHistoryInfo urlHistoryInfo = new UrlHistoryInfo(); IList <UrlHistoryInfo> urlHistoryInfoList = _session.QueryOver <UrlHistory>() .SelectList( builder => builder.Select(history => history.UrlSegment) .WithAlias(() => urlHistoryInfo.UrlSegment) .Select(history => history.Webpage.Id) .WithAlias(() => urlHistoryInfo.WebpageId)) .TransformUsing(Transformers.AliasToBean <UrlHistoryInfo>()) .Cacheable() .List <UrlHistoryInfo>(); IList <UrlHistoryInfo> webpageHistoryInfoList = _session.QueryOver <Webpage>() .SelectList( builder => builder.Select(page => page.UrlSegment) .WithAlias(() => urlHistoryInfo.UrlSegment) .Select(page => page.Id) .WithAlias(() => urlHistoryInfo.WebpageId)) .TransformUsing(Transformers.AliasToBean <UrlHistoryInfo>()) .Cacheable() .List <UrlHistoryInfo>(); return(urlHistoryInfoList.Union(webpageHistoryInfoList).Where(info => info.WebpageId != webpage.Id).ToList()); }
public List<UrlHistoryInfo> GetAllOtherUrls(Webpage webpage) { var urlHistoryInfo = new UrlHistoryInfo(); var urlHistoryInfoList = _session.QueryOver<UrlHistory>() .SelectList( builder => builder.Select(history => history.UrlSegment) .WithAlias(() => urlHistoryInfo.UrlSegment) .Select(history => history.Webpage.Id) .WithAlias(() => urlHistoryInfo.WebpageId)) .TransformUsing(Transformers.AliasToBean<UrlHistoryInfo>()) .Cacheable() .List<UrlHistoryInfo>(); var webpageHistoryInfoList = _session.QueryOver<Webpage>() .SelectList( builder => builder.Select(page => page.UrlSegment) .WithAlias(() => urlHistoryInfo.UrlSegment) .Select(page => page.Id) .WithAlias(() => urlHistoryInfo.WebpageId)) .TransformUsing(Transformers.AliasToBean<UrlHistoryInfo>()) .Cacheable() .List<UrlHistoryInfo>(); return urlHistoryInfoList.Union(webpageHistoryInfoList).Where(info => info.WebpageId != webpage.Id).ToList(); }