我有此linq to sql查询,我想将linq转换为实体
Dim db As New DataClasses1DataContext()
Dim bedspace = (From bed In db.Beds Where SqlMethods.Like(bed.BedName,"ward%")
Select Convert.ToInt32(bed.BedName.Substring(4))).ToList()
If bedspace.Count <> 0 Then
txtProvisonalDiagnosis.Text = bedspace.Max
Else
txtProvisonalDiagnosis.Text = "try again"
End If
该查询有效,但是当尝试使用这样的实体实施相同的操作时
Dim bedspace = From bed In HMS.Beds Where bed.BedName.Contains("ward")
Select Convert.ToInt32(bed.BedName.Substring(4).ToString)
If bedspace.Count <> 0 Then
txtProvisonalDiagnosis.Text = bedspace.Max
Else
txtProvisonalDiagnosis.Text = "am still a sucker"
End If
编译器抱怨LINQ to Entities无法识别方法'Int32。ToInt32(System.String)'方法,并且该方法不能转换为商店表达式。请帮帮我。
尝试这样的事情,我附近没有编译器,但这不能遥不可及
Dim bedspace as generic.list(of integer) = (From bed In HMS.Beds Where bed.BedName.Contains("ward")
Select bed.BedName.Substring(4).ToString).tolist
If bedspace.Count <> 0 Then
txtProvisonalDiagnosis.Text = bedspace.Max
Else
txtProvisonalDiagnosis.Text = "am still a sucker"
End If
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句