农场范围内的OData BDC模型 [英] Farm-scoped OData BDC model

问题描述

官方文档显示，SharePoint Designer不支持从OData提要创建外部内容类型，并且需要使用Visual Studio创建BDC模型和外部内容类型.到目前为止很好，我会很好 使用Visual Studio.但是，这里出现了混乱:同一份文档显示，您可能需要 创建一个SharePoint托管的加载项，以处理由OData提供的外部内容类型.很好-我喜欢插件，但是不幸的是，我们希望连接到OData feed的站点只是使用SharePoint Designer进行的一堆自定义.

The official documentation reads that SharePoint Designer does not support creating external content types from OData feeds, and one needs to use Visual Studio to create a BDC model and an external content type. So far so good, I would be perfectly fine with using Visual Studio. However here comes the confusion: the same documentation reads that one would need to create a SharePoint-hosted addin to work with OData-fed external content types. Great - I love addins, but the site we would like to connect to the OData feed is unfortunately just a bunch of customizations made with SharePoint Designer.

练习过一些搜索引擎功能后，我偶然发现了这个问题:

Having practiced some search engine-fu, I stumbled upon this:
Convert an add-in-scoped external content type to tenant-scoped

如果仅对本地SharePoint有效，那么这将是一个真正的救星！浏览这篇文章，我看不出为什么不应该这样做(而且，过去我们对自定义.NET程序集BDC做过类似的事情，并且确实有效)，但是 SharePoint，您永远不会知道.因此，我认为我会比较安全而不是后悔，因此在开始OData路线之前，我想寻求专业意见.

我对此表示感谢.如果这个问题属于设置和管理"部分，我也要事先道歉.论坛.

谢谢
Dmytro

This would be a real life-saver if only that worked for on-premises SharePoint! Skimming through the article I don't see any reasons why it shouldn't (moreover - we did something similar with a custom .NET assembly BDC in the past, and it worked), but with SharePoint, you never know. So I thought I would be rather safe than sorry and hence I would like to ask for professional advice before embarking on an OData route.

I would appreciate any inputs on this. I also apologize beforehand if this question rather belongs in the "Setup and administration" forum.

Thanks,
Dmytro

推荐答案

嗨Dmytro，

Hi Dmytro,

在SharePoint中，从SharePoint应用程序项目中的OData创建外部内容类型的原因主要是因为SharePoint应用程序不能直接使用BCS服务应用程序中定义的外部内容类型，它将在下面的线程中引发错误， 请检查:

In SharePoint, the reason to create external Content Types from OData in SharePoint app project is mainly because of SharePoint app can't use External Content Type defined in BCS service application directly, it will throw the error in the thread below, please check:

SharePoint hosted Apps security prompt issue never resolves

这个博客也指出了同样的问题:

And this blogs specified the same problem:

从以下位置访问BCS外部数据一个适用于SharePoint 2013的应用程序

此问题的解决方法是创建一个应用程序，其作用域为外部内容类型"，以便在应用程序中它可以调用OData来从数据库返回数据:

And the workaround of this issue is creating a app scoped External Content Type so that in the app and it could call OData to return data from Database:

在SharePoint中创建应用程序范围的外部内容类型(ECT)使用OData Services和BCS

这是在Visual Studio中使用SharePoint应用程序解决方案从OData创建外部内容类型的原因.

This is the reason that to create External Content Type from OData with SharePoint app solution in Visual Studio.

我认为也许您只想使用SharePoint Designer在前端进行一些自定义，我强烈建议您创建一个自定义Web服务以使用SQL数据库并使用Jquery ajax调用该Web服务，但仍使用Visual工作室 创建Web服务，但避免使用SharePoint应用程序，它适合在SharePoint Designer中工作.

And I think maybe you want to only do some customize in Front End with SharePoint Designer, I would highly recommended that you can create a custom web service to consume SQL Database and call the web service With Jquery ajax, it still using Visual Studio to create the web service, but avoid using SharePoint app and it's suitable for working in SharePoint Designer.

谢谢

最好的问候

这篇关于农场范围内的OData BDC模型的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！