CODEWITHSUNDEEP
c#arraysstringlinqlinq-to-entities
thevan
thevan

Reputation: 10344

Linq records to string array

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?

Upvotes: 0

Views: 98

Answers (1)

NeddySpaghetti
NeddySpaghetti

Reputation: 13495

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();

Upvotes: 2

Related Questions