Adding and using tables to DefaultConnection Database in ASP.NET MVC

Question

I'm trying to add more tables to DefaultConnection database in my MVC project, using code first approach.

I have the following setup:

MyClass.cs

public class MyClass
{
    public int Id { get; set; }
    public string Name{ get; set; }
    public int Age{ get; set; }
}

MyClassController.cs

 public class MyClassController : Controller
{
    public MyClassDbContext myClassDbContext = new MyClassDbContext();
    public ActionResult Index()
    {
        return View(myClassDbContext.MyClasses.ToList());
    }
}

MyClassDbContext.cs

public class MyClassDbContext: DbContext
{
    public DbSet<MyClass> MyClasses { get; set; }
}

I have not changed ConnectionString from its default settings since it is the same database that works with user registration and authentication and I have no issues with it.

After running code I get A network related or instance-specific error occurred while establishing a connection to SQL Server... error on return View(myClassDbContext.MyClasses.ToList()).

Question:

Am I missing something basic?

Set a breakpoint on this.Database.Exists() line and see if the DB exist there. If the error says "Server not found", you need to configure SQL Server connection string on web.config file. — Tetsuya Yamamoto
– Tetsuya Yamamoto, Commented Nov 2, 2016 at 5:48

Rajshee Turakhia · Accepted Answer · 2016-11-02 12:01:27Z

2

public class MyClassDbContext: DbContext
{
  public MyClassDbContext(string connString)
        : base(connString)
    {
    }
    public DbSet<MyClass> MyClasses { get; set; }
}

public class MyClassController : Controller
{
    public MyClassDbContext myClassDbContext = new MyClassDbContext("Name Of ConnectionString");
    public ActionResult Index()
    {
        return View(myClassDbContext.MyClasses.ToList());
    }
}

for adding more table you need to use constructor. above code helps you to make it working.

edited Nov 2, 2016 at 12:01

answered Nov 2, 2016 at 10:48

Rajshee Turakhia

2742 silver badges7 bronze badges

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

1 Comment

hello Over a year ago

This solved my error. I was not calling the base constructor.

Bucketcode · Accepted Answer · 2016-11-02 07:04:15Z

1

When you add a model e.g MyClass, you don't need add a new DBContext e.g MyClassDbContext, you just add MyClass to your exist DBContext which work for your registration. someting like this:

public class OldDbContext: DbContext
{
    public DbSet<MyClass> MyClasses { get; set; }
    public DbSet<User> Users{ get; set; }
}

Then you need add a Initializer to auto generatge table(more check this), or you can add table by youself it'll work if table is match to you class.

answered Nov 2, 2016 at 7:04

Bucketcode

4812 silver badges13 bronze badges

Comments

Jays · Accepted Answer · 2016-11-02 09:15:09Z

-2

Please check the connection string in web.config and see if it is valid.Also make sure that the SQL Server is already connected.

answered Nov 2, 2016 at 9:15

Jays

908 bronze badges

Collectives™ on Stack Overflow

Adding and using tables to DefaultConnection Database in ASP.NET MVC

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related