none
Selecting those rows/objects NOT in the join RRS feed

  • Question

  • Guys

     

    daft questiion but I am struggling. 

     

    I can get all my chemicalidentitys using GetTable<>.  I can get all my chemicalidentitys associated with a sample using

     

    var query =

    from chemicalidentity in samplesDC.ChemicalIdentities

    join sample_chemicalIdentity in samplesDC.Sample_ChemicalIdentities on chemicalidentity.id equals sample_chemicalIdentity.chemicalIdentityId

    join sample in samplesDC.Samples on sample_chemicalIdentity.sampleId equals sample.id

    where sample.id == selectedSample.id

    orderby sample.name

    select chemicalidentity;

     

    How do I select all thos ChemicalIdentities NOT in the join?

     

    Thanks.

    Friday, October 10, 2008 7:25 AM