CODEWITHSUNDEEP
c#listlinqiqueryable
klau
klau

Reputation: 67

Convert iQueryable to List

As a noobie, I'm trying to convert my LINQ query result to a List.

Error:

Can not implicitly convert type System.Collections.Generic.List<anonymous type: string fname, string lname> to System.Collections.Generic.List<ConsoleApp01.UserClass>

I've tried 

static public void TestSQLRx()
{
    using(UserAccessEntities db = new UserAccessEntities())
    {
        var userlist = from User in db.Users
                       select new
                       {
                           User.fname,
                           User.lname
                       };

        List<Userclass> usertype = new List<Userclass>();

        usertype = userlist.ToList();
    }
}

class Userclass //This is my Userclass class
{
    private string firstname;
    private string lastname;

    public string Firstname { get => firstname; set => firstname = value; }
    public string Lastname { get => lastname; set => lastname = value; }
}

Upvotes: 0

Views: 543

Answers (1)

Selim Yildiz
Selim Yildiz

Reputation: 5370

Just use Userclass instead of anonymous type.

var userlist = from User in db.Users
                       select new Userclass()
                       {
                           Firstname  = User.fname,
                           Lastname  = User.lname
                       };

Upvotes: 2

Related Questions