Encrypt password field with Entity Framework Model First

ef-model-first entity-framework sql-server visual-studio-2010

Question

I'm using Entity Framework Model First in my project with VS2010.

I'm wondering if there is a way to set the field password to be encrypted in .edmx window or Properties windows maybe. I don't want to change the generated .cs file since it will be covered each time I modify the model.

1
4
7/30/2012 7:34:59 AM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Accepted Answer

EF doesn't have any built in support for encryption and it also doesn't have support for database encryption mechanism (unless you are using transparent encryption in SQL Server which will encrypt whole database).

As a workaround you can do centralized encryption and decryption in your application. Here is high level idea:

  • Use a string property for your encrypted data - this property will be represented as nvarchar column in target database
  • Override SaveChanges method in your ObjectContext or DbContext inherited partial class (or handle SavingChanges event for ObjectContext inherited class). In this method / handler search for all instances of your entity which are in Added or Modified state (use ObjectStateManager or DbChangeTracker), take the value from the property which should be encrypted, encrypt it and store encrypted value back to the property in Base64 format. In case of SaveChanges override call base.SaveChanges after you encrypted property for all instances.
  • Handle ObjectMaterialized even on ObjectContext inherited class (in DbContext you will have to use IObjectContextAdapter to get ObjectContext instance from your DbContext instance), take the encrypted value from the property, convert it from Base64 format to byte array, decrypt it and store it back to the property. This may lead to some other complications because changing the property value may result in modified state but you should be able to fix it as well.
5
7/30/2012 8:15:26 AM

Popular Answer

A simpler option would be to create a partial class which adds a new property which handles encryption and decryption. You would then refer to this new property in your code instead of the Password property in the table object.

Partial Public Class ObjectName
  Public Property PasswordValue As String
    Get
      Return Password.Decrypt()
    End Get
    Set(value As String)
      Password = value.Encrypt()
    End Set
  End Property
End Class

In this case I created extension methods on the string object to do that. I used the code in the following link to do the encryption and decryption:

Encrypt and decrypt a string

Rono

Related Questions

In entity framework, encrypt ConnectionString (first code)

How can i protect my connection string? I want to use Entity framework 4.1 (first code) in C#, but it is important to me that other people can not see my Connection String.
c# entity-framework visual-studio-2010
asked by Mahdi jokar

Entity Framework via Code First, nullable property to entity field

Using the data annotation ...Required... like so:...[Required] public int somefield {get; set;} ...Will set ...somefield... to ...Not Null... in database, How can I set ...somefield... to allow NULLs?, I tried setting it through SQL Server Management Studio but Entity Framework set it back to ...Not Null....
asp.net-mvc-3 code-first entity-framework nullable
asked by chrisramon

One to Many in Code First Entity Framework model - How do the relationships work?

I'm guessing that because the primary key in Order (OrderID) has foreign key in OrderDetails (OrderID) that is named the same, EF's rules correctly guess that they have a foreign-key/primary key relationship....Yes, correct. The important part though is that ...Order... has a navigation collection to ...OrderDetail...s. EF infers from this pr...
code-first entity-framework
asked by Slauma

EF Code First Encrypt/Decrypt Password Property

I have model like below:...public class User { private string password; public string Password { get { return Decrypt(password); } set { password = Encrypt(value); } } } ...I want from user code to use just insert and select password easily and see in clear text and want the logic layer to handle the encryption and ...
c# ef-code-first entity-framework
asked by lbrahim

How do I encrypt data in Entity Framework Code First?

I have good news. The instability I was experiencing with the SaveChanges/ObjectMaterialized approach was due to the fact that ...DetectChanges()... isn't called until the DbContext actually performs the save....I was able to fix this by calling ...DetectChanges()... before I pulled the Added/Modified records from the ...ObjectStateManager.... This...
azure c# ef-code-first encryption entity-framework
asked by Albert Bori

Entity Framework model class has conditional one-to-one relationship

Yeah, you're going to have a number of problems here. First, Entity Framework only supports 1:1 relationships when they use a "shared primary key". That means the Address ID and the Parent or Student ID have to be the same, and the address has to be a foreign key to the other. ...I know it seems easy to just create navigation properties to each ...
asp.net-mvc c# entity-framework-6 foreign-key-relationship
asked by Erik Funkenbusch

Solutions with one EF6 model (db first) and one code first

Ok, got to the bottom of this. Basically if you share a connection across both contexts this does not work. However if you use a different connection for both it works....Thanks to Ben Robinson for pointing me in right direction.
c# entity-framework entity-framework-6
asked by DermFrench

Encrypting Decrypting Data via Entity Framework using separate class exposing encrypted/decrypted values: Linq statements fails

In addition to my earlier question on entity framework. My purpose is to encrypt the field before saving to DB and Decrypt the fields before reading from DB.I have class (User.cs) generated from table User(having UserName property(to be encrypted) and I created a separate class SecureUser with UserName property that isencrypted/decrypted as sugges...
c# entity-framework linq
asked by Shweta Saxena

Encrypting/Decrypting data is database first Entity Framework

You can encrypt the data with AES encryption:...Using AES encryption in C#... and save the data in the database as varbinary.... In entity framework, you need to map the encrypted data as Byte[]. ...For example, you can create an entity framework model that maps the encrypted data as Byte[] to database; datareader class that decrypts the data from...
asp.net c# entity-framework-6
asked by Stefano Balzarotti

One-to-one and one-to-many on the same entity in Entity Framework

It's not necessary to define two different mapping for specific entities. All I need was to map a ...one-to-many... relation via fluent api. ...Here are the changes:...public class Office { // fk field to the entity public Guid ManageId{get;set;} public virtual Person Manager {get; set;} public virtual List<Person> People {get; set...
ef-fluent-api entity-framework entity-framework-6
asked by Ali Bahrami

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge
View more on Stack Overflow

Prime Library

Performance

Expression Evaluator

More Projects...

Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow