get rows count from database using MVC

Question

how can I get the count of records in the table users in the applicationContextcreatedin the mvc project?

this is what I have tried so far:

var context = new ApplicationDbContext();
var count = context.Users
.Where(o => Convert.ToInt32(o.Id) == 1)
.Count();

if (count < 3)
{

//do whatever

}

it's giving an error at the convert.ToInt32, and if I remove the convert it will give an error cannot implicity convert type 'string' to 'int' (o.Id) == 1)

what is going wrong?

Ehsan Sajjad · Accepted Answer · 2014-11-18 14:36:38Z

1

context.Users.Count() should work. Am I missing something obvious here?

edited Nov 18, 2014 at 14:36

Ehsan Sajjad

62.6k16 gold badges113 silver badges171 bronze badges

answered Nov 18, 2014 at 14:23

Siva Krishna Macha

711 gold badge2 silver badges7 bronze badges

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

Comments

JBB · Accepted Answer · 2014-11-18 14:41:18Z

1

Can you not just compare it as a string if thats what it is?

var context = new ApplicationDbContext();
var count = context.Users
.Where(o => o.Id == "1")
.Count();

answered Nov 18, 2014 at 14:41

JBB

6775 silver badges14 bronze badges

Collectives™ on Stack Overflow

get rows count from database using MVC

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