MVC using Linq to Entity w/ sql encryption

Question

Currently i am using sql encryption and would like to continue using it through Linq. I have all my CRUD stored proc's wired up to the table in order to handle the encryption/decryption on the backend. Problem is my database model see's a field type of varbinary(max) which is used for the sql encryption storage. The retrieval sp for this table does the decryption thus returning a string value. How does one get around this. Seems like the model needs to recognize a string in place of the varbinary but i am unsure of how to handle this. Thanks in advance.

Billy Logan · Accepted Answer · 2009-08-07 13:03:26Z

1

So change the table mapping to a view mapping in the database model?

answered Aug 7, 2009 at 13:03

Billy Logan

2,86316 gold badges43 silver badges50 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Craig Stuntz · Accepted Answer · 2009-08-07 12:46:16Z

0

Off the top of my head, some choices:

Edit the ssdl manually.
Make a view and map that (you don't need to actually use it for anything but mapping).

answered Aug 7, 2009 at 12:46

Craig Stuntz

127k12 gold badges257 silver badges275 bronze badges

Collectives™ on Stack Overflow

MVC using Linq to Entity w/ sql encryption

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related