Entity Framework – attribute IN Clause usage

by 
int[] ids = new int[]{1,2,3,45,99};
using (DatabaseEntities db = new DatabaseEntities ())
{
    return db.Licenses.Where(
        i => i.license == mylicense 
           && ids.Contains(i.number)
        ).ToList();
}

should work

More Related Contents:

  1. How to Create a real one-to-one relationship in SQL Server
  2. Where is |DataDirectory| defined?
  3. Entity Framework VS LINQ to SQL VS ADO.NET with stored procedures? [closed]
  4. Solution for: Store update, insert, or delete statement affected an unexpected number of rows (0) [closed]
  5. How do I use structural annotations to set SQL type to Date in model first approach
  6. SQL to Entity Framework Count Group-By
  7. Is it possible to run native sql with entity framework?
  8. The object ‘DF__*’ is dependent on column ‘*’ – Changing int to double
  9. Entity Framework Skip/Take is very slow when number to skip is big
  10. Current date in Oracle Db
  11. How do I UPDATE from a SELECT in SQL Server?
  12. Optimize GROUP BY query to retrieve latest row per user
  13. INNER JOIN vs LEFT JOIN performance in SQL Server
  14. Equals(=) vs. LIKE
  15. Function vs. Stored Procedure in SQL Server
  16. Check if value exists in Postgres array
  17. How to check if a stored procedure exists before creating it
  18. Reference alias in WHERE clause
  19. update one table with data from another
  20. Generate a range of dates using SQL
  21. Generate Delete Statement From Foreign Key Relationships in SQL 2008?
  22. SQL primary key: integer vs varchar
  23. Why does SQL Server round off results of dividing two integers?
  24. Is it necessary to create tables each time you connect the derby database?
  25. SQL Server: should I use information_schema tables over sys tables?
  26. SQL Server Cumulative Sum by Group
  27. How to handle optional parameters in SQL query?
  28. How to create a Date in SQL Server given the Day, Month and Year as Integers
  29. Count records for every month in a year
  30. Postgres: convert single row to multiple rows (unpivot)

Leave a Comment