private DbContext GetDbContext()
{
DbContextOptions <BlogAPIContext> options;
var builder = new DbContextOptionsBuilder <BlogAPIContext>();
builder.UseSqlServer(@"Data Source=(LocalDb)\MSSQLLocalDB;Initial Catalog=BlogAPIContext-f6e6f265-4faa-4f87-a186-9e4d1081e23f;Integrated Security=True");
options = builder.Options;
BlogAPIContext BlogAPIContext = new BlogAPIContext(options);
return(BlogAPIContext);
}
private ICollection <IUserPost> GetAllUserPost()
{
BlogAPIContext blogAPIContext = (BlogAPIContext)GetDbContext();
blogAPIContext.UserPosts = new List <IUserPost>();
foreach (IUserPost item in blogAPIContext.Comments)
{
blogAPIContext.UserPosts.Add(item);
}
foreach (IUserPost item in blogAPIContext.UserInfos)
{
blogAPIContext.UserPosts.Add(item);
}
foreach (IUserPost item in blogAPIContext.Posts)
{
blogAPIContext.UserPosts.Add(item);
}
return(blogAPIContext.UserPosts);
}
public PostService(BlogAPIContext context)
{
_context = context;
}
public UserInfoesController(BlogAPIContext context)
{
_context = context;
}
public CommentsController(BlogAPIContext context)
{
_context = context;
}
public PostsController(BlogAPIContext context)
{
_context = context;
}
