Friday, March 9, 2012

LINQ Query for Find Duplicates

var d = from r in dbc.tbl_countries
group r.country_name by r.country_name into country
where country.Count() > 1
select new
{
countryname = country.Key
};

string strCount;

foreach (var f in d)
{
strCount = f.countryname;
}