How to run a count in Entity Framework

Question

I have a Real Estate site with a Properties table and a PropertyImages table. When the user uploads a picture, I want to run a query in the PropertyImages. then append that number to the picturename.

    public IQueryable GetPictureCount()
   {
     int propertyId = Convert.ToInt16(ddlSelectProperty.SelectedValue);
     var _db = new RESolution.Models.PropertyContext();
     IQueryable query = _db.PropertyImages;

    var mypic = (from c in _db.PropertyImages
                where c.PropertyID == propertyId
                select c).FirstOrDefault();
            lblCount.Text = Convert.ToString(query);
    }

I get this error: "Not all code paths return a value"

My environment is as follows:

VS Express 2013
Sql Express 
win 8.1 development computer

when I change IQuaryable to "void" I get the error

'lblCount.text = query.Count().ToString();' System.Linq.IQueryable does not contain a definition for 'Count' I have looked for a using directive but found non

You have to invoke the query and print the result: lblCount.text = query.Count().ToString(); — Roberto Conte Rosito
– Roberto Conte Rosito, Commented Nov 17, 2014 at 15:43
Since your method is called GetPictureCount, and because it is declared as returning IQueryable, there needs to be a return statement somewhere. If you use your method for its side effects, replace IQueryable with void to fix the error. — Sergey Kalinichenko
– Sergey Kalinichenko, Commented Nov 17, 2014 at 15:47

Mike Alberga · Accepted Answer · 2014-11-19 13:26:54Z

1

I am still a little confused, though you guys are a god send. Here is where I was able to get to work.

public void GetPictureCount() {

        lblfnameCheck.Text = ddlSelectProperty.SelectedValue;
        int propertyId = Convert.ToInt32(lblfnameCheck.Text);
        var _db = new RESolution.Models.PropertyContext();

        var count = _db.PropertyImages.Count(t => t.PropertyID == propertyId);
        lblCount.Text = Convert.ToString(count);

    }

answered Nov 19, 2014 at 13:26

Mike Alberga

294 bronze badges

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

Comments

Bob Lokerse · Accepted Answer · 2014-11-17 16:55:13Z

0

As dasblinkenlight mentioned, it seems that you do not want to return something, so make the method a void. You probable want something like this:

public void GetPictureCount()
{
   int propertyId = Convert.ToInt16(ddlSelectProperty.SelectedValue);
   var _db = new RESolution.Models.PropertyContext();
   IQueryable query = _db.PropertyImages;

   var mypic = (from c in _db.PropertyImages
            where c.PropertyID == propertyId
            select c).FirstOrDefault();

   var nrOfPics = Convert.ToString(query.Count());
   lblCount.Text = nrOfPics;
   mypic.name = mypic.name + nrOfPics; // I am guessing the name property

  _db.SaveChanges();
}

answered Nov 17, 2014 at 16:55

Bob Lokerse

4536 silver badges23 bronze badges

1 Comment

Mike Alberga Over a year ago

var nrOfPics = Convert.ToString(query.Count()); shows an error that IQueryable does not contain a definition 'Count' also the following has runtime error int propertyId = Convert.ToInt16(ddlSelectProperty.SelectedValue);

Collectives™ on Stack Overflow

How to run a count in Entity Framework

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related