You can create a DTO class instead of return model classes Public UsersController(ApplicationDbContext context, ILogger logger) Private readonly ApplicationDbContext _context

Public class UsersController : ControllerBase The context is created by dependency injection. In the controller add ApplicationDbContext parameter to contructor. Update the database with the new migration. Public ApplicationDbContext(DbContextOptions options): base(options)īuilder.Appl圜onfiguration(new PostConfiguration()) Īdd migration. The database annotations I prefer to set configuration in DbContext. The issue I'm currently facing is that I have an endpoint /posts and I want that endpoint to return all the rows from the cms_posts table.īut how can I pass the context to that table into my endpoint so I can get all the rows? Protected override void OnModelCreating(ModelBuilder builder)Īnd the CreatePostmodel: public class CreatePostModelĪnd I add it to the startup like this: services.AddDbContext(options => options.UseMySql(connectionString, ServerVersion.AutoDetect(connectionString))) Īnd I can see my table cms_posts in the database with the correct columns and all. Public ApplicationDbContext(DbContextOptions options) : base(options) My ApplicationDbContext looks like this: public class ApplicationDbContext : IdentityDbContext

PostId is an int and auto-increments, and the rest are just text columns. I want to extend my project to support storing and image url and text, I have a table named cms_posts and the structure looks like this: | postId | postImage | postTitle | postBody | NET that is using Entity Framework, and I followed this tutorial:

Microsoft products not opimized for mac