English 中文(简体)
DB 中实体数据模型和加密列
原标题:Entity Data Model and Encrypted Columns in DB

我们在 SQl 服务器 DB 上有几张表格, 我们想要对这些表格加密一些含有敏感客户数据的列。 我们正在使用 EDM 访问、 更新、 插入. 数据库数据。 我们将使用数据库上的对称键对几个表格加密一些已有的列。 在 ED 中需要做哪些更新来适应加密列?

谢谢

问题回答

也许这对其他人有帮助...我们最终没有在 DB 级别上使用对称加密, 我们加密了应用程序中的列, 并保存了加密数据作为字符串, 在检索数据时解密了 col s。 它的工作非常顺利 。

在此情况下, 您应该总是先加密数据, 然后再将其输入数据库, 然后在拉动时解密 。 EF 没有任何内含内容支持您使用任何加密/ 解密内含 。

Thats how you should do it. I hope that helps you out.

除了你的搜索查询和命令之外,它确实有效, 完全被射杀, 也是为什么我哼哼和责怪 完全被加密的主要原因。





相关问题
Anyone feel like passing it forward?

I m the only developer in my company, and am getting along well as an autodidact, but I know I m missing out on the education one gets from working with and having code reviewed by more senior devs. ...

How to Add script codes before the </body> tag ASP.NET

Heres the problem, In Masterpage, the google analytics code were pasted before the end of body tag. In ASPX page, I need to generate a script (google addItem tracker) using codebehind ClientScript ...

Transaction handling with TransactionScope

I am implementing Transaction using TransactionScope with the help this MSDN article http://msdn.microsoft.com/en-us/library/system.transactions.transactionscope.aspx I just want to confirm that is ...

System.Web.Mvc.Controller Initialize

i have the following base controller... public class BaseController : Controller { protected override void Initialize(System.Web.Routing.RequestContext requestContext) { if (...

Microsoft.Contracts namespace

For what it is necessary Microsoft.Contracts namespace in asp.net? I mean, in what cases I could write using Microsoft.Contracts;?

Separator line in ASP.NET

I d like to add a simple separator line in an aspx web form. Does anyone know how? It sounds easy enough, but still I can t manage to find how to do it.. 10x!

热门标签