How do I filter out duplicate rows

Question

0.00/5 (No votes)

See more:

Hi -

I am using entity framework linq query to retrieve my data. Problem is I am getting duplicate rows of invoice number. How do I eliminate the duplicate rows.
Invoice Number is duplicating for invoices that have multiple invoice items.

Here is my query

C#

result = (from invoice in invoices
          join invoiceItem in invItems on invoice.Id equals invoiceItem.InvoiceId
          orderby invoice.InvoiceNo
          select new InvoiceReceiveShipmentVM
          {
              dtInvoiced = invoice.dtInvoiced,
              InvoiceNumber = invoice.InvoiceNo,
              InvoiceType = invoice.InvoiceType,
              InvoiceStatus = invoice.InvoiceStatus,
              Lines = invoiceItem.Line,
              Total = invoice.Total,
              Carrier = invoice.Carrier,
          });
return result.Distinct().AsQueryable();

What I have tried:

I've tried result.Distinct().ToList() and I've been looking through at this link to find something http://linq101.nilzorblog.com/linq101-lambda.php

Posted 23-Jun-16 10:15am

Troy Bryant

Updated 23-Jun-16 15:54pm

Add a Solution

Comments

Ehsan Sajjad 23-Jun-16 16:40pm

that is the expected behaviour you have multiple items against a invoice number, you need to write logic at front end for displaying it one time may be grouping them

Maciej Los 23-Jun-16 17:39pm

Well, imagine that: there's one invoice with these properties: ID - 5, No.: 5; and second one: ID - 6, No.: 5. Are they equal?

Beginner Luck 23-Jun-16 21:38pm

you want to Distinct by which column

Troy Bryant 23-Jun-16 21:45pm

InvoiceNumber

Beginner Luck 23-Jun-16 21:55pm

I not sure is this wat you need

Karthik_Mahalingam 23-Jun-16 23:47pm

if you have multiple invoice item then which one do u want to ignore.
for example:
Invoice no is 1
invoiceItem is having 3 items with same invoice id [1 .. some value ][1 ... some value ] [ 1 .. some value ]
in this case you will get 3 records this is how join works, so coming to your distinct issue, which one you want to consider/ignore in these 3 items.

Troy Bryant 24-Jun-16 8:41am

In this case if the invoice number is the same the first one should be displayed any other invoices with duplicate numbers should be ingnored

1 solution

Add a Solution

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

Beginner Luck · Accepted Answer · 2016-06-23T15:54:00

Solution 1

C#

public static IEnumerable DistinctBy(this IEnumerable list, Func<t, object> propertySelector)

{

   return list.GroupBy(propertySelector).Select(x => x.First());

}

Try this useful extension

from this website
LINQ DistinctBy - With Lambda Expression Parameter - Eleven Winds[^]

Posted 23-Jun-16 15:54pm

Beginner Luck

Comments

Maciej Los 7-Jul-16 2:29am

Nice! A5!

How do I filter out duplicate rows

1 solution

Solution 1

Add your solution here

Preview 0

How do I filter out duplicate rows

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us