public void Save(DalUser user) { using (var context = new FileStorageDbContext()) { context.Users.Add(user.ToOrmUser()); context.SaveChanges(); } }
public void Save(DalFile file) { using (var context = new FileStorageDbContext()) { var oldFile = context.Files.Where(f => f.Name.Equals(file.Name) && f.Path.Equals(file.Path)).Select(f => f); file.Id = oldFile.Count() != 0 ? oldFile.First().Id : Guid.NewGuid(); context.Files.RemoveRange(oldFile); context.Files.Add(file.ToOrmFile()); context.SaveChanges(); } }
public void Delete(Guid id) { using (var context = new FileStorageDbContext()) { var user = context.Users.FirstOrDefault(u => u.Id == id); if (user == null) { return; } context.Users.Remove(user); context.SaveChanges(); } }
public void Delete(Guid id) { using (var context = new FileStorageDbContext()) { var file = context.Files.FirstOrDefault(f => f.Id == id); if (file == null) { return; } context.Files.Remove(file); context.SaveChanges(); } }
public void Save(IEnumerable <DalRole> roles) { using (var context = new FileStorageDbContext()) { foreach (var dalRole in roles) { context.Roles.Add(new OrmRole() { Id = dalRole.Id, Name = dalRole.Name }); } context.SaveChanges(); } }
public void DeleteByOwnerId(Guid ownerId) { using (var context = new FileStorageDbContext()) { var files = context.Files .Where(elem => elem.OwnerId == ownerId) .Select(elem => elem); foreach (var file in files.Where(file => file != null)) { context.Files.Remove(file); context.SaveChanges(); } } }
private void InitializeDatabase() { var options = new DbContextOptionsBuilder <FileStorageDbContext>() .UseSqlServer(ApplicationSettings.Storage.DataStoreConnectionString) .Options; using (var dbContext = new FileStorageDbContext(options)) { dbContext.Database.EnsureDeleted(); dbContext.Database.EnsureCreated(); dbContext.SaveChanges(); ConfigureDependencies(dbContext); IUploadSessionRepository uploadSessionRepository = this.InitializationKernel.Get <IUploadSessionRepository>(); DatabaseSeeder.Seed(uploadSessionRepository); } }