具有 Entity Framework 和 OData 过滤选项的 Azure 函数

Question

是否可以在 Azure 函数 .net 中使用 Entity Framework 从 SQL 数据库检索数据并使用 OData 进行过滤？

private readonly TestScaffoldDbContext _dbContext;
public Function1(TestScaffoldDbContext dbContext)
{
    _dbContext = dbContext;
}

[FunctionName("TestReturn1")]
[EnableQuery]
public IQueryable<VmTest> Run(
    [HttpTrigger(AuthorizationLevel.Function, "get", "post", Route = null)] HttpRequest req,
    ILogger log)
{
    var features = req.ODataFeature();
    var builder = new ODataConventionModelBuilder();
    builder.EntitySet<VmTest>("VmTest");
    IEdmModel model = builder.GetEdmModel();
    return _dbContext.VmTests;
}

Answer 1

是的。可以在 Azure Functions 中实现 EF core 和 Odata 过滤。

EF core的实现请引用以下文章

https://dev.to/azure/using-entity-framework-with-azure-functions-50aa

https://markheath.net/post/ef-core-di-azure-functions#:~:text=Using%20Entity%20Framework%20Core%20on%20Azure%20Functions%20with,...%208%20Update%20Todo%20item%20...%20More%20items

对于 odata 实现，您可以使用 VS 市场中提供的以下软件包之一

https://marketplace.visualstudio.com/items?itemName=Unchase.unchaseodataconnectedservice

https://marketplace.visualstudio.com/items?itemName=marketplace.ODataConnectedService