如何在Asp.Net核心剃刀页面项目中使用OData

services.AddOData();

app.UseEndpoints(endpoints =>
{
    endpoints.MapControllers();
    endpoints.EnableDependencyInjection();
    endpoints.Select().Filter().OrderBy().Count().MaxTop(100);
    endpoints.MapODataRoute("odata", "odata", GetEdmModel());
});

[ODataRoutePrefix("Products")]
public class ProductsController : ODataController
{
    private readonly MyDbContext _context;

    public ProductsController(MyDbContext context)
    {
        _context = context;
    }

    [EnableQuery]
    [HttpGet]
    public IActionResult Get()
    {
        return Ok(_context.Products);
    }

    [EnableQuery]
    [HttpGet("{key}")]
    public IActionResult Get(int key)
    {
        return Ok(_context.Products.FirstOrDefault(p => p.Id == key));
    }

    // 其他操作方法...
}

services.AddDbContext<MyDbContext>(options =>
    options.UseSqlServer(Configuration.GetConnectionString("DefaultConnection")));

public class MyODataModel : EdmModel
{
    public MyODataModel()
    {
        var products = new EntityType("Namespace", "Product");
        products.AddKeys(products.AddStructuralProperty("Id", EdmPrimitiveTypeKind.Int32));
        products.AddStructuralProperty("Name", EdmPrimitiveTypeKind.String);
        products.AddStructuralProperty("Price", EdmPrimitiveTypeKind.Decimal);
        products.AddStructuralProperty("Category", EdmPrimitiveTypeKind.String);

        var container = new EntityContainer("Namespace", "Container");
        container.AddEntitySet("Products", products);

        AddElement(container);
    }
}

services.AddSingleton<MyODataModel>();

"ConnectionStrings": {
  "DefaultConnection": "Server=(localdb)\\mssqllocaldb;Database=MyDatabase;Trusted_Connection=True;MultipleActiveResultSets=true"
}