public void DeleteFileInfo(Files fileInfo) { using (var ctx = new FullShareContext()) { ctx.Entry(fileInfo).State = EntityState.Deleted; ctx.SaveChanges(); } }
public void InsertFilesEntry(Files fileInfo) { using (var ctx = new FullShareContext()) { ctx.Files.Add(fileInfo); ctx.SaveChanges(); } }
// Optionally, this can be optimized with DELETE FROM files WHERE date_part('day', age($1, uploadedOn)) >= $2 RETURNING code; // Returns the codes of the deleted records. public List <string> DeleteFilesOlderThan(TimeSpan duration) { using (var ctx = new FullShareContext()) { var filesToDelete = from f in ctx.Files where f.Uploadedon != null && DateTime.UtcNow.Subtract(f.Uploadedon.Value) >= duration select f; List <string> codes = filesToDelete.Select(f => f.Code).ToList(); ctx.Files.RemoveRange(filesToDelete); ctx.SaveChanges(); return(codes); } }
public bool FileInfoExists(string code) { using (var ctx = new FullShareContext()) { return(ctx.Files.Any(file => file.Code == code)); } }
// Throws an exception if a matching file is not found. public Files GetFileInfo(string code) { using (var ctx = new FullShareContext()) { return(ctx.Files.Single(file => file.Code == code)); } }
public void Migrate() { using (var ctx = new FullShareContext()) { ctx.Database.Migrate(); } }