带有SQL数据库的SharePoint应用程序 [英] SharePoint app with SQL database
问题描述
我想开发SharePoint 2013/16应用程序（这是一个具有多个审批级别，审计跟踪和电子邮件警报的工作流程），可以拥有它拥有 用于维护数据的SQL
数据库表。 SharePoint将数据存储在列表中，这些列表不是关系型的。 因此执行SQL查询以搜索
是不可能的。 所以理想情况下，服务器端控制的应用程序会很好但是我应该仍然可以使用SharePoint
功能类似于工作流和 审核日志。 此应用程序还需要查询外部数据库以从外部
系统中提取数据。
SharePoint有3个托管模型 - SP托管（仅限客户端模型），自动 （Azure），提供商托管（单独）浩sting required and trust）and none
这些由于某些原因是可以接受的。 需要一个解决方案，其中一个人获得ASP的所有灵活性.net application
但是 想要使用服务器端对象模型部署和使用SP工作流程。任何反馈/指导。谢谢。
嗨RJosh，
在您的情况下，您可能需要创建自定义解决方案，而不是在SharePoint中设计应用程序。
请查看以下链接，了解有关SharePoint解决方案的更多详细信息：
https://msdn.microsoft.com/en- us / library / ee231517.aspx？f = 255& MSPPError = -2147217396
最诚挚的问候，
VICT奥里亚
I want to develop SharePoint 2013/16 application (which is a workflow with multiple approval levels, audit trail and email alerts) which can have its own SQL
database tables to maintain the data. SharePoint stores the data in Lists and these lists are not relational. So executing SQL query to search
something is not possible. So ideally an application with server side control would be good but I should still be able to use the SharePoint
features like Workflows and audit logs. This application also needs to query external database to pull data from external
systems.
SharePoint has 3 hosting models - SP hosted (only client model), Auto (Azure), Provider hosted (separate hosting required and trust) and none
of these are acceptable for certain reasons. Need a solution where one gets all flexibility of ASP .net application
but want to deploy and use SP workflows using server side object model. Any feedback/guidance. Thanks.
Hi RJosh,
In your case, you may need to create a custom solution instead of designing app in SharePoint.
Please check the link below for more details about SharePoint solution:
https://msdn.microsoft.com/en-us/library/ee231517.aspx?f=255&MSPPError=-2147217396
Best Regards,
Victoria
这篇关于带有SQL数据库的SharePoint应用程序的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
