Linq records to string array

Question

This is my LINQ:

var context = new CYGNETEntities();
var users = (from u in context.mUsers
             where u.userName == EmailID && u.password == Password
             select new 
             { 
                 u.userName,  
                 u.firstName,  
                 u.lastName  
             })
    .AsEnumerable()
    .Select(x => string.Format("{0}, {1}, {2}", x.userName, x.firstName, x.lastName))
    .ToArray();

Here, the actual values are below:

   u.userName = "admin"
   u.firstName = "fname"
   u.lastName = "lname"

So, the linq returns as below:

users[0] = admin, fname, lname

But I want the linq records in string array such as below:

   users[0] = admin
   users[1] = fname
   users[2] = lname

Any suggestions please?

You can split the users array by comma, and you will get your result. — NewbieProgrammer
– NewbieProgrammer, Commented Oct 15, 2015 at 11:49
this has to be a 2-dimensional array in case that you have 2 results with the same EmailID and Password — fubo
– fubo, Commented Oct 15, 2015 at 11:49

NeddySpaghetti · Accepted Answer · 2015-10-15 11:51:05Z

2

I haven't tested this, but what about:

var users = (from u in context.mUsers
              where u.userName == EmailID && u.password == Password
              from s in new string [] { u.username, u.FirstName, u.LastName }
              select s).ToArray();

answered Oct 15, 2015 at 11:51

NeddySpaghetti

13.6k5 gold badges35 silver badges63 bronze badges

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

1 Comment

Enigmativity Over a year ago

He's using a SelectMany, so he needs the .ToArray().

Collectives™ on Stack Overflow

Linq records to string array

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related