CODEWITHSUNDEEP
c#distinct
bflydesign
bflydesign

Reputation: 483

get unique values from query to build Dictionary

I want to build a combobox with key->postal and value->city to use as filter for my accomodations.

To limit the number of items in the list I only use the postals I have used when filling up the table tblAccomodations. For now I do not use a relational table with postals and city's although I'm thinking about an update later on.

Here I build my dictionary:

public static Dictionary<int, string> getPostals()
{
    Dictionary<int, string> oPostals = new Dictionary<int, string>();

    using (DBReservationDataContext oReservation = new DBReservationDataContext())
    {
        var oAllPostals = (from oAccomodation in oReservation.tblAccomodations
                            orderby oAccomodation.Name ascending
                            select oAccomodation);

        foreach (tblAccomodation item in oAllPostals)
        {
            oPostals.Add(int.Parse(item.Postal), item.City);
        }
    }
    return oPostals;
}

As expected I got an error: some Accomodations are located in the same city, so there are double values for the key. So how can I get a list of unique cities and postals (as key)? I tried to use

select oAccomodation.Postal.Distinct()

but that didn't work either.

UPDATE: I have found the main problem. There are multiple cities with the same postal ("Subcity"). So I'm gonna filter on "City" and not on "Postal".

Upvotes: 1

Views: 877

Answers (5)

Tats_innit
Tats_innit

Reputation: 34107

Using .containkey will exclude [1 (postal key) to n (cities relation)]. i.e since Key already exists next city (with the same postal key ) will not get into your dictionary.

However, if you want to map your postal to list of cities, you can represent a dictionary that can contain a collection of values like the following:

Dictionary < String[Postal]> , List < Cities>>

This way you'll have a dictionary that can have multiple values.

Upvotes: 1

Roland Mai
Roland Mai

Reputation: 31077

Assuming the combination of postal + city is unique you could do the following:

public static Dictionary<int, string> getPostals()
{
    Dictionary<int, string> oPostals = new Dictionary<int, string>();

    using (DBReservationDataContext oReservation = new DBReservationDataContext())
    {
        var oAllPostals = (from oAccomodation in oReservation.tblAccomodations
                            orderby oAccomodation.Name ascending
                            select oAccomodation);

        foreach (tblAccomodation item in oAllPostals)
        {
            oPostals.Add((item.Postal + item.City).GetHashCode(), item.Postal + " " + item.City);
        }
    }
    return oPostals;
}

Edit:

If you want to use the selected value from the drop box then you can use the following:

public static Dictionary<int, Tuple<string, string>> getPostals()
{
    Dictionary<int, string> oPostals = new Dictionary<int, string>();

    using (DBReservationDataContext oReservation = new DBReservationDataContext())
    {
        var oAllPostals = (from oAccomodation in oReservation.tblAccomodations
                            orderby oAccomodation.Name ascending
                            select oAccomodation);

        foreach (tblAccomodation item in oAllPostals)
        {
            oPostals.Add((item.Postal + item.City).GetHashCode(), new Tuple<string, string>(item.Postal, item.City));
        }
    }
    return oPostals;
}

The way you bind the following depends on whether you're using asp.net, winforms etc. Here's an example for winforms.

Upvotes: 1

Rob Smyth
Rob Smyth

Reputation: 1858

I think your looking for 'Distinct'. Gather your list of all postals and then return myPostals.Distinct().

Hope than helps.

Upvotes: 1

Alexey Raga
Alexey Raga

Reputation: 7525

BTW, if you have multiple cities in one postal (I am not sure if it is possible in your domain), which one you want to see?

If any of cities will do, then it is easy to just get the first one per postal:

var oAllPostals = oReservation.tblAccomodations
                      .OrderBy(x=>x.Name)
                      .ToLookup(x=>x.Postal, x=>x.City)
                      .ToDictionary(x=>x.Key, x.First());

In the same example if you do .ToList() or even .Distinct().ToList() instead of .First() you will have all of cities in the dictionary of Dictionary<Postal, List<City>>.

Upvotes: 1

Jonathan D
Jonathan D

Reputation: 1364

change 

foreach (tblAccomodation item in oAllPostals)
        {
            oPostals.Add(int.Parse(item.Postal), item.City);
        }

to

    foreach (tblAccomodation item in oAllPostals.Distinct(x=>x..Postal)
             { 
if(!oPostals.ContainsKey(int.Parse(item.Postal)))
                 oPostals.Add(int.Parse(item.Postal), item.City);
             }

Upvotes: 1

Related Questions