Using Regex

To return only documents that match regular expression, use the Regex method which enables RavenDB to perform server-side pattern matching queries.

The supplied regular expression must be .NET compatible.

Example

// loads all products, which name
// starts with 'N' or 'A'
List<Product> products = session
    .Query<Product>()
    .Where(x => Regex.IsMatch(x.Name, "^[NA]"))
    .ToList();
// loads all products, which name
// starts with 'N' or 'A'
List<Product> products = await asyncSession
    .Query<Product>()
    .Where(x => Regex.IsMatch(x.Name, "^[NA]"))
    .ToListAsync();
from Products 
where regex(Name, '^[NA]')