Core Concepts > Basic Queries
In
Results can be filtered by using the In
method of a field expression while composing a query.
This example selects records where the value matches one of the items in the list:
IEnumerable<Purchase> purchases = db.SelectMany<Purchase>()
.From(dbo.Purchase)
.Where(
dbo.Purchase.PaymentMethodType.In(
PaymentMethodType.CreditCard,
PaymentMethodType.ACH,
PaymentMethodType.PayPal
)
)
.Execute();