How do i use distinct? RSS

• • Reply
  

  anderson7777

  Member

  141 Points

  280 Posts

  How do i use distinct?

  Jan 08, 2013 12:58 AM|LINK

  I have code like this:

  var GenreQry = from d in db.Movies
  orderby d.Genre
  select d.Genre;

  I tried select d.Genre.Distinct but it doesnt work

  How can i make it work?

  thx

  
  Adilson

• • Reply
  

  pro.shailend...

  Participant

  1042 Points

  190 Posts

  Re: How do i use distinct?

  Jan 08, 2013 03:17 AM|LINK

  Try this.

  var GenreQry = (from d in db.Movies
  orderby d.Genre
  select d.Genre).Distinct();

  .Net Professional & Cosultant
  Blog: Dot Net Tricks Windows Apps
  Please "Mark As Answer" if my suggestions helps you
  • Edited by anderson7777 on Jan 08, 2013 04:23 AM
  • Edited by decker dong - msft on Jan 10, 2013 12:57 AM
  • Edited by decker dong - msft on Jan 10, 2013 12:57 AM
  • Edited by decker dong - msft on Jan 14, 2013 05:44 AM
  • Marked as answer by decker dong - msft on Jan 14, 2013 05:44 AM
• • Reply
  

  Nick Asiimwe

  Participant

  1459 Points

  643 Posts

  Re: How do i use distinct?

  Jan 08, 2013 03:17 AM|LINK

  http://stackoverflow.com/questions/5035048/linq-to-entities-distinct-clause

  http://stackoverflow.com/questions/8473705/linq-to-entities-distinct-on-one-column

  --------------------------------------------------
  Sincerely,
  Nick
  
  ASP.NET, SQL Server [Database Engine, SSIS & SSRS],Entity Framework, C# and VB.NET