public async Task <ImageInfo> InsertImage(ImageInfo imageInfo, Stream image, CancellationToken token) { using (var transaction = _connection.BeginTransaction()) { imageInfo.ImageId = await _largeObjectManager.CreateAsync(imageInfo.ImageId, token); using (var stream = await _largeObjectManager.OpenReadWriteAsync(imageInfo.ImageId, token)) { await image.CopyToAsync(stream); } imageInfo.Id = _connection.InsertId(imageInfo); transaction.Commit(); return(imageInfo); } }
public void DeleteUser(int id) { using (var dataConnectionTransaction = _hereForYouConnection.BeginTransaction()) { _hereForYouConnection.UserClaims.Where(claim => claim.UserId == id).Delete(); _hereForYouConnection.UserLogins.Where(login => login.UserId == id).Delete(); _hereForYouConnection.UserRoles.Where(role => role.UserId == id).Delete(); _hereForYouConnection.UserTokens.Where(token => token.UserId == id).Delete(); _hereForYouConnection.Users.Where(user => user.Id == id).Delete(); dataConnectionTransaction.Commit(); } }