Cannot convert type 'AnonymousType#1' to 'string'

Question

0.00/5 (No votes)

See more:

This is my code in the down

SQL

var brand_qry = (from pd in SvarkWindow.prodlist
                                    join pu in SvarkWindow.produnitslist on pd.Product_id equals pu.Product_id
                                    where pu.position > 0
                                    select new { FullName = pd.Product_name + " " + pd.Manufacturer }).Distinct().ToList();

C#

foreach (string item in brand_qry)
               {
                   if (!string.IsNullOrEmpty(Search_txt.Text))
                   {
                       if (item.StartsWith(typedString, StringComparison.CurrentCultureIgnoreCase))
                       {
                           autoList.Add(item);
                       }
                   }
               }

i am getting error as
Cannot convert type 'AnonymousType#1' to 'string'

please help me out of this.

Posted 21-Jul-15 0:30am

Abdul Imran

Updated 21-Jul-15 1:00am

Thomas Daniels

v2

Add a Solution

2 solutions

Solution 2

brand_qry is a collection of anonymous types that contain a FullName property, not a collection of strings.

If you want brand_qry to be a collection of strings, then replace your select statement by this:

C#

select pd.Product_name + " " + pd.Manufacturer

Or, if you actually want the collection of anonymous types, but still want to iterate over the FullNames, then change your foreach statement into this:

C#

foreach (string item in brand_qry.Select(x => x.FullName))

The above statement uses the Select method to select all FullNames from brand_qry.

Posted 21-Jul-15 0:50am

Thomas Daniels

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)

OriginalGriff · Accepted Answer · 2015-07-21T00:49:00

Well - you can't!
You are creating an collection of new items - which are a class that exists only as part of the Linq query, and which has a single string property "Fullname". That isn't a string!

So change the Linq:

C#

var brand_qry = (from pd in SvarkWindow.prodlist
                 join pu in SvarkWindow.produnitslist on pd.Product_id equals pu.Product_id
                 where pu.position > 0
                 select pd.Product_name + " " + pd.Manufacturer).Distinct().ToList();

Which will create a List<string>

This is one reasons why I don't like using var that much - it isn't clear what you expect to get.
I would have written that as:

C#

List<string> brand_qry = (from pd in SvarkWindow.prodlist
                          join pu in SvarkWindow.produnitslist on pd.Product_id equals pu.Product_id
                          where pu.position > 0
                          select pd.Product_name + " " + pd.Manufacturer).Distinct().ToList();