3

I'm asking with my interest to learn:

Select * from Customer where CustomerId in(12,23,45);

Similarly is there any C#.Net Keyword for the same above?

Example: verify Date(month) not in Oct,Nov Dec. (not in SQL or LINQ)

I did it with Extension method( Ternary operator and || by verifying with month) I'm looking for simple way to verify, if exists.

LarsTech
  • 80,625
  • 14
  • 153
  • 225
Nash
  • 525
  • 3
  • 6
  • 24

3 Answers3

11

Threre is no keyword, however you can use the following construct:

using System.Linq;
...
(new [] {12, 23, 45}).Contains(customerID)
the_joric
  • 11,986
  • 6
  • 36
  • 57
1

No, there isn't but you can do something like:

bool contains = (new string[] {"Oct","Nov","Dec"}).Contains("Dec");
Icarus
  • 63,293
  • 14
  • 100
  • 115
0

You need to keep in mind though, that in querying SQL database there is one limitation though: set you're searching in can't be bigger than 2100 items, because each item is passed to sql server as separate parameter and SQL server allows max 2100 parameters per query. So unless you're sure that you won't have so many items in searchable set, I would suggest to use something like this.

Community
  • 1
  • 1
Giedrius
  • 8,430
  • 6
  • 50
  • 91