Cannot implicitly convert System.linq.iqueryable to system.collections

I am getting error - Cannot implicitly convert System.linq.iqueryable to system.collections.genericlist

public List GetList()
{
    var Result = from t in context.View_Header
                 where t.IsActive == true 
                 select new { t.ID, t.Name };

    return Result;
}

Thanks

You need to convert you resulted data into accurate format of return type: Check the following code and change accordingly:

static void Main(string[] args)
{
List EmpList = new List()
{
new Employee() { ID = 1, FirstName = "John", LastName = "Warner", Age = 18, IsActive = true }, new Employee() { ID = 2, FirstName = "Steve", LastName = "Jorg", Age = 21, IsActive = true } ,
new Employee() { ID = 3, FirstName = "Bill", LastName = "Peterson", Age = 32, IsActive = false}
};
var resultList = GetList(EmpList);
}
public static List GetList(List sampleList)
{
var Result = (from t in sampleList
where t.IsActive == true
select new customHeader { ID = t.ID, Name = t.LastName }).ToList();
return Result;
}
public class customHeader
{
public int ID { get; set; }
public string Name { get; set; }
}
public class Employee
{
public int ID { get; set; }
public string FirstName { get; set; }
public string LastName { get; set; }
public string Address { get; set; }
public int Age { get; set; }
public bool IsActive { get; set; }
}

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Muhammad Imran Ansari4y ago
Accepted answer
You need to convert you resulted data into accurate format of return type: Check the following code and change accordingly:
static void Main(string[] args)
{
        List EmpList = new List()
        {
          new Employee() { ID = 1, FirstName = "John", LastName = "Warner", Age = 18, IsActive = true },  new Employee() { ID = 2, FirstName = "Steve", LastName = "Jorg",  Age = 21, IsActive = true } ,
new Employee() { ID = 3, FirstName = "Bill", LastName = "Peterson",  Age = 32, IsActive = false}
                };
            var resultList = GetList(EmpList);
}

public static List GetList(List sampleList)
{
   var Result = (from t in sampleList
                where t.IsActive == true
select new customHeader { ID = t.ID, Name = t.LastName }).ToList();
   return Result;
}

public class customHeader
{
   public int ID { get; set; }
   public string Name { get; set; }
}

public class Employee
{
   public int ID { get; set; }
public string FirstName { get; set; }
public string LastName { get; set; }
public string Address { get; set; }
public int Age { get; set; }
public bool IsActive { get; set; }
}
+1