join queries in linq for three table in wp7

Question

0.00/5 (No votes)

See more:

i had created one web service as under

SQL

public List<String> ge()
   {
      var r = from c in db.Favourite_tbls
                join o in db.Menu_tbls on c.fk_menu_id equals o.pk_menu_id
               select new
               {
                   o.menu_name
               };
      return r.ToList();

   }

but it will give me error in return statement....
what should my return type..

Error:

cannot implicitly converts type system.collection.generic.list(annoymus type#1) to 
system.collection.generic.list(string)

Posted 25-Dec-11 22:03pm

jinalshah9999

Updated 25-Dec-11 22:27pm

v3

Add a Solution

1 solution

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)

Steve Maier · Answer 1 · 2012-04-11T10:25:00

The issue is really a Linq issue here and not a WP7 one. The query makes an anonymous type when you do the select new { ... } statement. This is not the same as the List<string> return type for the method.

You might be able to try changing the query like this...

SQL

public List<String> ge()
   {
      var r = from c in db.Favourite_tbls
                join o in db.Menu_tbls on c.fk_menu_id equals o.pk_menu_id
               select new String(o.menu_name);
      return r.ToList();

   }

You could also make a class that just had a string in it and use that as well. If you want a sample of that let me know.