hey!
thanks for your help
i will use stored procedures in the second phase of the project (thanks for the tip)
I found out the LINQ statement that is working fine for the moment:
Dim amenityGroupIDs As String = "1,4,6"
Dim GroupAmenityList As New List(Of String)
Dim TempGroupAmenities() As String = amenityGroupIDs.Split(",")
For Each GroupAm As String In TempGroupAmenities
GroupAmenityList.Add(GroupAm)
Next
Dim FilterHotelsPriceStarsRatingAmenities = (From hal In _db.EANHotelsAttributeLink Join ha In _db.EANHotelsAttribute On hal.AttributeID Equals ha.AttributeID Join eh In _db.EANHotels On hal.EANHotelID Equals eh.EANHotelID Where GroupAmenityList.Contains(ha.GroupAmenityID) And eh.RegionID = 1385 Group hal By hal.EANHotelID Into myGroup = Group Where myGroup.Count = GroupAmenityList.Count Select myGroup.FirstOrDefault).ToList
For Each Hotel In FilterHotelsPriceStarsRatingAmenities
ViewBag.Test1 &= Hotel.EANHotelID
Next
Cheers