Data is Repeated. i.e if India is there in location then 3 times it is printed. Want only 1 time.

Question

0.00/5 (No votes)

See more:

var prpty = from pm in rdc.tbl_PropertyMasters
join pt in rdc.tbl_PropertyTypes on pm.PropertyTypeId equals pt.PropertyTypeId
join loc in rdc.tbl_Locations on pm.LocationId equals loc.LocationId
join city in rdc.tbl_Cities on pm.CityId equals city.CityId
select new
{
    pt.PropertyType,
    loc.LocationName,
    city.CityName,
}

Posted 26-Apr-11 0:45am

Vineet_2109

Updated 26-Apr-11 1:10am

v3

Add a Solution

Comments

LittleYellowBird 26-Apr-11 6:49am

Hi, I think you need to improve your question. Explain exactly what you are having trouble with, what data is repeated? What do you mean by uniques data? Also, put your code in a 'code block'. That way you will get more helpfull replies and more quickly. Just a suggestion. Ali :)

4 solutions

Solution 2

If you mean you don't want duplicate rows of data in your result set, you probably need to add 'distinct' or '.Distinct()'.

Posted 26-Apr-11 0:57am

NuttingCDEF

Solution 3

Hi Vineet_2109,

Be sure that the 3 selected items will be the same and use the answer of nit_singh

Good luck,
:)

Posted 26-Apr-11 0:59am

Michael Waguih

Solution 4

also, alternate solution:

List<list><string>> Records = GetRecords();
//
List<list><string> UniqueRecords = Records
  .GroupBy(r => r[0])
  .Where(g => !g.Skip(1).Any())
  .Select(g => g.Single())
  .ToList();
</string></list></string></list>

Posted 26-Apr-11 4:16am

Ravi Sant

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

nit_singh · Accepted Answer · 2011-04-26T00:54:00

As i think it would work. Just use Distinct().

var prpty = (from pm in rdc.tbl_PropertyMasters
                                    join pt in rdc.tbl_PropertyTypes on pm.PropertyTypeId equals                                    pt.PropertyTypeId
                                    join loc in rdc.tbl_Locations on pm.LocationId equals loc.LocationId
                                    join city in rdc.tbl_Cities on pm.CityId equals city.CityId
                                    select new
                                    {
                                          pt.PropertyType,
                                          loc.LocationName,
                                          city.CityName,
                                    }).Distinct();