BAMF103AmexDataContext db = new BAMF103AmexDataContext();
DirectoryInfo dtFolder = new DirectoryInfo(@"E:\File");
IEnumerable<bam_F103_AllInstance> ligne_update = (from dossier in dtFolder.GetFiles()
join tableF in db.bam_F103_AllInstances on dossier.Name equals tableF.DATA_FileName
where !tableF.DT_Sent.HasValue
select tableF).Distinct();
//update en base
foreach (bam_F103_AllInstance Bam in ligne_update)
Bam.DT_Sent = DateTime.MaxValue;
foreach (bam_F103_AllInstance Bam in ligne_update)
Console.WriteLine(Bam.DT_Sent);
db.SubmitChanges(); |