How to convert LINQ query result to List

Question

I need to convert linq query result to list  I tried the following code   var qry   from a in obj tbCourses                      select a   List lt course gt  lst   new List lt course gt     lst   qry ToList      The following error occurred for the above code    Cannot implicitly convert type  System Collections Generic List lt Datalogiclayer tbcourse gt  to System Collections Generic List lt course gt

User · Accepted Answer

No need to do so much works    var query   from c in obj tbCourses         where             select c    Then you can use   List lt course gt  list course  query ToList lt course gt       It works fine for me

User · Answer

You need to use the select new LINQ keyword to explicitly convert your tbcourseentity into the custom type course  Example of select new   var q   from o in db Orders         where o Products ProductName StartsWith  Asset    amp  amp                 o PaymentApproved    true         select new   name     o Contacts FirstName                                       o Contacts LastName                        product   o Products ProductName                        version   o Products Version                                   o Products SubVersion   0 1                          http   www hookedonlinq com LINQtoSQL5MinuteOverview ashx

User · Answer

What you can do is select everything into a new instance of Course  and afterwards convert them to a List   var qry   from a in obj tbCourses                      select new Course                              Course Property   a Property                                                       qry toList lt Course gt

User · Answer

You need to somehow convert each tbcourse object to an instance of course  For instance course could have a constructor that takes a tbcourse  You could then write the query like this   var qry   from c in obj tbCourses           select new course c    List lt course gt  lst   qry ToList

User · Answer

List lt course gt     from c in obj tbCourses                  select                  new course c   toList      You can convert the entity object to a list directly on the call  There are methods to converting it to different data struct  list  array  dictionary  lookup  or string

[linq] How to convert LINQ query result to List?

Examples related to linq

Examples related to tolist