asp.net数据库查询数据

using System;
using System.Linq;
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 DbSet<Product> Products { get; set; }
}

public class ProductService
{
    private readonly ProductContext _context;

    public ProductService(ProductContext context)
    {
        _context = context;
    }

    public IEnumerable<Product> GetProductsByPrice(decimal minPrice, decimal maxPrice)
    {
        return _context.Products
            .Where(p => p.Price >= minPrice && p.Price <= maxPrice)
            .ToList();
    }
}

// 使用示例
public class HomeController : Controller
{
    private readonly ProductService _productService;

    public HomeController(ProductService productService)
    {
        _productService = productService;
    }

    public ActionResult Index()
    {
        var products = _productService.GetProductsByPrice(10, 100);
        return View(products);
    }
}