blog-2024-02-11-entity-framework-home-controller.cs

using System.Diagnostics;
using Microsoft.AspNetCore.Mvc;
using Microsoft.EntityFrameworkCore;
using WebApplication1.Models;

namespace WebApplication1.Controllers;

public class HomeController : Controller
{
    private readonly ILogger<HomeController> _logger;
    private readonly BlogDbContext _blogDbContext;

    public HomeController(ILogger<HomeController> logger, BlogDbContext blogDbContext)
    {
        _logger = logger;
        _blogDbContext = blogDbContext;
        _blogDbContext.Database.EnsureCreated();
    }

    public IActionResult Index()
    {
        var movies = _blogDbContext.Posts.AsNoTracking().ToList();
        return View(movies);
    }

    [HttpPost]
    [Route("/create")]
    public IActionResult Create(string title)
    {
        var movie = new Post
        {
            Id = Guid.NewGuid(),
            Title = title,
            ReleaseDate = DateTime.Now
        };
        _blogDbContext.Posts.Add(movie);
        _blogDbContext.SaveChanges();
        return RedirectToAction("Index");
    }

    [HttpPost]
    [Route("/edit")]
    public IActionResult Edit(Guid id, string title)
    {
        var m = _blogDbContext.Posts.Single(x => x.Id == id);
        m.UpdateDate = DateTime.Now;
        m.Title = title;
        _blogDbContext.SaveChanges();
        return RedirectToAction("Index");
    }

    [HttpPost]
    [Route("/edit/update")]
    public IActionResult EditUpdate(Guid id, string title)
    {
        var m = new Post
        {
            Id = id,
            Title = title,
            UpdateDate = DateTime.Now
        };

        _blogDbContext.Update(m); // This will mark the entity as modified
        _blogDbContext.SaveChanges();
        return RedirectToAction("Index");
    }

    [HttpPost]
    [Route("/edit/attach")]
    public IActionResult EditAttach(Guid id, string title)
    {
        var m = new Post
        {
            Id = id,
        };

        _blogDbContext.Posts.Attach(m);

        m.Title = title;
        m.UpdateDate = DateTime.Now;

        _blogDbContext.SaveChanges();
        return RedirectToAction("Index");
    }
    
    [HttpPost]
    [Route("/edit/attach-v2")]
    public IActionResult EditAttachV2(Guid id, string title)
    {
        var m = new Post
        {
            Id = id,
            Title = $"{title}-v2",
            UpdateDate = DateTime.Now
        };
        _blogDbContext.Posts.Attach(m);
        _blogDbContext.SaveChanges();
        return RedirectToAction("Index");
    }

    [HttpPost]
    [Route("/edit/notrack-edit")]
    public IActionResult NoTrackEdit(Guid id, string title)
    {
        var m = _blogDbContext.Posts.AsNoTracking().Single(x => x.Id == id);
        m.UpdateDate = DateTime.Now;
        m.Title = title;
        _blogDbContext.SaveChanges();
        return RedirectToAction("Index");
    }

    [HttpPost]
    [Route("/edit/notrack-update")]
    public IActionResult NoTrackUpdate(Guid id, string title)
    {
        var m = _blogDbContext.Posts.AsNoTracking().Single(x => x.Id == id);
        m.UpdateDate = DateTime.Now;
        m.Title = title;
        _blogDbContext.Update(m); // This will mark the entity as modified
        _blogDbContext.SaveChanges();
        return RedirectToAction("Index");
    }
    
    [HttpPost]
    [Route("/edit/notrack-attach")]
    public IActionResult NoTrackAttach(Guid id, string title)
    {
        var m = _blogDbContext.Posts.AsNoTracking().Single(x => x.Id == id);
        m.UpdateDate = DateTime.Now;
        m.Title = title;
        _blogDbContext.Posts.Attach(m);
        _blogDbContext.SaveChanges();
        return RedirectToAction("Index");
    }
    
    [HttpPost]
    [Route("/edit/notrack-attach-v2")]
    public IActionResult NoTrackAttachV2(Guid id, string title)
    {
        var m = _blogDbContext.Posts.AsNoTracking().Single(x => x.Id == id);
        _blogDbContext.Posts.Attach(m);
        m.UpdateDate = DateTime.Now;
        m.Title = $"{title}-v2";
        _blogDbContext.Entry(m).State = EntityState.Modified;
        _blogDbContext.SaveChanges();
        return RedirectToAction("Index");
    }
    
    [HttpPost]
    [Route("/edit/notrack-attach-update")]
    public IActionResult NoTrackAttachUpdate(Guid id, string title)
    {
        var m = _blogDbContext.Posts.AsNoTracking().Single(x => x.Id == id);
        m.UpdateDate = DateTime.Now;
        m.Title = title;
        _blogDbContext.Posts.Attach(m);
        _blogDbContext.Posts.Update(m);
        _blogDbContext.SaveChanges();
        return RedirectToAction("Index");
    }
    
    [HttpPost]
    [Route("/delete")]
    public IActionResult NoTrackAttachUpdate(Guid id)
    {
        var m = _blogDbContext.Posts.Single(x => x.Id == id);
        _blogDbContext.Posts.Remove(m);
        _blogDbContext.SaveChanges();
        return RedirectToAction("Index");

    }

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

public class BlogDbContext : DbContext
{
    public BlogDbContext(DbContextOptions<BlogDbContext> options) : base(options)
    {
    }

    public override int SaveChanges()
    {
        return base.SaveChanges();
    }

    public DbSet<Post> Posts { get; set; }
}

public class Post
{
    public Guid Id { get; set; }
    public string Title { get; set; }
    public DateTime ReleaseDate { get; set; }
    public DateTime? UpdateDate { get; set; }
}