how sloved this error

Question

1.00/5 (1 vote)

See more:

iam us ethis query but see this error
LINQ to Entities does not recognize the method 'Int32 ToInt32(System.Object)' method, and this method cannot be translated into a store expression.
Line 57: var sumvotes = mainQuery.Sum(a => a.vp);

C#

var idQuery = from q in db.pollquestions where q.IsCurrent select q.PollID;
          var qpollid =db.pollquestions.Where(x=>x.IsCurrent==true).SingleOrDefault();
          var mainQuery = from p in db.pollOptions where idQuery.Contains(Convert.ToInt32(p.PollID)) select new { p.OptionID, p.PollID, p.QuestionText, vp = Convert.ToInt32(p.Votes) };
          var sumvotes = mainQuery.Sum(a => a.vp);

Posted 22-Feb-15 0:28am

saeed1364

Updated 22-Feb-15 0:38am

v2

Add a Solution

Comments

Richard MacCutchan 22-Feb-15 7:46am

Why are you trying to convert values to integers? They should already be stored in that way.

Maciej Los 29-Mar-15 7:00am

Can you provide sample data?

Maciej Los 29-Mar-15 7:03am

I think the main problem is in this line: var mainQuery = ... where idQuery.Contains(Convert.ToInt32(p.PollID)). You should compare values this way: idQuery.PollID == p.PollID

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Maciej Los · Answer 1 · 2015-03-29T01:14:00

Please, read my comments to the question.

I'd suggest to change your queries into single one:

C#

var qry = from pq in db.pollquestions.Where(x=>x.IsCurrent==true) 
          join po in db.pollOptions on pq.PollID equals po.PollID
          group po by po.PollID into grp
          select new
          {
              PollID = grp.Key,
              Question = grp.pq.QuestionText,
              SumVotes = grp.Sum(p=>p.Votes)
          };

Suvendu Shekhar Giri · Answer 2 · 2015-02-22T00:40:00

Solution 1

Try int.Parse() instead of Convert.ToInt32()

C#

var idQuery = from q in db.pollquestions where q.IsCurrent select q.PollID;
            var qpollid =db.pollquestions.Where(x=>x.IsCurrent==true).SingleOrDefault();
            var mainQuery = from p in db.pollOptions where idQuery.Contains(int.Parse(p.PollID.ToString())) select new { p.OptionID, p.PollID, p.QuestionText, vp = int.Parse(p.Votes.ToString()) };
            var sumvotes = mainQuery.Sum(a => a.vp);

Hope, it helps :)

Posted 22-Feb-15 0:40am

Suvendu Shekhar Giri

Comments

saeed1364 22-Feb-15 6:52am

The not correct answer
db.pollquestions.Where(x=>x.IsCurrent==true).SingleOrDefault();
Line 56: var mainQuery = from p in db.pollOptions where idQuery.Contains(Convert.ToInt32(p.PollID)) select new { p.OptionID, p.PollID, p.QuestionText, vp = int.Parse(p.Votes.ToString()) };
Line 57: var sumvotes = mainQuery.Sum(a => a.vp);

Suvendu Shekhar Giri 22-Feb-15 7:01am

Try with link provided in solution 2.

saeed1364 22-Feb-15 7:05am

Error 36 'int' does not contain a definition for 'Value' and no extension method 'Value' accepting a first argument of type 'int' could be found (are you missing a using directive or an assembly reference?)