Cannot implicitly convert type 'IQueryable<> to IQueryable

Question

I am trying to write a simple save and load operation using EDMX in Visual Studio 2008.

This is my load method:

    public static DataTable LoadData()
    {

    using (testEntities context = new testEntities())
      { 

              testEntities temp = new testEntities();
        DataTable dt = new DataTable();

       IQueryable<DataRow> empResults = (from c in temp.emplyee
                                          select c).AsQueryable();


       }


        return dt;
    }

However I receive the following error:

Cannot implicitly convert type 'System.Linq.IQueryable<>' to 'System.Linq.IQueryable'. An explicit conversion exists (are you missing a cast?)

I am not able to find any exact link for this conversion.

If you're using Linq-to-Entities, you don't need `DataTable` nor `SqlDataAdapter` by the way. — Dai, Apr 30 '14 at 08:09
possible duplicate of [convert linq query results to datatable C#](http://stackoverflow.com/questions/18608959/convert-linq-query-results-to-datatable-c-sharp) — Gert Arnold, Apr 30 '14 at 08:19

Veikedo · Answer 1 · 2014-04-30T08:16:39.233

0

Try this

 IQueryable<DataRow> empResults = (from c in temp.emplyee
                                   select c).Cast<DataRow>().AsQueryable();

But ensure that temp.emplyee is DataRow

So if you are using EF you need to use generated models and context, not adapters and dataTable

edited Apr 30 '14 at 08:16

answered Apr 30 '14 at 08:07

Veikedo

1,453
1
18
25

temp.employee is System.Data.Objects.ObjectQuery .I Updated my question – user3487944 Apr 30 '14 at 08:13

Andrew · Answer 2 · 2014-04-30T09:26:46.753

0

You cannot cast that directly, CopyToDataTable should help you though:

DataTableExtensions.CopyToDataTable<T> Method (IEnumerable<T>)

http://msdn.microsoft.com/en-us/library/bb396189.aspx

Or you can implement a custom method to populate DataRow columns with properties of you entity.

edited Apr 30 '14 at 09:26

answered Apr 30 '14 at 09:20

Andrew

3,648
1
15
29

Cannot implicitly convert type 'IQueryable<> to IQueryable

2 Answers2