public async Task AddPost(Post post) { using (var context = RepositoryContextFactory.CreateDbContext(ConnectionString)) { context.Posts.Add(post); await context.SaveChangesAsync(); } }
public async Task AddComment(Comment comment) { using (var context = RepositoryContextFactory.CreateDbContext(ConnectionString)) { context.Comments.Add(comment); await context.SaveChangesAsync(); } }
/// <inheritdoc /> public async Task <OrderDto> GetAsync(long id) { using (var context = RepositoryContextFactory.CreateDbContext()) { var result = await GetQueryableOrders(context, true).SingleOrDefaultAsync(e => e.Id == id); return(result); } }
public RepositoryContext CreateDbContext(string[] args) { var builder = new ConfigurationBuilder() .SetBasePath(Directory.GetCurrentDirectory()) .AddJsonFile("appsettings.json"); var config = builder.Build(); var connectionString = config.GetConnectionString("DefaultConnection"); var repositoryFactory = new RepositoryContextFactory(); return(repositoryFactory.CreateDbContext(connectionString)); }
public async Task DeleteComment(int commentId) { using (var context = RepositoryContextFactory.CreateDbContext(ConnectionString)) { var coomment = new Comment() { CommentId = commentId }; context.Comments.Remove(coomment); await context.SaveChangesAsync(); } }
public async Task DeletePost(int postId) { using (var context = RepositoryContextFactory.CreateDbContext(ConnectionString)) { var post = new Post() { PostId = postId }; context.Posts.Remove(post); await context.SaveChangesAsync(); } }
public RepositoryContext CreateDbContext(string[] args) { var builder = new ConfigurationBuilder() .SetBasePath(Directory.GetCurrentDirectory()) .AddJsonFile("appsettings.json"); var config = builder.Build(); //вытаскиваем строку подключения из конфига var connectionString = config.GetConnectionString("DefaultConnection"); var repositoryFactory = new RepositoryContextFactory(); //создаем и возвращаем DBContext return(repositoryFactory.CreateDbContext(connectionString)); }