Select all fields from table using Entity Framework

Question

In the code below all of the fields are returned from the tables except for fields that are foreign keys. How do I get the foreign key fields to display? I just want an equivalent to select * from tableName.

        public ActionResult ShowAllTables() 
    {


        var model = new CSLA_StagingModel()
        {

            depots = db.CSLA_DEPOT.Where(c => c.DEPOT_ID == 10065).ToList<CSLA_DEPOT>(),
            addresses = db.CSLA_ADDRESS.Where(a => a.CSLA_DEPOT.DEPOT_ID == 10065).ToList<CSLA_ADDRESS>(),
        };


        return View(model);

    }

note: I'm using vs2008

EDIT: I think I might use Linq to SQL until I get VS2010

Craig Stuntz · Accepted Answer · 2010-10-27 20:59:09Z

1

There is no SELECT *.

You can, however, project the IDs:

var q = from a in db.CSLA_ADDRESS
        select new
        {
            ADDRESS_ID = a.ADDRESS_ID,
            DEPOT_ID = a.CSLA_DEPOT.DEPOT_ID,
            // etc.
        };

answered Oct 27, 2010 at 20:59

Craig Stuntz

127k12 gold badges257 silver badges275 bronze badges

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

Comments

Morteza Manavi · Accepted Answer · 2010-10-27 21:03:32Z

1

In Entity Framework 3.5 and VS 2008, foreign keys are hided under their Navigation properties (aka Independent Association) and are not directly accessible through the target entity object. So in order to access them you need to do it through their navigation properties (e.g. CSLA_DEPOT) like the code Craig has posted.

answered Oct 27, 2010 at 21:03

Morteza Manavi

33.2k6 gold badges103 silver badges84 bronze badges

Comments

Slappy · Accepted Answer · 2010-10-27 23:07:18Z

0

I would add the FK field as a scaler property on the entity. If this FK VALUE holds business meaning then there is nothing wrong with adding it to your conceptual model. This will also make the code discrete and readable.

answered Oct 27, 2010 at 23:07

Slappy

4,1022 gold badges33 silver badges42 bronze badges

Collectives™ on Stack Overflow

Select all fields from table using Entity Framework

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related