use parameters in LINQ?

[ricardoleme]

Hi People!

Can I use LINQ with parameters?

For example, in SQL it´s possible:

SELECT @colum1, @colum2
from @table

Let´s me see one example using Northwind Database

I have created one Linq to SQL Classe and put all the tables of Northwind like Region, Products and Customers.

I´m trying to do something like this:

Public Function createquery()
Dim db As New NorthWindLINQDataContext

Dim qr = From pro In db.Products _
Where pro.ProductID = 1 _
Select pro.ProductID, pro.ProductName
Return qr.ToList
End Function

If i use this form, it´s ok. But I´m interested in create one query with LINQ like this:

Dim qr = From pro In db.@parameter_table _
Where pro.@parameter_column = 1 _
Select pro.column1, pro.column2

It´s is possible?

Thank´s