WHere do I find database entity reference?

Question

I have created a database entity to an existing SQL DB.

But query does not return the data I am expecting

namespace WebApplication5.Controllers
{
    public class EmployeeController : Controller
    {
        // GET: Employee
        public ActionResult Index()
        {
            List<string> orderIDs = new List<string>();

            using (var db = new WebApplication5.Models.BTP_NYAEntities())
            {
                var query = from b in db.FilledOrders
                            select b;

                //Console.WriteLine("All blogs in the database:");
                foreach (var item in query)
                {
                    //Console.WriteLine(item.OrderID);
                    orderIDs.Add(item.OrderID.ToString());
                }
            }

            ViewData["MyData"] = orderIDs;

            return View(orderIDs);
        }
    }
}

View:

@{
    Layout = null;
}

<!DOCTYPE html>

<html>
<head>
    <meta name="viewport" content="width=device-width" />
    <title>Employee Index Page</title>
</head>
<body>
    <div>
    <h1>Employee Index Page</h1>
        @{ 
            var categories = (List<string>)ViewData["MyData"];

                foreach(var item in categories)
                {
        <p>This is a test emp index page @item</p>

                }



        }
    </div>
</body>
</html>

The whole point of MVC is to separate your concerns. The View should only be concerned with rendering a UI. Have your controller call out to a database layer that retrieves the relevant entities and store them in model objects. Pass those model objects to the view from the controller. In any case, your question is incomplete. You'll need to show the declaration for BTP_NYAEntities. Read over MCVE so that you know what to include in your question next time. — mason
– mason, Commented Oct 27, 2016 at 13:23
@ManInMoon Is BTP_NYAEntities in the same MVC project or separate one? Also try searching across solution with that name. If you can find then, check the namespace defined in that file above class name and use that namespace with using MyNamespace; on top of file where you want to use it. — Siva Gopal
– Siva Gopal, Commented Oct 27, 2016 at 13:28

Community · Accepted Answer · 2017-05-23 12:06:43Z

1

you should not be calling the DB from the View. call this function in the controller action or in a business logic and then pass the list to the view using the viewbag

follow the methods in this Question

edited May 23, 2017 at 12:06

CommunityBot

11 silver badge

answered Oct 27, 2016 at 13:18

Mhand7

5371 gold badge3 silver badges21 bronze badges

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

5 Comments

ManInMoon Over a year ago

OK. I have moved it to the controller. But it still cannot see BTP_NYAEntities. And in the example he uses db.Invoices, but again db is not known in my controller.

Mhand7 Over a year ago

from what I get, you followed the 3rd answer, instead of db you use your db context which is in your case BTP_NYAEntities. and then as you see that in the view you have to include the model that you want to use inside the view using @model

Mhand7 Over a year ago

what is the problem, is it not returning the anything, giving you errors, or it does return some data but not what you expect ?

ManInMoon Over a year ago

There is no error, but there is no data collection of rows or items, so the foreach loop does not get entered. But I can see there is actually data in table

ManInMoon Over a year ago

Acutually I found the error. I have different Shemas and FilledOrders exists in 2 different Schemas. When building the connection VS seems to have renamed theses table as FilledOrders ad FIlledOrders1. I was looking at the wrong one... How can I specify the Schema name from within the Controller?

Collectives™ on Stack Overflow

WHere do I find database entity reference?

1 Answer 1

5 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related