System.InvalidOperationException: No database provider has been configured for this DbContext. A provider can be configured by overriding the 'DbContext.OnConfiguring' method or by using 'AddDbContext' on the application service provider. If 'AddDbContext' is used, then also ensure that your DbContext type accepts a DbContextOptions<TContext> object in its constructor and passes it to the base constructor for DbContext.

System.InvalidOperationException: No database provider has been configured for this DbContext. A provider can be configured by overriding the 'DbContext.OnConfiguring' method or by using 'AddDbContext' on the application service provider. If 'AddDbContext' is used, then also ensure that your DbContext type accepts a DbContextOptions<TContext> object in its constructor and passes it to the base constructor for DbContext.

 [HttpPost]
    public async Task<IActionResult> Update(ListingProjects updatedUserModelRef)
    {
        
        
        if (oldListingProjects == null)
        {
            if (Request.Headers["X-Requested-With"] == "XMLHttpRequest")
            {
                return Json(new { success = false, message = "Record not found." }); //this is the error i see on View
            }
            return NotFound();
        }

 [HttpPost]
    public async Task<IActionResult> Update(ListingProjects updatedUserModelRef)
    {
        
        
        if (oldListingProjects == null)
        {
            if (Request.Headers["X-Requested-With"] == "XMLHttpRequest")
            {
                return Json(new { success = false, message = "Record not found." }); //this is the error i see on View
            }
            return NotFound();
        }

 mysql> Select * from ListingDBTable;
+----+----------------------+----------------------------------+------------+------------+
| Id | ListingName          | ImageUrl                         | CategoryId | LocationId |
+----+----------------------+----------------------------------+------------+------------+
|  5 | Beachfront Villa     | http://example.com/villa.jpg     |          1 |          1 |
|  6 | hidden moon building | hiddenmoon                       |          1 |          1 |
| 74 | New Listing          | http://example.com/new_image.jpg |          1 |          1 |
+----+----------------------+----------------------------------+------------+------------+

 mysql> Select * from ListingDBTable;
+----+----------------------+----------------------------------+------------+------------+
| Id | ListingName          | ImageUrl                         | CategoryId | LocationId |
+----+----------------------+----------------------------------+------------+------------+
|  5 | Beachfront Villa     | http://example.com/villa.jpg     |          1 |          1 |
|  6 | hidden moon building | hiddenmoon                       |          1 |          1 |
| 74 | New Listing          | http://example.com/new_image.jpg |          1 |          1 |
+----+----------------------+----------------------------------+------------+------------+

 
//clicking the save btn prompts this method to work
public async Task<IActionResult> Update(ListingProjects updatedUserModelRef)
    {
        if (updatedUserModelRef == null || updatedUserModelRef.ListingName == null)
        {
            if (Request.Headers["X-Requested-With"] == "XMLHttpRequest")
            {
                return Json(new { success = false, message = "Invalid data received." }); //however it always falls into this invalid message..
            }
            return NotFound();
        }

 
//clicking the save btn prompts this method to work
public async Task<IActionResult> Update(ListingProjects updatedUserModelRef)
    {
        if (updatedUserModelRef == null || updatedUserModelRef.ListingName == null)
        {
            if (Request.Headers["X-Requested-With"] == "XMLHttpRequest")
            {
                return Json(new { success = false, message = "Invalid data received." }); //however it always falls into this invalid message..
            }
            return NotFound();
        }

   public IActionResult InsertListings()
   {
       return View();
   }
    
    [HttpPost]
    [ValidateAntiForgeryToken]
    public ActionResult InsertListings([Bind("ListingName")] ListingProjects listingProject) // Change to ListingProjects model
    {
        
        try
        {
            if (ModelState.IsValid)
            {
                _context.ListingDBTable.Add(listingProject);
                _context.SaveChanges();
                return RedirectToAction("TestDashboard1"); // Redirect to dashboard
            }
            else
            {
                // Model is invalid, handle it (e.g., show validation errors)
                return View(listingProject); // Return the view with error messages
            }
        }
        catch (DbUpdateException dbUpdateException)
        {
            ModelState.AddModelError("", "Unable to save changes. " +
                                         "Try again, and if the problem persists " +
                                         "see your system administrator.");
        }

        return View(listingProject);
    }

   public IActionResult InsertListings()
   {
       return View();
   }
    
    [HttpPost]
    [ValidateAntiForgeryToken]
    public ActionResult InsertListings([Bind("ListingName")] ListingProjects listingProject) // Change to ListingProjects model
    {
        
        try
        {
            if (ModelState.IsValid)
            {
                _context.ListingDBTable.Add(listingProject);
                _context.SaveChanges();
                return RedirectToAction("TestDashboard1"); // Redirect to dashboard
            }
            else
            {
                // Model is invalid, handle it (e.g., show validation errors)
                return View(listingProject); // Return the view with error messages
            }
        }
        catch (DbUpdateException dbUpdateException)
        {
            ModelState.AddModelError("", "Unable to save changes. " +
                                         "Try again, and if the problem persists " +
                                         "see your system administrator.");
        }

        return View(listingProject);
    }

var app = builder.Build();

using (var scope = app.Services.CreateScope())
{
    var db = scope.ServiceProvider.GetRequiredService<ApplicationDbContext>();
    db.Database.Migrate();
    var services = scope.ServiceProvider;

    var seeder = new DataSeed(db);
    seeder.SeedModels();  
}

var app = builder.Build();

using (var scope = app.Services.CreateScope())
{
    var db = scope.ServiceProvider.GetRequiredService<ApplicationDbContext>();
    db.Database.Migrate();
    var services = scope.ServiceProvider;

    var seeder = new DataSeed(db);
    seeder.SeedModels();  
}

mysql> SELECT * FROM PortalUsers;
+---------------+------+-------------+-------------------------------------------------+
| Name          | Age  | Location    | DisplayInfo                                     |
+---------------+------+-------------+-------------------------------------------------+
| Alice Smith   | 30   | New York    | Name: Alice Smith Age: 30 Location: New York    |
| Bob Johnson   | 25   | Los Angeles | Name: Bob Johnson Age: 25 Location: Los Angeles |
| Charlie Brown | 35   | Chicago     | Name: Charlie Brown Age: 35 Location: Chicago   |
+---------------+------+-------------+-------------------------------------------------+
3 rows in set (0.00 sec)

mysql> SELECT * FROM PortalUsers;
+---------------+------+-------------+-------------------------------------------------+
| Name          | Age  | Location    | DisplayInfo                                     |
+---------------+------+-------------+-------------------------------------------------+
| Alice Smith   | 30   | New York    | Name: Alice Smith Age: 30 Location: New York    |
| Bob Johnson   | 25   | Los Angeles | Name: Bob Johnson Age: 25 Location: Los Angeles |
| Charlie Brown | 35   | Chicago     | Name: Charlie Brown Age: 35 Location: Chicago   |
+---------------+------+-------------+-------------------------------------------------+
3 rows in set (0.00 sec)