Where Expressions

client.Search<TGrain>()
    .Where(x => /* predicate */)

// String equality
.Where(u => u.Email == "alice@example.com")
 
// Boolean equality
.Where(u => u.IsActive == true)
 
// Numeric equality
.Where(p => p.Price == 99.99m)

// Case-sensitive substring match
.Where(u => u.Email.Contains("@example.com"))
.Where(p => p.Name.Contains("laptop"))

.Where(u => u.Email.StartsWith("admin"))
.Where(p => p.Category.StartsWith("elect"))

.Where(u => u.Email.EndsWith(".com"))
.Where(p => p.Name.EndsWith("Pro"))

.Where(p => p.Price > 100.00m)
.Where(p => p.Price < 500.00m)

.Where(p => p.Price >= 100.00m)
.Where(p => p.Price <= 500.00m)

.Where(p => p.Price >= 100.00m && p.Price <= 500.00m)

// Orders in the last 7 days
.Where(o => o.CreatedAt > DateTime.UtcNow.AddDays(-7))
 
// Orders in a date range
.Where(o => o.CreatedAt >= startDate && o.CreatedAt <= endDate)

// Active users
.Where(u => u.IsActive == true)
 
// Out of stock products
.Where(p => p.InStock == false)

.Where(p => p.InStock == true && p.Price < 100.00m)
.Where(u => u.IsActive == true && u.Email.Contains("@example.com"))

.Where(u => u.Status == "active" || u.Status == "pending")
.Where(p => p.Category == "electronics" || p.Category == "computers")

// Products that are either:
// - In stock and under $100
// - In the "clearance" category
.Where(p =>
    (p.InStock == true && p.Price < 100.00m) ||
    p.Category == "clearance"
)
 
// Users who are active AND either admin or moderator
.Where(u =>
    u.IsActive == true &&
    (u.Role == "admin" || u.Role == "moderator")
)

// These are equivalent:
.Where(p => p.InStock == true && p.Price < 100.00m)
 
.Where(p => p.InStock == true)
.Where(p => p.Price < 100.00m)

string domain = "@example.com";
var users = await client.Search<IUserGrain>()
    .Where(u => u.Email.Contains(domain))
    .ToListAsync();
 
decimal minPrice = 100.00m;
decimal maxPrice = 500.00m;
var products = await client.Search<IProductGrain>()
    .Where(p => p.Price >= minPrice && p.Price <= maxPrice)
    .ToListAsync();

// Find users without a display name
.Where(u => u.DisplayName == null)
 
// Find users with a display name
.Where(u => u.DisplayName != null)