LINQ - From LINQ query to list - Asked By Partha Chakraborty on 14-Jul-11 06:18 AM

Hi,

I am trying to write a LINQ query which will retrieve data from Customers table and store selected data in a List<string>.

I have written the following code:

public List<string> FillGrid()

{
        LINQDALDataContext db = new LINQDALDataContext();
        List<string> query =

        from c in db.Customers

        where (c.Country == "USA"

            && c.City == "WA")

        select new { c.CustomerID, c.ContactTitle, c.Country, c,City};

        return query.ToList();

}

I am getting the error in select statement:
Cannot implicitly convert type 'System.Linq.IQueryable<AnonymousType#1>' to 'System.Collections.Generic.List<BusinessObjects.Customers>'. An explicit conversion exists (are you missing a cast?)

I have tried a lot.

Any help will be thankfully accepted.

Partha

      from c in db.Customers

      where (c.Country == "USA"

        && c.City == "WA")

      select new { c.CustomerID, c.ContactTitle, c.Country, c,City};

      return query.ToList();

I select statement you are returing more that one field, so that you have to store these file in any class object or var variable.

like this-

var result=

      from c in db.Customers

      where (c.Country == "USA"

        && c.City == "WA")

      select new { c.CustomerID, c.ContactTitle, c.Country, c,City};

      return query.ToList();

Hope this will help you.

public List<Customers> FillGrid()

{
      LINQDALDataContext db = new LINQDALDataContext();
      List<Customers> query =

      from c in db.Customers

      where (c.Country == "USA"

        && c.City == "WA")

      select new { c.CustomerID, c.ContactTitle, c.Country, c,City};

      return query.ToList();

}

Try and let me know.

To convert IQuerable or IEnumerable to a list, you can do one of the following:

IQueryable<object> q = ...; 
List<object> l = q.ToList(); 

or:

IQueryable<object> q = ...; 
List<object> l = new List<object>(q); 

Yes, I got it,

Mention the class name after new operator.


like this-

public List<Customers> FillGrid()