InvalidOperationException While Using the Existing DB in MVC Core

Question

I tried to use the existing database in my application but every time I hit the view it says

An unhandled exception occurred while processing the InvalidOperationException: Unable to resolve service for type 'BookStore.Models.BookStoreContext' while attempting to activate 'BookStore.Models.UsersRepo'

Context

    namespace BookStore.Models
    {
        public partial class BookStoreContext : DbContext
        {
            public BookStoreContext()
            {
            }

            public BookStoreContext(DbContextOptions<BookStoreContext> options)
                : base(options)
            {
            }

            public virtual DbSet<Users> Users { get; set; }

            protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
            {
                if (!optionsBuilder.IsConfigured)
                {
                    optionsBuilder.UseSqlServer("Server=(localdb)\\V11.0;Database=BookStore;Trusted_Connection=True;");
                }
            }

            protected override void OnModelCreating(ModelBuilder modelBuilder)
            {
                modelBuilder.HasAnnotation("ProductVersion", "2.2.3-servicing-35854");

                modelBuilder.Entity<Users>(entity =>
                {
                    entity.HasKey(e => e.UserId);

                    entity.Property(e => e.UserId).HasColumnName("User_ID");

                    entity.Property(e => e.Password)
                        .IsRequired()
                        .HasMaxLength(50);

                    entity.Property(e => e.UserName)
                        .IsRequired()
                        .HasColumnName("User_Name")
                        .HasMaxLength(50);
                });
            }
        }
    }

User Repository

    namespace BookStore.Models
    {
        public class UsersRepo : IUser
        {
            private readonly BookStoreContext _bookStoreContext;

            public UsersRepo(BookStoreContext bookStoreContext)
            {
                _bookStoreContext = bookStoreContext;
            }

            public void AddUser(Users users)
            {
                _bookStoreContext.Users.Add(users);
                _bookStoreContext.SaveChanges();
            }
        }
    }

User Model

    public partial class Users
        {
            public long UserId { get; set; }
            public string UserName { get; set; }
            public string Password { get; set; }
            public int Type { get; set; }
        }


     public interface IUser
        {
            void AddUser(Users users);
        }

User Controller

    public class UsersController : Controller
        {
            private readonly IUser _userRepo;

            public UsersController(IUser userRepo)
            {
                _userRepo = userRepo;
            }

            [HttpGet]
            public IActionResult Index()
            {
                return View();
            }

            [HttpPost]
            public IActionResult Index(Users users)
            {
                _userRepo.AddUser(users);

                return RedirectToAction("UserAddedSuccessfully");
            }

            public IActionResult UserAddedSuccessfully()
            {
                return View();
            }
        }

Are you using Entity Framework Core? If not this will not work. If you're trying to use existing EF 5/6 code with .net Core it will not work as the two are not compatible. See stackoverflow.com/questions/43746738/… — Jacob
– Jacob, Commented Apr 24, 2019 at 8:18
Have you registered the dbcontext by services.AddDbContext<BookStoreContext>();? — itminus
– itminus, Commented Apr 24, 2019 at 8:21

Umar Abbas · Accepted Answer · 2019-04-24 19:29:16Z

0

I tried this one and it is perfectly working

 public void ConfigureServices(IServiceCollection services)
    {
        services.AddMvc().SetCompatibilityVersion(CompatibilityVersion.Version_2_2);
        services.AddDbContext<BookStoreContext>();
        // In production, the Angular files will be served from this directory
        services.AddSpaStaticFiles(configuration =>
        {
            configuration.RootPath = "ClientApp/dist";
        });
    }

answered Apr 24, 2019 at 19:29

Umar Abbas

4,1612 gold badges26 silver badges21 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

InvalidOperationException While Using the Existing DB in MVC Core

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related