揭露SQL Server数据库的Web服务来获得数据数据库、数据、SQL、Server

2023-09-03 10:06:39 作者:虚妄

有任何.NET工具来对我的表中的数据暴露在Microsoft SQL Server作为Web服务?我是否需要写code?有什么样?什么是你的建议是如何暴露的数据?

Is there any .NET tool to expose the data of my tables in Microsoft SQL Server as web services? Do I have to write the code? Are there any samples? What do your recommend as to how to expose the data?

推荐答案

在使用 WCF数据服务可以是一种选择,就像Anton说,你应该考虑它是否是一个好主意,提供一个直接的路径整个/部分数据库。

While to use WCF Data Services can be an option, just like Anton said, you should consider if it's a good idea to provide a direct path to your entire/partial database.

另一种选择是建立一个数据访问层,这将使只是一个小的操作集,如:你可以添加一个客户,但你不能删除发票

Another option is to build a data access layer, which will allow just a small operation set, like: "you can to add a customer, but you're not allowed to delete an invoice"