ManytoManyMapping in Asp.Net Core

Packages

"Microsoft.EntityFrameworkCore" Version="5.0.0"

"Microsoft.EntityFrameworkCore.SqlServer" Version="5.0.0"

Controllers

HomeController.cs

using ManytoManyMapping.Models;

using Microsoft.AspNetCore.Mvc;

using Microsoft.Extensions.Logging;

using System;

using System.Collections.Generic;

using System.Diagnostics;

using System.Linq;

using System.Threading.Tasks;

namespace ManytoManyMapping.Controllers

{

public class HomeController : Controller

{

private readonly ILogger<HomeController> _logger;

public HomeController(ILogger<HomeController> logger)

{

_logger = logger;

}

public IActionResult Index()

{

return View();

}

public IActionResult Privacy()

{

return View();

}

[ResponseCache(Duration = 0, Location = ResponseCacheLocation.None, NoStore = true)]

public IActionResult Error()

{

return View(new ErrorViewModel { RequestId = Activity.Current?.Id ?? HttpContext.TraceIdentifier });

}

Data[Folder]

DataContext.cs

using ManytoManyMapping.Models;

using Microsoft.EntityFrameworkCore;

using System;

using System.Collections.Generic;

using System.Linq;

using System.Threading.Tasks;

namespace ManytoManyMapping.Data

{

public class DataContext : DbContext

{

public DataContext(DbContextOptions<DataContext>options):base(options)

{

}

public DbSet<Student>Students { get; set; }

public DbSet<Course> Courses { get; set; }

}

Models[Folder]

Course.cs

using System;

using System.Collections.Generic;

using System.Linq;

using System.Threading.Tasks;

namespace ManytoManyMapping.Models

{

//Table Course

public class Course

{

public int Id { get; set; }

public string Title { get; set; }

public string code { get; set; }

public ICollection<StudentCourse> Enrollment { get; set; }

}

Student.cs

using System;

using System.Collections.Generic;

using System.Linq;

using System.Threading.Tasks;

namespace ManytoManyMapping.Models

{

//Table Student

public class Student

{

public int Id { get; set; }

public string Name { get; set; }

public DateTime Enrolled { get; set; }

public ICollection<StudentCourse> Enrollment { get; set; }

}

StudentCourse.cs

Views[Fodler]

Index.cshtml

ViewData["Title"] = "Home Page";

}

<h1 class="display-4">Welcome</h1>

<p>Learn about <a href="https://docs.microsoft.com/aspnet/core">building Web apps with ASP.NET Core</a>.</p>

</div>

appsettings.json

{

"ConnectionStrings": {

"DefaultConnection": "Server=CHETUIWK0541\\CMSQLEXPRESS;Database=GST;Trusted_Connection=True;MultipleActiveResultSets=True"

"Logging": {

"LogLevel": {

"Default": "Information",

"Microsoft": "Warning",

"Microsoft.Hosting.Lifetime": "Information"

}

"AllowedHosts": "*"

}

Startup.cs

using ManytoManyMapping.Data;

using Microsoft.AspNetCore.Builder;

using Microsoft.AspNetCore.Hosting;

using Microsoft.EntityFrameworkCore;

using Microsoft.Extensions.Configuration;

using Microsoft.Extensions.DependencyInjection;

using Microsoft.Extensions.Hosting;

using System;

using System.Collections.Generic;

using System.Linq;

using System.Threading.Tasks;

namespace ManytoManyMapping

{

public class Startup

{

public Startup(IConfiguration configuration)

{

Configuration = configuration;

}

public IConfiguration Configuration { get; }

// This method gets called by the runtime. Use this method to add services to the container.

public void ConfigureServices(IServiceCollection services)

{

services.AddControllersWithViews();

services.AddDbContext<DataContext>(options => options.UseSqlServer(Configuration.GetConnectionString("DefaultConnection")));

}

// This method gets called by the runtime. Use this method to configure the HTTP request pipeline.

public void Configure(IApplicationBuilder app, IWebHostEnvironment env)

{

if (env.IsDevelopment())

{

app.UseDeveloperExceptionPage();

}

else

{

app.UseExceptionHandler("/Home/Error");

}

app.UseStaticFiles();

app.UseRouting();

app.UseAuthorization();

app.UseEndpoints(endpoints =>

{

endpoints.MapControllerRoute(

name: "default",

pattern: "{controller=Home}/{action=Index}/{id?}");

});

}

Follow us

ManytoManyMapping in Asp.Net Core