I have a table that stores a bunch of diagnosis for a single plan. When the users create a new plan I need to copy over all existing diagnosis's as well. I had thought to try the below but this is obviously not correct. I am guessing that I will need to loop through my oldDiagnosis part, but how?

Thanks!

My Attempt so far...

public static void CopyPlanDiagnosis(int newPlanID, int oldPlanID)
    {
        using (var context = McpDataContext.Create())
        {
            var oldDiagnosis = from planDiagnosi in context.tblPlanDiagnosis 
                                where planDiagnosi.PlanID == oldPlanID 
                                select planDiagnosi;

            var newDiagnosis = new tblPlanDiagnosi
                                   {
                                       PlanID = newPlanID,
                                       DiagnosisCueID = oldDiagnosis.DiagnosisCueID,
                                       DiagnosisOther = oldDiagnosis.DiagnosisOther,
                                       AdditionalInfo = oldDiagnosis.AdditionalInfo,
                                       rowguid = Guid.NewGuid()
                                   };
            context.tblPlanDiagnosis.InsertOnSubmit(newDiagnosis);
            context.SubmitChanges();
        }
    }