add-migration error

To resolve the migration issue, follow these steps:

1. Move the ConfigureServices method to the Startup.cs file in your MVC project. This method should be used to configure services for dependency injection, not within the DbContext class.

2. Ensure that the DbContext class only contains the necessary configurations related to the database context itself, such as entity mappings and database connection settings.

3. Modify the Startup.cs file to include the AddDbContext method for configuring the DbContext and database provider. Here is an example of how it should look:

4. public void ConfigureServices(IServiceCollection services)
   {
       services.AddDbContext(options =>
           options.UseSqlServer(Configuration.GetConnectionString("DefaultConnection")));
   }
   

    

5. Update the OnConfiguring method in the ProdDBContext class to remove the hard-coded connection string and rely on the configuration from the Startup.cs file. This ensures that the database connection is configured correctly.

Hello emma oj,

Can you plese replace the your code with below one and after try it.

using Microsoft.EntityFrameworkCore;
using Microsoft.Extensions.DependencyInjection;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Runtime.InteropServices;
using System.Text;
using System.Threading.Tasks;

namespace DemoRepository.Model
{
    public class ProdDBContext : DbContext
    {
		public ProdDBContext(DbContextOptions options)
			: base(options)
		{
		}
		
        public DbSet Workers { get; set; }

        protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
        {

            if (optionsBuilder.IsConfigured)
            {
                optionsBuilder.UseSqlServer("Server=DESKTOP-1M2N4KR\\EMMA;Database=Rocky;Integrated Security=true; Trusted_Connection=True;TrustServerCertificate=True;");
            }
			
            base.OnConfiguring(optionsBuilder);
        }

        public void ConfigureServices(IServiceCollection services)
        {
           IServiceCollection serviceCollection = services.AddDbContext(
           options => options.UseSqlServer("Server=DESKTOP-1M2N4KR\\HQ;Database=Rocky;Integrated Security=true;Trusted_Connection=True;TrustServerCertificate=True;"));
        }
    }
}

Thanks

Hi emma oj,

Constructor section missing 

using Microsoft.EntityFrameworkCore;
using Microsoft.Extensions.DependencyInjection;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Runtime.InteropServices;
using System.Text;
using System.Threading.Tasks;

namespace DemoRepository.Model
{
    public class ProdDBContext : DbContext
    {
public ProdDBContext(DbContextOptions options):: base(options){
}
        public DbSet Workers { get; set; }

        protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
        {

            if (optionsBuilder.IsConfigured)
            {
                optionsBuilder.UseSqlServer("Server=DESKTOP-1M2N4KR\\EMMA;Database=Rocky;Integrated Security=true; Trusted_Connection=True;TrustServerCertificate=True;");


            }
            base.OnConfiguring(optionsBuilder);
        }

        public void ConfigureServices(IServiceCollection services)
        {
            IServiceCollection serviceCollection = services.AddDbContext(
           options => options.UseSqlServer("Server=DESKTOP-1M2N4KR\\HQ;Database=Rocky;Integrated Security=true;Trusted_Connection=True;TrustServerCertificate=True;"));
        }
    }

}