How to handle encrypted column in SQL Server Database in LINQ to SQL?

Question

We are in the process of encrypting all the SSN columns (had to do it now due to security audit). We already built the DBML and now we have to change it. Can you guys let me know if there is a good way of handling this in LINQ to SQL? We use stored procedures for Insert, Update and Delete but use LINQ to SQL for all our selects (ease of use). Do I have to change the format for those tables with SSN or Is there any other manner we can handle it in LINQ to SQL?

Thanks, Raja

Raja · Accepted Answer · 2010-03-19 11:48:56Z

2

After researching long on this topic we have decided to use stored procedures to handle the encrypted column table and use those CRUD stored procedures in LINQ to SQL.

Hope this helps someone.

answered Mar 19, 2010 at 11:48

Raja

3,6383 gold badges31 silver badges40 bronze badges

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

Collectives™ on Stack Overflow

How to handle encrypted column in SQL Server Database in LINQ to SQL?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related