如何强制ADO.Net实体服务中的数据检索仅通过存储过程 [英] How to force data retrieves in ADO.Net Entity Services to only go via Stored Procedures

问题描述

我已经想出如何通过存储过程强制创建，更新和删除。
但是如果我想强制检索只允许通过存储的procudure进行访问并防止直接访问底层表格。

我有一个名为LoggedInUsers的表，需要每当有人访问一个表以确保他们只看到他们的数据时，查询这个，在访问数据时传递用户id / token。

I have figured out how to force Create, Update and Delete to go via stored procedures.

However what if I want to force the retrieve to only allow access via a stored procudure and prevent access to the underlying tables directly.

I have a table called LoggedInUsers and need to query this whenever someone accesses a table to make sure they see only their data, passing the user id/token when accessing the data.

推荐答案

你好，

检查出来

http://www.onedotnetway.com/execute-stored-procedure-with-adonet-data-services/

希望这有帮助。

Hi,

Check this out

http://www.onedotnetway.com/execute-stored-procedure-with-adonet-data-services/

Hope this helps.

这篇关于如何强制ADO.Net实体服务中的数据检索仅通过存储过程的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！