对LINQ实体的SQL查询 [英] sql query to LINQ entities

问题描述

嘿！



希望有人能帮助我将sql查询转移到vb.net中的LINQ：



SQL：

  SELECT   DISTINCT  hal.EANHotelID 
  FROM  EANHotelsAttributeLink  AS  hal  INNER   JOIN  
 EANHotelsAttribute  AS  ha  ON  hal.AttributeID = ha.AttributeID  INNER   JOIN  
 EANHotels  AS  eh  ON  hal.EANHotelID = eh.EANHotelID 
  WHERE （ha.GroupAmenityID  IN （ 1 ， 4 ， 6 ）） AND （eh.RegionID = '  1385'）
  GROUP   BY  hal.EANHotelID 
  HAVING （COUNT（hal.EANHotelID）=  3 ）

感谢预付款

干杯

解决方案

嘿！



感谢您的帮助

i将在项目的第二阶段使用存储过程（谢谢提示）



我发现LINQ语句暂时正常工作：

  Dim  amenityGroupIDs 作为 字符串 =   1,4,6 
  Dim  GroupAmenityList 作为 新列表（ Of   String ）
 
  Dim  TempGroupAmenities（） As   String  = amenityGroupIDs.Split（ ，）
 对于 每个 GroupAm 作为 字符串 在 TempGroupAmenities 
 GroupAmenityList.Add（GroupAm）
  Next  
 
  Dim  FilterHotelsPriceStarsRatingAmenities = （来自hal 在 _db.EANHotelsAttributeLink中加入ha 在 _db.EANHotelsAttribute 开 hal.AttributeID等于ha.AttributeID加入eh 在 _db.EANHotels 开启 hal.EANHotelID Equals eh.EANHotelID Where GroupAmenityList.Contains（ha.GroupAmenityID）和 eh.RegionID =  1385 组hal由hal.EANHotelID转入myGroup = Group其中myGroup.Count = GroupAmenityList.Count 选择 myGroup.FirstOrDefault）.ToList 
 
 对于 每个酒店在 FilterHotelsPriceStarsRatingAmenities 
 ViewBag。 Test1& = Hotel.EANHotelID 
 下一页 

干杯

Hey!

Hopefully, someone of you can help me to transfer a sql query to LINQ in vb.net:

SQL:

SELECT DISTINCT hal.EANHotelID
FROM            EANHotelsAttributeLink AS hal INNER JOIN
                         EANHotelsAttribute AS ha ON hal.AttributeID = ha.AttributeID INNER JOIN
                         EANHotels AS eh ON hal.EANHotelID = eh.EANHotelID
WHERE        (ha.GroupAmenityID IN (1, 4, 6)) AND (eh.RegionID = '1385')
GROUP BY hal.EANHotelID
HAVING        (COUNT(hal.EANHotelID) = 3)

thanks an advance
Cheers

解决方案

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

这篇关于对LINQ实体的SQL查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！