var Duplicatenumber = from a in Listnum join b in serialmaster on a.ID equals b.list_Id select new { Line = a.LineNumber, SAPLine = a.SAPLine, Code= a.Code, Description = a.Description, Number = b.number, NumberID = b.NumberID, CodeID = a.ID }; // Code Change for eliminate the empty values var ExactDuplicate = from a in Duplicatenumber where !string.IsNullOrWhiteSpace(a.Number) group a by new { a.Number } into g where g.Count() > 1 select new { g.Key.Number };
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)