LINQ and "WHERE id IN (...)" clause

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hi there,

Is there an equivalent of "WHERE .. IN (...)" clause in LINQ when
querying a SQL database?

E.g. I have list of IDs and I need to get the corresponding table
records.

Thanks,
-Oleg.

.

Relevant Pages

  • Still waiting for help...
    ... contains rows from an SQL database table. ... I am not sure how to collect the ids. ... one to a hidden textbox, but I'm stumped on how to create ... beginning of the string and/or the end. ...
    (microsoft.public.frontpage.client)
  • update/delete form data to an SQL db
    ... an SQL database table. ... collect the ids. ... without ending up with a comma at the beginning of the string and/or the end. ...
    (microsoft.public.frontpage.client)
  • Re: Using ISNULL in an ADO Query for MS Jet database
    ... Val Mazur ... >I frequently use the ISNULL function when querying a SQL database like ... > I need to do the same sort of thing when querying an Access database via ...
    (microsoft.public.vb.database.ado)
  • Re: DataGrid, sort numeric column after parsing xml
    ... Visual Studio can generate one for you, of course you might need to edit schema types to what you want. ... There is LINQ to DataSet that allows you querying your DataSet. ... There is LINQ to XML that allows querying an XML document but for that you need to load the XML document into a System.Xml.Linq.XDocument and there is no connection between a DataSet and an XDocument. ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: LINQ and "WHERE id IN (...)" clause
    ... querying a SQL database? ... Yes, this is backwards, but it's how the Linq designers thought ... better IMHO because it would be more natural for people who know SQL. ... SELECT CustomerID FROM Customers WHERE Country = @country ...
    (microsoft.public.dotnet.framework)