CODEWITHSUNDEEP
c#sqlasp.net-mvcentity-frameworklinq
user7995126
user7995126

Reputation: 1

Query SQL to Linq

How do I convert this query into LINQ

SELECT Hotels.NameHotel AS 'Hotel', (SUM(Hotels.HotelID)/Hotels.HotelID) AS 'quantity' FROM ReservedRooms
INNER JOIN Rooms ON ReservedRooms.RoomID = Rooms.RoomID
INNER JOIN Hotels ON Rooms.HotelID = Hotels.HotelID
GROUP BY Hotels.NameHotel, Hotels.HotelID

To be more specific what I can not do is do the GROUP and SUM in the Select

Upvotes: 0

Views: 103

Answers (1)

Arsalan Qaiser
Arsalan Qaiser

Reputation: 457

        var result = from rr in db.ReservedRooms
        join r in db.Rooms on rr.RoomID equal r.RoomID
        join h in db.Hotels on r.HotelID equal h.HotelID
        group by h by new {h.NameHotel, h.HotelID} into g
        select new 
        {
                Hotel = h.NameHotel,
                quantity = (g.Sum(SUM(h.HotelID))/h.HotelID)
        }

Upvotes: 2

Related Questions