public async Task Add(Archive archive) { using (var EFR = new EFRepositoryContext()) { Task EFRAdd = Task.Run(() => EFR.Files.AddRange(archive.Files)); EFRAdd.Wait(); EFR.Archives.Add(archive); await EFR.SaveChangesAsync(); } }
public async Task Remove(Archive archive) { using (var EFR = new EFRepositoryContext()) { EFR.Archives.Remove(archive); var filesToDelete = EFR.Files.Where(x => x.Archive.Name.Equals(archive.Name)); EFR.Files.RemoveRange(filesToDelete); await EFR.SaveChangesAsync(); } }
public async Task <List <Archive> > Load() { using (var EFR = new EFRepositoryContext()) { var EFRList = await EFR.Archives.ToListAsync <Archive>(); //var EFRFiles = EFR.Files.ToList<File>(); return(EFRList); } }
public async Task <List <File> > Search(string searchString) { using (var EFR = new EFRepositoryContext()) { //var returnList = EFR.Files.Where(f => f.Name.ToLower().Contains(searchString.ToLower())).SelectMany(); //var returnList = from f in EFR.Files.Include("Archive") where f.Name.ToLower().Contains(searchString.ToLower()) select f; var returnList = from f in EFR.Files where f.Name.ToLower().Contains(searchString.ToLower()) select f; //var returnList = EFR.Files.Where(f => f.Name == searchString).Select(x => x).Include("Archive") ; //List<File> returnList = EFR.Files.Include("Archive").Where(f => f.Name == searchString).ToList(); return(await returnList.Include("Archive").ToListAsync()); } }