Thursday, 26 May 2011

Perform "Where In" Query Entity Framework

SELECT * FROM TBL_TargetLinks WHERE FkTargetID IN (1,2,3)
EQUALS
Public Function GetOutputTargetLinksByIDList(ListOfIDs As List(Of Integer)) As IQueryable(Of OutputTargetLink)
        Dim TargetLinks = From T In Me.GetOutputTargetLinks                            Where ListOfIDs.Contains(T.FKTargetID)                            Select T
        Return Me.ObjectContext.OutputTargetLinks
End Function


Thanks To Dan Wahlin

No comments:

Post a Comment