Re: [NH] QueryOver i distinct

Article View: alt.pl.comp.lang.csharp

Article #21852

Back to alt.pl.comp.lang.csharp Previous Next

#21852

From: Łukasz 'Maly' Ostrowski
Date: Wed, 01 Dec 2010 09:40

28 lines
1509 bytes

On Wed, 1 Dec 2010 00:33:53 -0800 (PST), Macko wrote:
> <sql>
> 
> select distinct id_filmu from filmy_na_plycie
> 
> </sql>
> 
> Teraz jak za pomocą .QueryOver zrobić to samo?
> 
> To niżej zadziała, ale nie poda listy unikalnych identyfikatorów:
> 
> var moviesOnCDs =
>     QueryOver.Of<FilmyNaPlycie>()
>             .Select(fnp => fnp.Film.id);

Nie mam teraz za bardzo czasu, ale wstępnie bym kombinował
dookoła:

QueryOver<FilmyNaPlycie>()
  .Select(
    Projections.Distinct(
      Projections.Property<FilmyNaPlycie>(fnp => fnp.Film)));

Ale bez sprawdzenia nie daję głowy.

-- 
Pozdrawiam,
Łukasz 'Maly' Ostrowski.      http://l3v.eu/

Technical Details

Message-ID: <9pudeanfk8hj$.1ipmya1k3869o$.dlg@40tude.net>

Path: mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!news.gazeta.pl!newsfeed.pionier.net.pl!news.dialog.net.pl!not-for-mail

References: <c4f37da9-ac9a-46e8-9a15-aa7f952f8c1e@p7g2000prb.googlegroups.com>

Show Full Headers

Complete Article Headers

Path: mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!news.gazeta.pl!newsfeed.pionier.net.pl!news.dialog.net.pl!not-for-mail
From: Łukasz 'Maly' Ostrowski <maly@USUNnemo.pl>
Newsgroups: alt.pl.comp.lang.csharp
Subject: Re: [NH] QueryOver i distinct
Date: Wed, 1 Dec 2010 10:40:41 +0100
Organization: Acme
Lines: 28
Message-ID: <9pudeanfk8hj$.1ipmya1k3869o$.dlg@40tude.net>
References: <c4f37da9-ac9a-46e8-9a15-aa7f952f8c1e@p7g2000prb.googlegroups.com>
NNTP-Posting-Host: static-78-9-71-129.ssp.dialog.net.pl
Mime-Version: 1.0
X-Trace: news.dialog.net.pl 1291196441 10695 78.9.71.129 (1 Dec 2010 09:40:41 GMT)
X-Complaints-To: abuse@dialog.net.pl
NNTP-Posting-Date: Wed, 1 Dec 2010 09:40:41 +0000 (UTC)
User-Agent: 40tude_Dialog/2.0.15.1
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit

Reply to Parent Message