_ChoaSG30_
New Member
I have the following query that I would like to convert to LINQ to SQL (c#) but am getting stuck.\[code\]select title, barcode, count (*) as pop_rankfrom favouritesgroup by barcode, titleorder by pop_rank desc\[/code\]I got as far as\[code\]DataContext db = new DataContext();using (db){var test = from t in db.favourites group t by new { t.barcode, t.title };}\[/code\]I'm struggling with adding the count and order by functions.Thanks