How to insert the LINQ result to a string[] array

Question

I have a one dimensional string[] array as follows

string[] header = new string[30];

    public class GetList
    {
        public string ServerID;
        public string Name;

        public GetList(string sName, string cName)
        {
            this.ServerID = sName;
            this.Name = cName;
        }
    }

and I have a query which will return the list of server names and component names as follows

   var query = (from a in this.hmdb.Servers
                join b in this.hmdb.Components
                on a.ServerID equals b.ServerID
                select new { a.ServerID, b.Name});

how to insert the query result into the string[] header ?

EDIT

when i tried something like this

  var query = (from a in this.hmdb.Servers
                     where a.ServerID.Contains(match)
                     join b in this.hmdb.Components
                     on a.ServerID equals b.ServerID
                     select new
                         {
                             ID = a.ServerID,
                             Name = b.Name
                         }).ToArray();

I get the result as list of ServerID and Names

UPDATE

here is the explanation for the marked answer..

what's happening is that it will create a queryable/list of ServerID and Name then convert it to Enumerable and create a List of string using the .Select() extension and convert it to array of string select new { a.ServerID, b.Name } --> creates a list/iqueryable of anonymous type that has ServerID and Name properties..

AsEnumerable() --> convert it to Enumerable so we can use string.Format because SQL to LINQ doesn't support string.Format

Select(x => string.Format("{0} - {1}", x.ServerID, x.Name)) --> do a Select in order to create a list of String using the ServerID and Name

ToArray() --> simply convert it to a String[] there.

You have an array of string, but you deal with a GetList class. Doesn't match. Provide a way to convert a GetList object to string, or use an array of GetList objects. — ken2k
– ken2k, Commented Jun 14, 2013 at 10:24
I have removed the class and edited using only select new {} . kindly check .. — demo_user
– demo_user, Commented Jun 14, 2013 at 10:26

aiapatag · Accepted Answer · 2013-06-14 10:58:51Z

5

Try creating a new string and converting it to an array of string in your select.

   var query = (from a in this.hmdb.Servers
                join b in this.hmdb.Components
                on a.ServerID equals b.ServerID
                select new {a.ServerID, b.Name}).AsEnumerable().Select(x=> string.Format("{0} - {1}",x.ServerID, x.Name)).ToArray();

   string[] header = query;

edited Jun 14, 2013 at 10:58

answered Jun 14, 2013 at 10:31

aiapatag

3,43822 silver badges24 bronze badges

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

9 Comments

demo_user Over a year ago

thanks for the update, but i get the following exception as "LINQ to Entities does not recognize the method 'System.String Format(System.String, System.Object, System.Object)' method, and this method cannot be translated into a store expression" - NotSupportedException

demo_user Over a year ago

do I have to map the query to the header[] string ?

aiapatag Over a year ago

@demo_user yes, but im afraid that it could overflow since your array header has a limit of 30, why not just make it string[] header; and then header = query?

demo_user Over a year ago

yes, Ihave already made it like that.. but still i have the same error :( - Only parameterless constructors and initializers are supported in LINQ to Entities.

aiapatag Over a year ago

weird. it should work man. how about using anonymous type. look at my edit again @demo_user

|

ken2k · Accepted Answer · 2013-06-14 10:38:30Z

2

Only parameterless constructors and initializers are supported in LINQ to Entities.

Use:

....
on a.ServerID equals b.ServerID
select new GetList { ServerID = a.ServerID, Name = b.Name});

answered Jun 14, 2013 at 10:38

ken2k

49.2k12 gold badges119 silver badges179 bronze badges

2 Comments

demo_user Over a year ago

thanks @ken2k.. but should it be like this select new GetList (ServerID = a.ServerID, Name = b.Name)); ? and I still have an error on ServerID saying the Name ServerID does not exist in the current context, through I have defined in my class

demo_user Over a year ago

pls see my edit in the question. I get the list of IDs and Names. my concern is how to save this result in a string[] array? do i have to use foreach ?

Sachin · Accepted Answer · 2013-06-14 10:26:34Z

1

This will return an array of object GetList

 select new GetList(a.ServerID, b.Name)).ToArray();

if you want to return string array then choose the field which you want to return as array of string

 select new GetList(b.Name)).ToArray();

or

select new GetList(a.Server + b.Name)).ToArray();

answered Jun 14, 2013 at 10:26

Sachin

41.1k7 gold badges94 silver badges107 bronze badges

1 Comment

Lukas Winzenried Over a year ago

he wants to have a fixed size array with 30 items

Collectives™ on Stack Overflow

How to insert the LINQ result to a string[] array

3 Answers 3

9 Comments

2 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

9 Comments

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related