Chaining LINQ Query Bindings in LINQ to DataSet
I am trying to execute a query on the result of a query, but I get an error: "Method or operation not implemented." Can I program queries this way? For example, I have a DataSet with typical Northwind. I AM:
queryResult = From product In NorthWindDataSet.Products
Where (product.UnitsOnOrder > CInt(txtUnitsOnOrderFilter.Text))
Select product
Then I try to do
queryResult = From product In queryResult
Where (product.CategoryID = cboCategoryFilter.SelectedValue)
Select product
To finally use the query result as a binding source: ProductsBindingSource.DataSource = queryResult.AsDataView ()
How can i do this?
+2
source to share
1 answer
LINQ to SQL is probably complaining about CInt and SelectedValue calls in your queries. Try to grab these values outside of your query:
Dim units = CInt(txtUnitsOnOrderFilter.Text)
Dim catId = cboCategoryFilter.SelectedValue
queryResult = From product In NorthWindDataSet.Products
Where (product.UnitsOnOrder > units) AndAlso (product.CategoryID = catId)
Select product
0
source to share