Gurgaon Is usually a property hotspot with properties starting from very affordable housing to luxury apartments. ArindamArindam 17611 silver badge55 bronze badges one Did you imply to Select() new Person rather than new Player? The reality that you are ordering by ID doesn't somehow notify Unique() to employ that property https://propertyingurugram.in/real-estate-developers-pushing-shop-cum-office-plots-as-another-stream-for-monetisation/