Datatable does not contain a definition for AsEnumerable LinqBridge

[A.]

Hi, i'm trying to use linq in c#2.0(linqbridge) to search for a patient name in my database, but i'm getting the following errors: System.Data.Datatable does not contain a definition for AsEnumerable() System.Data.Datatable does not contain a definition for CopyToDataTable()

I added the linqBridge.dll reference to my project. And i'm using:

using System.Linq;

            List<string> names = name.Split(' ').ToList();
            SqlConnection con = new SqlConnection(m_connection_string);
            SqlDataAdapter da = new SqlDataAdapter("SELECT * FROM PATIENT", con);
            DataSet ds = new DataSet();
            da.Fill(ds);

            var query =
            from pat in ds.Tables["PATIENT"].AsEnumerable().Where(c => names.All(val => c.PAT_SEARCH_NAME.Contains(val)))
            select pat;

            DataTable table = query.CopyToDataTable();

What am i doing wrong? I already read that this version of LinqBridge(1.1) does not contain this methods.. Is there a way to solve this?

Thanks.

[Damyan Bogoev]

Hello A.,

I prepared a sample application which demonstrates how to achieve this goal. I implemented extension methods for the missing functionality because the project targets .NET Framework 2.0. Both of the AsEnumerable and CopyToDataTable methods are supported in .NET Framework 3.5 and 4.0.
Additional information regarding the extensions methods can be found here.
Hope you will find the prepared application and provided information useful.

Regards,
Damyan Bogoev
the Telerik team

[A.]

Thanks for your reply.
I will look to yoursample application.Thanks.

Regards.