I'm trying to perform a simple LINQ query on the Columns property of a DataTable: from c in myDataTable.Columns.AsQueryable() select c.ColumnName However, what I get is this: Could not find an implementation of the query pattern for source type 'System.Linq.IQueryable'. 'Select' not found. Consider explicitly specifying the t...
Hello I am very frustrated from linq to sql when dealing with many to many relationship with the skip extension. It doesn't allow me to use joinned queries. Not sure it is the case for SQL server 2005 but I am currently using SQL Server 2000. Now I consider to write a store procedure to fetch a table that is matched by two tables e.g...
I found this question http://stackoverflow.com/questions/343899/how-to-cache-data-in-a-mvc-application and I'm wondering about being able to use this method with IQueryable data. Public Function GetUsers() As IQueryable(Of User) Implements IUserRepository.GetUsers Dim users = (From u In dc.Users Select ...
Hello, I need to query a winforms control(CheckedListBoxControl) having a CheckedListBoxItemCollection which I want to query for a certain Id that is within the property "Value" of the CheckedListBoxItem. CheckedListBoxItemCollection items = myCheckedListBoxControl.Items; foreach(Department dep in departmentList) { bool isDepExisti...