How can I create a List off of an Entity Framework entity (object)?

Question

Can I use the Entity Framework Model to allow me to create a list off of an existing table (entity)? If so I just can't figure out how to do that?

So for instance if I have a table in my DB called Order and that has been added to Entity Framework can I use the Entity Framework model to generate a List of Objects?

using SQL Server 2008 R2 and Visual Studio 2010

var orderContext = new OrderEntities();

var order = orderContext.Order;

List<order> ordersList = new List<order>();

That would be cool if I could.

Thanks,

S

Your question is not clear enough for me. Are you asking to retrieve rows out of the database as entity objects? — Erik Philips
– Erik Philips, Commented Dec 9, 2011 at 0:33

Rohan West · Accepted Answer · 2011-12-09 00:33:48Z

3

Make sure that you are using System.Linq, you should be able to do the following. Presuming that Order is a ObjectSet.

using System.Linq;

Then use the ToList extension method.

IList<Order> orders = orderContext.Order.ToList();

answered Dec 9, 2011 at 0:33

Rohan West

9,3083 gold badges40 silver badges66 bronze badges

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

Comments

Slovo · Accepted Answer · 2011-12-09 05:20:43Z

0

"order" its a variable, you must create List for Type as:

List<Order> list = new List<Order>();

And then you can:

list = _context.Order.ToList();

(need using System.Linq)

answered Dec 9, 2011 at 5:20

Slovo

2222 silver badges12 bronze badges

Collectives™ on Stack Overflow

How can I create a List off of an Entity Framework entity (object)?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related