Cacher is the code snippet organizer for pro developers

    decimal PartsPerContainer =
        (from p in Db.Part.With(LockHint.NoLock)
        where p.Company == ttPartTranRow.Company && p.PartNum == ttPartTranRow.PartNum
        select p.PartsPerContainer).DefaultIfEmpty(0).First();

    ttPartTranRow["Number01"] = PartsPerContainer;