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();
Previous
Having

© 2024 dbExpression. All rights reserved.