MS Access 通过 SharePoint 访问 ASP.NET MVC 3：使用 Linq to SharePoint
我正在尝试查看您是否可以使用 Access 2010 中提供的 Microsoft Access Services 在 MVC Web 应用程序和 Microsoft Access 桌面解决方案之间同步数据。
如果您通过 Access Services 将 Access 应用程序后端发布到共享点。这工作得很好，您可以使用 Web 数据库来使用它，但是......遗憾的是，Web 数据库存在局限性。
因此，如果我可以将数据放入 SharePoint 列表，并且这些列表将与 Access 表同步，那么我所需要的就是从 MVC 应用程序访问共享点列表，嘿，很快，您就有了一个与 Access 同步的 MVC 应用程序桌面应用程序。
所以问题是：
上述想法可行吗？
以及：
如何从 ASP.NET MVC 3 应用程序访问共享点列表？
我发现了以下内容：
据推测，这反映出 Microsoft.SharePoint.Linq 命名空间仅适用于在 SharePoint 网站中运行的代码？
这将留下第三方工具，除非有一种供 .NET 访问的本机方式SharePoint 列表。在这方面：
.NET 是否有访问 SharePoint 列表的本机方法？
并且：
您是否知道用于从 MVC 3 应用程序访问共享点列表的任何第三方库或代码示例？
据推测，已经有人尝试这样做了。那么：
您知道有任何链接可以阅读有关此主题的更多信息吗？
I am trying to see if you can use Microsoft Access Services, as available in Access 2010, to synchronise data between an MVC web app, and a Microsoft Access desktop solution.
If you publish the Access app backend via Access Services to a sharepoint. This works fine, and you could use Web Databases to use that, but... sadly, there are limitations to Web Databases.
So, if I can get the data into SharePoint lists, and these lists will synch with the Access tables, then all I need is to access the sharepoint lists from the MVC app, hey presto, you have an MVC app that synchs with an Access desktop app.
So the questions are:
Will the above idea work?
And:
How do you access sharepoint lists from an ASP.NET MVC 3 app?
In an attempt to answer this myself, I came across the following:
On MSDN, there is an article on Linq to SharePoint. As I understand it, this intended for use in SharePoint, but there seems no reason why this could not be used from an MVC app, EXCEPT that there is no available reference Microsoft.SharePoint.Linq from Visual Studio 2010 Professional.
Presumably, this reflects the fact that the Microsoft.SharePoint.Linq namespace is only available to code running in a SharePoint site?
Which would leave third party tooling, unless there is a native way for .NET to access SharePoint lists. In that respect:
Is there a native way for .NET to access SharePoint lists?
And:
Do you know of any third party library or code samples for accessing sharepoint lists from an MVC 3 app?
Presumably, someone has already tried to do this. So:
Do you know of any links to read more on this subject?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
要获取 Microsoft.SharePoint.Linq 命名空间，只需安装 SharePoint 服务器试用版（最好在虚拟机上），然后将 DLL 从 C:\Program Files\Common Files\Microsoft Shared\Web Server Extension\14\ASAPI\ 目录复制到MVC3 应用程序的 BIN 文件夹并在项目中引用它。
要查询 SharePoint 列表，您可能还需要该文件夹中的其他 DLL（顺便说一句，\14\ 目录又称为“第 14 个配置单元”）。
To get the Microsoft.SharePoint.Linq namespace just install SharePoint server Trial(on a virtual machine preferably) and then copy the DLL from the C:\Program Files\Common Files\Microsoft Shared\Web Server Extension\14\ASAPI\ directory to the BIN folder of your MVC3 Application and reference it within your project.
To query the SharePoint list you might need other DLLs which are in that folder as well(by the way the \14\ directory is AKA "The 14th hive").