Avoid duplicates in linq based on single column

Question

i have been retrieving data from datatable using linq.i have retrieved the data successully too.the problem is ,i have to show only one record if two records have same projectname (irrespective of which record,but one record must be shown from the dupicate records).

for multiple records with same projectname, only one record from it should be shown.

I have pasted my working code.

cmd.CommandText = " Select PROJECTNAME,COMPANY,PROJECTSTATUS,STARTEDIN,COMPLETEDIN FROM CMPPROJECT WHERE STATUS ='" + a + "'";
            using (OracleDataAdapter sda = new OracleDataAdapter())
            {
                cmd.Connection = con;
                sda.SelectCommand = cmd;
                using (DataTable dt = new DataTable())
                {
                    dt.TableName = "CMPPROJECT";
                    sda.Fill(dt);
                     var select = (from ab in dt.AsEnumerable()
                                   select new { c1 = ab["PROJECTNAME"], c2 = ab["COMPANY"], c3 = ab["PROJECTSTATUS"], c4 = ab["STARTEDIN"], c5 = ab["COMPLETEDIN"] }).Distinct().ToList();
                    dt.Clear();
                    foreach (var item in select)
                 dt.Rows.Add(item.c1, item.c2, item.c3, item.c4, item.c4);
                 return dt;
             }

Please help me with modified working code..

If your code is working, what's the problem then?

Tim Schmelter
– Tim Schmelter

2015-11-11 09:10:02 +00:00
Commented Nov 11, 2015 at 9:10 — Tim Schmelter
– Tim Schmelter, Commented Nov 11, 2015 at 9:10

Tim Schmelter · Accepted Answer · 2015-11-11 09:12:18Z

1

You can use GroupBy:

var projectGroups = dt.AsEnumerable()
    .Select(row => new
    {
        project = row.Field<string>("PROJECTNAME"),
        company = row.Field<string>("COMPANY"),
        status = row.Field<string>("PROJECTSTATUS"),
        startedin = row.Field<DateTime>("STARTEDIN"),    // presumes a DateTime-column
        completedin = row.Field<DateTime>("COMPLETEDIN") // presumes a DateTime-column
    })
    .GroupBy(x => x.project)
    .Select(g => g.First())
    .Distinct()
    .ToList();

answered Nov 11, 2015 at 9:12

Tim Schmelter

462k79 gold badges720 silver badges981 bronze badges

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

Collectives™ on Stack Overflow

Avoid duplicates in linq based on single column

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