score:2
Accepted answer
var ordernumbers = new [] { 177828, 7115912 };
var query = (from c in contextm3.mpline
where c.ibsuno == supplier.m3code.trim() &&
ordernumbers.contains(convert.toint32(c.ibpuno))
// select etc...
Source: stackoverflow.com
Related Query
- LINQ: bad conversion from LINQ to sql query
- how to see generated sql from a linq query
- How to write linq query to match SQL like select top 100 * from tab?
- Extract sql query from LINQ expressions
- Linq to SQL - How to sort results from query
- Populate Excel with data from LINQ to SQL query
- Retrieve and print data from dynamic sql query with linq
- Getting SQL string from LINQ to EF query
- Pull data from multiple tables in one SQL query using LINQ and Entity Framework (Core)
- Getting single result from a query with anonymous types in Linq To Sql
- LINQ to SQL create query from string
- Load a DataGridView from LINQ to SQL query
- Linq query conversion from Ilist<> to List<>
- How to return list of items from linq to sql query and call it in a console application
- How to specify which columns can be returned from linq to sql query
- Updating LINQ to SQL but the query i have is from a join? Can't update using query that uses a join?
- LINQ query translate from SQL which uses subquery containing GROUP BY and COUNT
- how to convert from sql query to linq
- Conversion of Sql query to linq
- Retrieving Data From Multiple Tables in a LINQ to SQL query
- Programmatically getting executable SQL from a LINQ query at run-time
- How to prevent error conversion from DBNull value to Decimal in Linq query results
- How to write linq query from sql query using LINQ?
- Calling SQL scalar function from Linq Query
- SQL Query or Linq query to get No of Events per day from database
- How to return query results from method that uses LINQ to SQL
- How to use c# to perform summing data with type conversion from SQL using LINQ
- Linq query and Foreach on large number of records from SQL database
- Linq to SQL to return multiple counts from query not returning correct results
- SQL query shows good database values, but LINQ to Entity framework brings a null value from nowhere
More Query from same tag
- Group by with select new array using linq
- read xml file having namespace in root
- Get previous record to current one using LINQ
- Using a string where clause with PredicateBuilder in LinqPad for creating dynamic where clause
- Linq query filter with "contains" with list<T> multiple elements
- Nhibernate - partial loading of bags using LINQ
- Add more values to xml element
- LINQ - filtering a result set and joining the result set
- How to overcome null exception when using Linq Count to sort a stringlist?
- SQL Query Help: select random employee of the month
- Object not set to an instance of an object - LINQ WCF
- Most efficent way to select a collection of objects from DbContext
- Extract bits that are set into a HashSet<uint>?
- Resultant LinQ Query to a new DataTable
- NHibernate any array values are contained in a string does not work?
- Referencing DataRows by column name in a LINQ query, then filter via mapping with another dataset
- Remove all spaces in column data for entire table
- is there a better performance's way to get only few columns in ASP MVC without getting the whole table and filter it with LinQ?
- Scoreboard .txt scoreboard making for a tetris game
- Linq GroupBy multiple columns with Projection to new object
- Linq left join null reference error
- EPPlus and Linq To Excel Query all the rows
- Group users by age for a range
- How to add SelectMany to an Expression Tree with Expression.Call
- Avoiding duplicate code in Linq Select method
- Left Joins in LINQ with multiple Critieria?
- Selecting the value of a column not in GroupBy
- Summing a list by one property after filtering by another property
- Entity Framework generates inefficient SQL for paged query
- What is the underlying type of the result from a Linq to Entities query?