public async Task <ActionResult <IEnumerable <Post> > > ReadLatestPosts(string category, int count)
{
using var dbContext = new PostServiceContext(GetConnectionString(category));
return(await dbContext.Post
.OrderByDescending(p => p.PostId)
.Where(p => p.CategoryId == category)
.Take(count)
.Include(x => x.User)
.ToListAsync());
}
public void InitDatabase(int countUsers, int countCategories)
{
foreach (var connectionString in _connectionStrings)
{
using var dbContext = new PostServiceContext(connectionString);
dbContext.Database.EnsureDeleted();
dbContext.Database.EnsureCreated();
for (int i = 1; i <= countUsers; i++)
{
dbContext.User.Add(new User {
Name = "User" + i, Version = 1
});
dbContext.SaveChanges();
}
for (int i = 1; i <= countCategories; i++)
{
dbContext.Category.Add(new Category {
CategoryId = "Category" + i
});
dbContext.SaveChanges();
}
}
}
public async Task <int> CreatePost(Post post)
{
using var dbContext = new PostServiceContext(GetConnectionString(post.CategoryId));
dbContext.Post.Add(post);
return(await dbContext.SaveChangesAsync());
}