Entity Framework Code First Approach

Package

"Microsoft.EntityFrameworkCore.SqlServer" Version="5.0.17"
"Microsoft.EntityFrameworkCore.Tools" Version="5.0.17"
"Microsoft.VisualStudio.Web.CodeGeneration.Design" Version="5.0.2"

Controllers[Folder]

EmployeesController.cs

using System;

using System.Collections.Generic;

using System.Linq;

using System.Threading.Tasks;

using Microsoft.AspNetCore.Mvc;

using Microsoft.AspNetCore.Mvc.Rendering;

using Microsoft.EntityFrameworkCore;

using EFCoreCodeFirst.Models;

namespace EFCoreCodeFirst.Controllers

{

public class EmployeesController : Controller

{

private readonly EmployeeContext _context;

public EmployeesController(EmployeeContext context)

{

_context = context;

}

// GET: Employees

public async Task<IActionResult> Index()

{

return View(await _context.Employees.ToListAsync());

}

// GET: Employees/Details/5

public async Task<IActionResult> Details(int? id)

{

if (id == null)

{

return NotFound();

}

var employee = await _context.Employees

.FirstOrDefaultAsync(m => m.Id == id);

if (employee == null)

{

return NotFound();

}

return View(employee);

}

// GET: Employees/Create

public IActionResult Create()

{

return View();

}

// POST: Employees/Create

// To protect from overposting attacks, enable the specific properties you want to bind to.

// For more details, see http://go.microsoft.com/fwlink/?LinkId=317598.

[HttpPost]

[ValidateAntiForgeryToken]

public async Task<IActionResult> Create([Bind("Id,Name,Gender,Designation,Salary")] Employee employee)

{

if (ModelState.IsValid)

{

_context.Add(employee);

await _context.SaveChangesAsync();

return RedirectToAction(nameof(Index));

}

return View(employee);

}

// GET: Employees/Edit/5

public async Task<IActionResult> Edit(int? id)

{

if (id == null)

{

return NotFound();

}

var employee = await _context.Employees.FindAsync(id);

if (employee == null)

{

return NotFound();

}

return View(employee);

}

// POST: Employees/Edit/5

// To protect from overposting attacks, enable the specific properties you want to bind to.

// For more details, see http://go.microsoft.com/fwlink/?LinkId=317598.

[HttpPost]

[ValidateAntiForgeryToken]

public async Task<IActionResult> Edit(int id, [Bind("Id,Name,Gender,Designation,Salary")] Employee employee)

{

if (id != employee.Id)

{

return NotFound();

}

if (ModelState.IsValid)

{

try

{

_context.Update(employee);

await _context.SaveChangesAsync();

}

catch (DbUpdateConcurrencyException)

{

if (!EmployeeExists(employee.Id))

{

return NotFound();

}

else

{

throw;

}

return RedirectToAction(nameof(Index));

}

return View(employee);

}

// GET: Employees/Delete/5

public async Task<IActionResult> Delete(int? id)

{

if (id == null)

{

return NotFound();

}

var employee = await _context.Employees

.FirstOrDefaultAsync(m => m.Id == id);

if (employee == null)

{

return NotFound();

}

return View(employee);

}

// POST: Employees/Delete/5

[HttpPost, ActionName("Delete")]

[ValidateAntiForgeryToken]

public async Task<IActionResult> DeleteConfirmed(int id)

{

var employee = await _context.Employees.FindAsync(id);

_context.Employees.Remove(employee);

await _context.SaveChangesAsync();

return RedirectToAction(nameof(Index));

}

private bool EmployeeExists(int id)

{

return _context.Employees.Any(e => e.Id == id);

}

Models[Folder]

Employee.cs

using System;

using System.Collections.Generic;

using System.ComponentModel.DataAnnotations;

using System.Linq;

using System.Threading.Tasks;

namespace EFCoreCodeFirst.Models

{

public class Employee

{

[Key]

public int Id { get; set; }

public String Name { get; set; }

public String Gender { get; set; }

public String Designation { get; set; }

public String Salary { get; set; }

}

EmployeeContext.cs

using Microsoft.EntityFrameworkCore;

using System;

using System.Collections.Generic;

using System.Linq;

using System.Threading.Tasks;

namespace EFCoreCodeFirst.Models

{

public class EmployeeContext : DbContext

{

//Constructor

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

{

}

//Database table name is Employees

public DbSet<Employee> Employees { get; set; }

}

Views[Folder]

Employees

Create.cshtml

@model EFCoreCodeFirst.Models.Employee

ViewData["Title"] = "Create";

}

<h1>Create</h1>

<h4>Employee</h4>

<hr />

</div>

</div>

</div>

</div>

</div>

</form>

</div>

<div>

</div>

@section Scripts {

@{await Html.RenderPartialAsync("_ValidationScriptsPartial");}

}

Delete.cshtml

@model EFCoreCodeFirst.Models.Employee

ViewData["Title"] = "Delete";

}

<h1>Delete</h1>

<h3>Are you sure you want to delete this?</h3>

<div>

<h4>Employee</h4>

<hr />

@Html.DisplayNameFor(model => model.Name)

</dt>

@Html.DisplayFor(model => model.Name)

</dd>

@Html.DisplayNameFor(model => model.Gender)

</dt>

@Html.DisplayFor(model => model.Gender)

</dd>

@Html.DisplayNameFor(model => model.Designation)

</dt>

@Html.DisplayFor(model => model.Designation)

</dd>

@Html.DisplayNameFor(model => model.Salary)

</dt>

@Html.DisplayFor(model => model.Salary)

</dd>

</dl>

<input type="submit" value="Delete" class="btn btn-danger" /> |

</form>

</div>

Details.cshtml

@model EFCoreCodeFirst.Models.Employee

ViewData["Title"] = "Details";

}

<h1>Details</h1>

<div>

<h4>Employee</h4>

<hr />

@Html.DisplayNameFor(model => model.Name)

</dt>

@Html.DisplayFor(model => model.Name)

</dd>

@Html.DisplayNameFor(model => model.Gender)

</dt>

@Html.DisplayFor(model => model.Gender)

</dd>

@Html.DisplayNameFor(model => model.Designation)

</dt>

@Html.DisplayFor(model => model.Designation)

</dd>

@Html.DisplayNameFor(model => model.Salary)

</dt>

@Html.DisplayFor(model => model.Salary)

</dd>

</dl>

</div>

<div>

<a asp-action="Edit" asp-route-id="@Model.Id">Edit</a> |

</div>

Edit.cshtml

@model EFCoreCodeFirst.Models.Employee

ViewData["Title"] = "Edit";

}

<h4>Employee</h4>

<hr />

</div>

</div>

</div>

</div>

</div>

</form>

</div>

<div>

</div>

@section Scripts {

@{await Html.RenderPartialAsync("_ValidationScriptsPartial");}

}

Error.cshtml

@model int

}

<h2 class="text-danger">Record Not Found For Id @Model</h2>

Error1.cshtml

@model Employee

}

<h2 class="text-danger">Employee Salary and Designation Not Match </h2>

Index.cshtml

@model IEnumerable<EFCoreCodeFirst.Models.Employee>

ViewData["Title"] = "Index";

}

<h1>Index</h1>

<p>

<a asp-action="Create">Create New</a>

</p>

<thead>

<tr>

<th>

@Html.DisplayNameFor(model => model.Name)

</th>

<th>

@Html.DisplayNameFor(model => model.Gender)

</th>

<th>

@Html.DisplayNameFor(model => model.Designation)

</th>

<th>

@Html.DisplayNameFor(model => model.Salary)

</th>

</tr>

</thead>

<tbody>

@foreach (var item in Model) {

<tr>

<td>

@Html.DisplayFor(modelItem => item.Name)

</td>

<td>

@Html.DisplayFor(modelItem => item.Gender)

</td>

<td>

@Html.DisplayFor(modelItem => item.Designation)

</td>

<td>

@Html.DisplayFor(modelItem => item.Salary)

</td>

<td>

<a asp-action="Edit" asp-route-id="@item.Id">Edit</a> |

<a asp-action="Details" asp-route-id="@item.Id">Details</a> |

<a asp-action="Delete" asp-route-id="@item.Id">Delete</a>

</td>

</tr>

}

</tbody>

</table>

ErrorPage

ErrorPage.cshtml

ViewData["Title"] = "ErrorPage";

}

<h1 class="text-danger">@ViewData["Error"]</h1>

Startup.cs

using EFCoreCodeFirst.Models;

using Microsoft.AspNetCore.Builder;

using Microsoft.AspNetCore.Hosting;

using Microsoft.AspNetCore.HttpsPolicy;

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 EFCoreCodeFirst

{

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();

string cs = "server=CHETUIWK0541\\SQL2019NEW; database=CodeFirstEFCore; trusted_connection=true;";

services.AddDbContext<EmployeeContext>(options => options.UseSqlServer(cs));

}

// 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");

// The default HSTS value is 30 days. You may want to change this for production scenarios, see https://aka.ms/aspnetcore-hsts.

app.UseHsts();

}

app.UseHttpsRedirection();

app.UseStaticFiles();

app.UseRouting();

app.UseAuthorization();

app.UseEndpoints(endpoints =>

{

endpoints.MapControllerRoute(

name: "default",

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

});

}

Follow us

Entity Framework Code First Approach