ASP.NET MVC Entity Framework DB access in Controller

Question

I am trying to access the DB I created to display a list. I am doing this in my controller. It is red underlining the db part. It is saying "The name db does not exist in the current context." Am I missing some thing to connect to the db in my code?

using System.Web;
using System.Web.Mvc;
using System.IO;
using System.Web.Helpers;
using MIS424Assignments.Models;

namespace MIS424Assignments.Controllers
{
    [Authorize (Users="[email protected]")]
    public class RetailController : Controller
    {
        // GET: Retail
        [AllowAnonymous]
        public ActionResult Index()
        {             
                string sql = "Select * from Product order by newid()";
                List<Product> productList = db.Product.SqlQuery(sql).ToList();
                return View();
        }
    }
}

You will have to execute the query under your DBContext. Learn more about Entity framework here entityframeworktutorial.net/EntityFramework4.3/… — Ranjith V
– Ranjith V, Commented Apr 14, 2017 at 16:56
You have not initialized db. Please initialize your database to db and try. Post your result so that we can answer you better. — Naveen K N
– Naveen K N, Commented Apr 14, 2017 at 17:00

Naveen K N · Accepted Answer · 2017-04-14 17:07:11Z

2

Try this

[Authorize (Users="[email protected]")]
public class RetailController : Controller
{

     private readonly RetailStoreEntities1 db;
    public RetailController()
    {
        db = new RetailStoreEntities1();
    }

    // GET: Retail
    [AllowAnonymous]
    public ActionResult Index()
    {             
            string sql = "Select * from Product order by newid()";
            List<Product> productList = db.Product.SqlQuery(sql).ToList();
            return View();
    }
}

answered Apr 14, 2017 at 17:07

Naveen K N

1801 silver badge12 bronze badges

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

Comments

BasicIsaac · Accepted Answer · 2017-04-14 17:12:13Z

0

Somebody here is bound to suggest to do all your DB Access from a repository, and invoke the repository methods from your controller. However, to quickly answer your question. Your project should include a class with your context

public class MyContext: DbContext
{
public MyContext()
     : base("myconnstringinwebconfig")
{}
//more stuff here, maybe your entities.    
}

and somewhere near the top of your controller, there should be a line that will initialize your context:

private MyContext db = new MyContext();

and that will fix your error message.

answered Apr 14, 2017 at 17:12

BasicIsaac

1878 bronze badges

Comments

score 0 · Accepted Answer · 2017-04-14 17:53:50Z

0

I don't see the connection string. Could that be the problem? If you are using EF, did you configured the connection string in your webconfig.

I used to get burned on that one when I first started with EF :-D

***UPDATE **** The code below would go within your Context Class as the constructing sub.

Let me know if it helps

public YourContextClass() : base("RetailStoreEntities1") {

edited Apr 14, 2017 at 17:53

answered Apr 14, 2017 at 16:55

user7297973

4 Comments

Timothy Wong Over a year ago

I have <add name="RetailStoreEntities1" connectionString="metadata=res://*/RetailStoreModel.csdl|res://*/RetailStoreModel.ssdl|res://*/RetailStoreModel.msl;provider=System.Data.SqlClient;provider connection string="data source=(LocalDB)\v11.0;attachdbfilename=|DataDirectory|\RetailStore.mdf;integrated security=True;multipleactiveresultsets=True;application name=EntityFramework"" providerName="System.Data.EntityClient" /> in my web config

user7297973 Over a year ago

Are you passing the ConnectionString name "RetailStoreEntities1" to your DB Context?

user7297973 Over a year ago

I will append a sample to my original post ;-)

user7297973 Over a year ago

@BasicIsaac answer is in a nutshell :-)

Collectives™ on Stack Overflow

ASP.NET MVC Entity Framework DB access in Controller

3 Answers 3

Comments

Comments

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related