tag:blogger.com,1999:blog-7130587409577087282.post3630253254707080120..comments2024-03-15T23:24:50.847+11:00Comments on David Klein's Corner: Issues with LINQ Order By Queries when using DistinctDavid Kleinhttp://www.blogger.com/profile/13657389334766989234noreply@blogger.comBlogger5125tag:blogger.com,1999:blog-7130587409577087282.post-40296369797169386472012-08-16T00:42:43.202+10:002012-08-16T00:42:43.202+10:00Thanks. Found this helpful.Thanks. Found this helpful.Michael Avinashhttps://www.blogger.com/profile/10934849176653299448noreply@blogger.comtag:blogger.com,1999:blog-7130587409577087282.post-51836002582526253862009-02-18T12:20:00.000+11:002009-02-18T12:20:00.000+11:00Ah! Now I get it, thanks :) Learning that I could ...Ah! Now I get it, thanks :) Learning that I could dump my generated SQL query as a string from my var variable to see how LINQ converts to SQL was a key step for me too :)Anonymoushttps://www.blogger.com/profile/04612149239613655969noreply@blogger.comtag:blogger.com,1999:blog-7130587409577087282.post-17202659736437250712009-02-18T07:22:00.000+11:002009-02-18T07:22:00.000+11:00It's actually the order that counts, not whether o...It's actually the order that counts, not whether or not it's a Lambda:<BR/><BR/>http://programminglinq.com/blogs/marcorusso/archive/2008/07/20/use-of-distinct-and-orderby-in-linq.aspxJason Younghttps://www.blogger.com/profile/13544562404044466305noreply@blogger.comtag:blogger.com,1999:blog-7130587409577087282.post-20689225585032003452009-02-17T14:28:00.000+11:002009-02-17T14:28:00.000+11:00This was extremely helpful, thank you!! The Lambda...This was extremely helpful, thank you!! The Lambda trick worked. In my case the problem was partially hidden by a .Skip(x) function that apparently forces an ORDER BY to be inserted into the SQL query, but the ORDER BY clause isn't inserted if x == 0, so only my very first result was wrong.Anonymoushttps://www.blogger.com/profile/04612149239613655969noreply@blogger.comtag:blogger.com,1999:blog-7130587409577087282.post-13960978542485638192008-03-05T22:04:00.000+11:002008-03-05T22:04:00.000+11:00I just stumpled over the same issue - do you have ...I just stumpled over the same issue - do you have any idea why LINQ to SQL handles it that way?saxxhttps://www.blogger.com/profile/07621472492479330346noreply@blogger.com