Click here to Skip to main content
15,881,172 members

Comments by kashifjaat (Top 34 by date)

kashifjaat 13-Dec-16 4:02am View    
I have tried Something Like this.

var t = from a in db.AuctionsSelectedNumbers
where a.AIN_Number == AIN
select new { AucNumber = a.AucNumber, ReservePrice = a.Price, a.BiddingDateTime, a.BiddingPrice, HighestBiddingPrice = (from b in db.AuctionsSelectedNumbers select new { c = (b.BiddingPrice) }).Max(x => x.c).Value.ToString(), HighestAINUMBER = (from b in db.AuctionsSelectedNumbers select new {e=b.AIN_Number,c = (b.BiddingPrice)}).Max(x => x.c).Value.ToString().Select(x=>a.AIN_Number).ToList()};
kashifjaat 13-Dec-16 3:10am View    
How I can make this Query using LINQ in c# Using Entity Frame Work.??

SELECT a.* FROM AuctionsSelectedNumber
JOIN (SELECT AucNumber, MAX(BiddingPrice) AS MaxBP
FROM AuctionsSelectedNumber
GROUP BY AucNumber) b
ON a.AucNumber = b.AucNumber AND a.MaxBP = b.MaxBP
kashifjaat 30-Sep-16 1:45am View    
Oky Dear
kashifjaat 23-Sep-16 0:58am View    
hahhaha... How I can Change now
kashifjaat 22-Sep-16 5:08am View    
Thanks Its Work