sql to linq

Question

1.00/5 (1 vote)

See more:

i have query

SELECT votingtext, COUNT(Votingtext) AS count FROM votes group by Votingtext

which gives me count of votes now i wnated to convert taht query to Linq so i write follwoing piece of code

XML

public List<Vote> GetChartData()
        {
            DataClasses1DataContext db = new DataClasses1DataContext();
            //SELECT votingtext, COUNT(Votingtext) AS count FROM votes group by Votingtext

            List<Vote> votes = GetAllVote();


            var query =
                 from c in votes
                 select new { c.VotingText, VoteCount = c.VotingText.Count() };

          //  return query.ToList(Vote); This line give me an error




        }

XML

public List<Vote> GetAllVote()
        {
            DataClasses1DataContext db = new DataClasses1DataContext();
            var query = from c in db.Votes  select c;
            //return query.Take(77).ToList();
            return query.ToList();

        }

i need to correct error mentioned in line

Posted 22-Sep-10 17:24pm

erummirza

Add a Solution

8 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)

MalikRizwan · Answer 1 · 2010-09-22T19:58:00

Solution 1

Can you post the exact error you are getting?

Posted 22-Sep-10 19:58pm

MalikRizwan

erummirza · Answer 2 · 2010-09-22T20:29:00

Solution 2

MSIL

C:\Users\Iram\Documents\Visual Studio 2008\Projects\VotingPanel2
\VotingPanel2.Web\Service3.svc.cs   37  33  VotingPanel2.Web</pre>

  C:\Users\Iram\Documents\Visual Studio 2008\Projects\VotingPanel2\VotingPanel2.Web\Service3.svc.cs   37  33  VotingPanel2.Web</pre>

Posted 22-Sep-10 20:29pm

erummirza

erummirza · Answer 3 · 2010-09-22T20:31:00

Solution 3

<pre lang="msil">Error   2   'VotingPanel2.Web.Vote' is a 'type' but is used like a 'variable'   C:\Users\Iram\Documents\Visual Studio 2008\Projects\VotingPanel2\VotingPanel2.Web\Service3.svc.cs   37  33  VotingPanel2.Web

MSIL

Error   1   No overload for method 'ToList' takes '1' arguments C:\Users\Iram\Documents\Visual Studio 2008\Projects\VotingPanel2\VotingPanel2.Web\Service3.svc.cs   37  20  VotingPanel2.Web

Posted 22-Sep-10 20:31pm

erummirza

Comments

MalikRizwan 23-Sep-10 4:13am

Hi Irum
use this
query.ToList<vote>();

please vote if it helps

MalikRizwan 23-Sep-10 4:14am

please ignore my last message
use this
query.ToList< Vote >();

with no spaces in between < >

MalikRizwan · Answer 4 · 2010-09-22T22:16:00

Solution 4

return query.ToList<Vote>();

vote if it helps

Posted 22-Sep-10 22:16pm

MalikRizwan

erummirza · Answer 5 · 2010-09-22T22:20:00

i m getting an error
Error 1 Instance argument: cannot convert from 'System.Collections.Generic.IEnumerable<anonymoustype#1>' to 'System.Collections.Generic.IEnumerable<votingpanel2.web.vote>' C:\Users\Iram\Documents\Visual Studio 2008\Projects\VotingPanel2\VotingPanel2.Web\Service3.svc.cs 37 20 VotingPanel2.Web

Error 2 'System.Collections.Generic.IEnumerable<anonymoustype#1>' does not contain a definition for 'ToList' and the best extension method overload 'System.Linq.Enumerable.ToList<tsource>(System.Collections.Generic.IEnumerable<tsource>)' has some invalid arguments C:\Users\Iram\Documents\Visual Studio 2008\Projects\VotingPanel2\VotingPanel2.Web\Service3.svc.cs 37 20 VotingPanel2.Web

when i changed

     public List<vote> GetChartData()<br />
        {<br />
            DataClasses1DataContext db = new DataClasses1DataContext();<br />
            //SELECT votingtext, COUNT(Votingtext) AS count FROM votes group by Votingtext<br />
            List<vote> votes = GetAllVote();<br />
<br />
            var query =<br />
                 from c in votes<br />
                 select new { c.VotingText, VoteCount = c.VotingText.Count() };<br />
            return query.ToList<vote>();<br />
<br />
<br />
        }<br />
</vote></vote></vote>

erummirza · Answer 6 · 2010-09-22T22:24:00

Error 1 Instance argument: cannot convert from 'System.Collections.Generic.IEnumerable<anonymoustype#1>' to 'System.Collections.Generic.IEnumerable<votingpanel2.web.vote>' C:\Users\Iram\Documents\Visual Studio 2008\Projects\VotingPanel2\VotingPanel2.Web\Service3.svc.cs 37 20 VotingPanel2.Web

Error 2 'System.Collections.Generic.IEnumerable<anonymoustype#1>' does not contain a definition for 'ToList' and the best extension method overload 'System.Linq.Enumerable.ToList<tsource>(System.Collections.Generic.IEnumerable<tsource>)' has some invalid arguments C:\Users\Iram\Documents\Visual Studio 2008\Projects\VotingPanel2\VotingPanel2.Web\Service3.svc.cs 37 20 VotingPanel2.Web

whne i chnaged it as suggested by u

erummirza · Answer 7 · 2010-09-23T01:52:00

I think u r saying this

C#

var query =
                from c in votes
                select new Vote  {c.VotingText, VoteCount = c.VotingText.Count() };

Error 1 Invalid initializer member declarator C:\Users\Iram\Documents\Visual Studio 2008\Projects\VotingPanel2\VotingPanel2.Web\Service3.svc.cs 35 36 VotingPanel2.Web

Error 2 'VotingPanel2.Web.Vote' does not contain a definition for 'VoteCount' C:\Users\Iram\Documents\Visual Studio 2008\Projects\VotingPanel2\VotingPanel2.Web\Service3.svc.cs 35 50 VotingPanel2.Web

erummirza · Answer 8 · 2010-10-12T20:14:00

can nay one else particapte on this problem

XML

public List<Vote> GetChartData()
     {



         DataClasses1DataContext db = new DataClasses1DataContext();
         //SELECT votingtext, COUNT(Votingtext) AS count FROM votes group by Votingtext

        
         var query3 = from c  in db.Votes
                      group c by c.VotingText into result
                      select new
                      {
                          Name = result.Key,
                          Count = result.Count()
                      };

         return query3.ToList<Vote>;




     }

error on last line return query3.ToList<Vote>;

sql to linq

8 solutions

Solution 1

Solution 2

Solution 3

Solution 4

Solution 5

Solution 6

Solution 7

Solution 8

Add your solution here

Preview 0