Azure Easy Tables是否支持关系? [英] Do Azure Easy Tables support relationships?

问题描述

我只是在学习Azure Mobile Apps. Easy Tables是否支持关系?我现有的架构有多个带有外键约束的表，并且我需要能够创建复杂的联接(Easy APIs).我试图理解所有这些简单"内容的要点.

I'm just learning about Azure Mobile Apps. Do Easy Tables support relationships? My existing schema has multiple tables with foreign key constraints, and I need the ability to create complex joins (Easy APIs). I'm trying to understand the point of all this "Easy" stuff.

我应该跳过它，只是创建一个自定义的ApiController和手动数据库脚本部署吗?

Should I skip it and just create a custom ApiController and manual db script deployment?

推荐答案

简单表只是通过Web API OData Service终结点公开的简单SQL Azure表.因此，当您创建它们时，您可以连接到SQL Azure并在其中创建关系等，并自定义API代码以在响应中包括那些关系数据.

Easy Tables are just simple SQL Azure tables that are exposed through a Web API OData Service endpoint. So when you create them you can connect to the SQL Azure and create your relationships etc there and customize the API code to include those relational data in the response.

根据我的经验，如果您没有复杂的逻辑/业务规则或复杂的查询，它们会很好.

From my experience they are good if you dont have complicated logic/business rules or complicated queries.

以我的经验，如果您有复杂的东西，即使是普通的Web API OData Service端点也无济于事，因为对请求的拦截使代码变得复杂，并且最好创建自己的Web API.

To my experience if you have complicated stuff even normal Web API OData Service endpoints would not help because the interception of the requests makes the code complicated and you are better off creating your own Web APIs.

我几乎感觉到Easy API和Easy Tables的设计目的是让您在hackathon中轻松启动简单的移动应用程序，或者将想法快速地进行演示.但是对于现实生活中的企业内容，我将继续构建自己的Web API.

I almost feel like the Easy API and Easy Tables are more designed to give you a kick start for a simple mobile app in a hackathon or to put an idea together as a demo real quick. But for real life enterprise stuff I will go with building my own Web API.

这篇关于Azure Easy Tables是否支持关系?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！