none
query two collections RRS feed

  • Question

  • I have two collections of AttributeMethodAttribute. one from SQL the other from memory.

    Now i want to find which attributemethodattributes have their selected property set to true.

    both collection may have 0-many selected attributemethodAttribute

    oh and if memory collection has selected attributemethodttribute, i want the corresponding item from SQL collection. so SQL collection is the exhaustive list.

     

    Psuedo code like this.

     

       Dim b = From db As AttributeMethodAttribute In Sql
        Group Join local As AttributeMethodAttribute In Memory _
        On db.BillOfMaterialID Equals local.BillOfMaterialID _
        Into Wanted = Group Where (db.Selected And db.ComponentState = AttributeMethodAttribute.eComponentState.Original And Local Is Nothing) _
        Or (Local.Selected)
        Select db
    

     

     


    Tuesday, August 30, 2011 3:40 PM

All replies

  • Hey guy, what 's your meaning? IMHO, i didn't very understand your meaning. did you mind dscribing again?

    Thanks,

    Werewolf,


    Just a newbie for everything.
    Thursday, September 1, 2011 8:49 AM