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
Reply to author
Sign in to reply to author
Forward
Sign in to forward
Delete
You do not have permission to delete messages in this group
Copy link
Report message
Show original message
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
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?