Hello Team,
In my MVC C# controller, I have a method that bind item with DbDataSet called MyContext,
But any time I run the project I get the following error.
private MyContext db = new MyContext(); public ActionResult Index() { var items = db.Items.Include(i => i.DrugGenericNames).Include(i => i.Manufacturer).OrderByDescending(i => i.ItemID); return View(items.ToList()); }
public class MyContext : DbContext { public MyContext() : base("connectionString") {
} public DbSet<DrugGeneric> DrugGenericNames { get; set; } public DbSet<Item> Items { get; set; } public DbSet<Manufacturer> Manufacturers { get; set; } public DbSet<Stock> Stocks { get; set; } public DbSet<tblSupplier> Suppliers { get; set; } public DbSet<tblPurchase> Purchases { get; set; } public DbSet<tblPurchaseItem> PurchaseItems { get; set; } public DbSet<tblNotification> Notifications { get; set; } public DbSet<SalesReturn> SalesReturns { get; set; } public DbSet<SalesReturnDetail> SalesReturnDetails { get; set; } public DbSet<Sales> Sales { get; set; } public DbSet<SalesItem> SalesItems { get; set; } public DbSet<tblUser> Users { get; set; } //avoids pluralizing table names in database protected override void OnModelCreating(DbModelBuilder modelBuilder) { modelBuilder.Conventions.Remove<PluralizingTableNameConvention>();
} } }