Datatable does not contain a definition for AsEnumerable LinqBridge

294 views
Skip to first unread message

amns

unread,
Oct 6, 2010, 9:56:24 AM10/6/10
to LINQBridge
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.
Reply all
Reply to author
Forward
0 new messages