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 equals sample_chemicalIdentity.chemicalIdentityId

    join sample in samplesDC.Samples on sample_chemicalIdentity.sampleId equals

    where ==


    select chemicalidentity;


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



    Friday, October 10, 2008 7:25 AM