How bind the menu from myslq db in _Layout.cshtml with eg code ?

binding a dynamic menu from a MySQL database into your _Layout.cshtml in ASP.NET Core MVC is a common requirement. Let me walk you through a step-by-step example with code.

Steps to Bind Menu from MySQL DB

1. Create a Menu Model

public class MenuItem
{
    public int Id { get; set; }
    public string Title { get; set; }
    public string Url { get; set; }
}

2. Setup EF Core with MySQL

Install the NuGet package:

dotnet add package Pomelo.EntityFrameworkCore.MySql

Configure DbContext:

public class AppDbContext : DbContext
{
    public AppDbContext(DbContextOptions options) : base(options) { }

    public DbSet MenuItems { get; set; }
}

In Program.cs (or Startup.cs):

builder.Services.AddDbContext(options =>
    options.UseMySql(builder.Configuration.GetConnectionString("DefaultConnection"),
        new MySqlServerVersion(new Version(8, 0, 25))));

3. Create a Service to Fetch Menu

public interface IMenuService
{
    Task> GetMenuAsync();
}

public class MenuService : IMenuService
{
    private readonly AppDbContext _context;

    public MenuService(AppDbContext context)
    {
        _context = context;
    }

    public async Task> GetMenuAsync()
    {
        return await _context.MenuItems.ToListAsync();
    }
}

Register service in Program.cs:

builder.Services.AddScoped();

4. Use ViewComponent for Menu

Create MenuViewComponent.cs:

public class MenuViewComponent : ViewComponent
{
    private readonly IMenuService _menuService;

    public MenuViewComponent(IMenuService menuService)
    {
        _menuService = menuService;
    }

    public async Task InvokeAsync()
    {
        var menuItems = await _menuService.GetMenuAsync();
        return View(menuItems);
    }
}

5. Create View for Menu Component

Views/Shared/Components/Menu/Default.cshtml:

@foreach (var item in Model)
{
    

        @item.Title
    
}

6. Call Component in _Layout.cshtml

    

        @await Component.InvokeAsync("Menu")
    

    

        @RenderBody()
    

Result

• Menu items are fetched from MySQL DB.

• They are rendered dynamically in _Layout.cshtml.

• Easy to maintain: just update the DB table, and the menu updates automatically.