Linq query to get results from DB in ASP.NET MVC 2

Question

How do I query using Ling to Entities.

I want to get back the total number of rows for a specific user.

I created a table with an ID(PK), Username, and PhoneNumber.

In my controller, I am able to do this and see my entities:

public ActionResult UserInfo()
        {
            using (UserInfoEntities db = new UserInfoEntities())
            {

            }
            return View();
        }

How do I query to return the total number of rows and declare it to a variable (totalrows) so that I can do thge following:

ViewData["TotalRows"] = totalrows

If there is a better way I am open to suggestions...

Thanks!!

Matthew Abbott · Accepted Answer · 2010-07-31 17:28:36Z

2

Probably something like:

int count = db.SomeTable.Where(r => r.Username.Equals("username")).Count();

answered Jul 31, 2010 at 17:28

Matthew Abbott

61.7k9 gold badges108 silver badges131 bronze badges

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

Comments

James Hull · Accepted Answer · 2010-07-31 17:33:36Z

1

Yep Matthew is right. The count method does exactly what you need! Although, I would recommend looking at ViewModels to pass your data to your view (rather than ViewData) and some kind of DAL pattern, such as the repository pattern, for querying your entities.

answered Jul 31, 2010 at 17:33

James Hull

3,6892 gold badges29 silver badges36 bronze badges

2 Comments

Mage Over a year ago

ViewModel? What do you mean? Putting this logic into my model?

James Hull Over a year ago

Basically the ideal goal is to have a strongly typed view. By creating a separate class - or model - and passing that to the view, your view is strongly typed to that model. See here asp.net/mvc/videos/… for a more complete explanation.

Collectives™ on Stack Overflow

Linq query to get results from DB in ASP.NET MVC 2

2 Answers 2

Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related