how to get particular column distinct in linq to sql
- by kart
Hi All,
Am having columns as category and songs in my table for each category there are almost 10 songs and in total there are 7 category such that which was tabled as
category1 songCategory1a
category1 songCategory1b
category1 songCategory1c
---
category2 songCategory2a
category2 songCategory2b
category2 songCategory2c
---
category3 songCategory3a
category3 songCategory3b
category3 songCategory3c
---
like that there is table in that i want to get the result as
category1
category2
category3
category4
kindly any one help me ,
i tried
(from s in _context.db_songs
select new { s.Song_Name, s.Song_Category }).Distinct().ToList(); but it didnt work its resulting as such.