ASP.NET MVC Retrieve data with certain name

Question

I'm using a scaffold-ed index function to get all the data from the database.

// Scaffold-ed index():
public ActionResult Index()
{
    return View(db.Objects.ToList());
}

// Database tables:
[ObjectID] [Name]
1          Tree
2          Plant
3          Flower
4          Tree

Instead of all the objects, I only what the objects with a certain name (for example: tree). What is the best solution for this and should this be done with methods like db.Objects.Find(), Where(),.. or with a custom query?

Your question is unclear, and it looks more Linq and/or ORM related rather than an MVC question. — Matteo Mosca
– Matteo Mosca, Commented Jan 9, 2015 at 14:19
You can do that with LINQ, if you have a more complex query you can use a SP for that. Please, be more specific — Vsevolod Goloviznin
– Vsevolod Goloviznin, Commented Jan 9, 2015 at 14:20
It is a simple query, so can you give an example how to do this with LINQ? — user3231419
– user3231419, Commented Jan 9, 2015 at 14:21

Rajdeep Dosanjh · Accepted Answer · 2015-01-09 14:24:36Z

2

Linq is good for this the code needed would be

db.Objects.Where(o => o.Name == "Tree").ToList();

answered Jan 9, 2015 at 14:24

Rajdeep Dosanjh

1,1971 gold badge9 silver badges20 bronze badges

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

Collectives™ on Stack Overflow

ASP.NET MVC Retrieve data with certain name

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related