CODEWITHSUNDEEP
sqllinqentity-framework
filipst
filipst

Reputation: 1573

entity framework distinct by field

i have table kopija that goes like this:
idKopija | idFilm | nije_tu
1 | 1 | 0
2 | 1 | 0
3 | 1 | 1
4 | 2 | 1 and etc.

And i have query that goes like this: 

var upit = from f in baza.films
join z in baza.zanrs on f.idZanr equals z.idZanr
join k in baza.kopijas on f.idFilm equals k.idFilm
select new
{
                           idFilm = f.idFilm,
                           nazivFilm = f.naziv,
                           nazivZanr = z.naziv,
                           idZanr = f.idZanr,
                           godina = f.godina,
                           slika = f.slika,
                           klip = f.klip,
                           nijeTu = k.nije_tu
                       };
if (checkBox1.Checked)
                upit = upit.Where(k => k.nijeTu == 0).Distinct();
            else
            {
                upit = upit.Where(k => k.nijeTu == 0 || k.nijeTu == 1).Distinct();
            }

Now i want to make a distinct list of "idFilm". But prolem is that I get idFilm on two places because one of them has nije_tu=0 and other one has nije_tu=1.
Please someone help me.
Thank you.

Upvotes: 2

Views: 2656

Answers (1)

niklascp
niklascp

Reputation: 836

What about 

upit.Where(k => k.nijeTu == 0 || k.nijeTu == 1).Select(x => x.idFilm).Distinct();

?

Upvotes: 5

Related Questions