Listfruits = new List {"apple", "banana", "orange"}; var fruitsQueryable = fruits.AsQueryable(); var filteredFruits = fruitsQueryable.Where(f => f.StartsWith("a"));
using System.Data.Entity; public class Product { public int Id { get; set; } public string Name { get; set; } public decimal Price { get; set; } } public class ProductContext : DbContext { public DbSetThe above example creates a Product class and a ProductContext class that derives from DbContext in Entity Framework. It then retrieves all the products from the database as a queryable object using AsQueryable(). It then performs a query on the queryable object to get all the products with a price greater than 100. The result is stored in the expensiveProducts variable. Package Library: System.Linq, Microsoft.EntityFrameworkCore (for Example 2)Products { get; set; } } //... var context = new ProductContext(); var productsQueryable = context.Products.AsQueryable(); var expensiveProducts = productsQueryable.Where(p => p.Price > 100);