Using distinct on a column while getting multiple column data

Question

My Database Table structure:

Schema  Property  Type

For different 'Schema' values I have same 'Property' and 'Type' values.

My linq query:

IEnumerable<CModel> model = db.dbModels.AsEnumerable().Select(o => new CModel { CName = "XXX", PName = o.Property, PType = o.Type }).Distinct().ToList();

What I'm trying to do is get distinct 'Property' and 'Type' values but the query is giving me duplicate values.

Thanks

What are the date types of Property and Type? If they are simple types like string or int this query should produce distinct results. And what's the use of this AsEnumerable()? — Gert Arnold
– Gert Arnold, Commented Oct 23, 2014 at 6:51
@GertArnold data types are string, Removing ASEnumerable solved the problem..Thanks — Arnab
– Arnab, Commented Oct 23, 2014 at 7:05

Ehsan Sajjad · Accepted Answer · 2014-10-23 06:37:12Z

1

You can group them:

IEnumerable<CModel> model = db.dbModels.AsEnumerable()
                            .GroupBy(x => new { x.Property, x.Type })
                            .Select(x => new CModel 
                                        { CName = "XXX", 
                                          PName = x.Property, 
                                          PType = x.Type }).ToList();

answered Oct 23, 2014 at 6:37

Ehsan Sajjad

62.6k16 gold badges112 silver badges171 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Using distinct on a column while getting multiple column data

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related