How do i find an entity in a Entitycollection based on the PrimaryKey (PK)

This will work - but is it the preferred way to do it ?

Dim FunctionGrp As FunctionGrpEntity
                Dim fg As New FunctionGrpEntity(MyPK)
                Dim fgindex As Integer = FunctionGrpElements.IndexOf(fg)

                If fgindex > -1 Then
                    objFunctionGrp = _department.FunctionGrpElements(fgindex)
                Else
                    'Not available
                End If

... IT

This works and is the prefered way to do it.

Thanks

Hi,

is this still the best and fastest way to do it on big collections?

Thanks a lot, Patrick

You may loop once, store the entities per PK into a hashtable/ dictionary, and then for all subsequential lookups use that hashtable/dictionary

Walaa wrote:

You may loop once, store the entities per PK into a hashtable/ dictionary, and then for all subsequential lookups use that hashtable/dictionary

Maybe one day this get's integrated into LLBLGen so that fast lookup's come out of the box http://www.codeplex.com/i4o

Just a suggestion Thanks, Patrick

As a matter of fact, there's a conversation about that: http://llblgen.com/TinyForum/Messages.aspx?ThreadID=11939