Encrypt password field with Entity Framework Model First

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

Question

In my VS2010 project, I'm utilizing Entity Framework Model First.

If there is a method to set the field, please let me know.password to be encrypted in windows zzz-12 zzz or zzz-16 zzz, if possible. Since the generated.cs file will be overwritten each time I update the model, I don't want to alter it.

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

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Accepted Answer

Neither database encryption mechanisms nor built-in support for encryption are available in EF (unless you are using transparent encryption in SQL Server which will encrypt whole database).

You may implement centralized encryption and decryption in your application as a workaround. Here is a general concept:

  • Use astring your encrypted data will have a property, which will be shown asnvarchar target database column
  • Override SaveChanges approach in yourObjectContext or DbContext inheriting a handle or partial classSavingChanges occasion forObjectContext inheritable class). Search for all instances of your entity that are in this method's handler.Added or Modified state (make)ObjectStateManager or DbChangeTracker ), take the value to be encrypted from the property, encrypt it, and then save the encrypted value in Base64 format back in the property. If there isSaveChanges replace callbase.SaveChanges after the encryption of all instances' property.
  • Handle ObjectMaterialized the evenObjectContext inherited class (you must use this in DbContext)IObjectContextAdapter to getObjectContext example from yourDbContext For example, take the encrypted value from the property, convert it to byte array format from Base64, decode it, and then save the result back in the property. Other issues might arise as a consequence of the property value being changed, but you should be able to resolve these as well.
5
7/30/2012 8:15:26 AM

Popular Answer

Making a partial class that includes a new property that handles encryption and decoding might be an easier solution. In your code, you would then make use of this new property rather than the table object's Password attribute.

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 instance, I did it by creating extension methods on the string object. I performed the encryption and decryption using the code found in the following link:

Unlock and unlock a string

Rono

Related Questions

In entity framework, encrypt ConnectionString (first code)

How can my connection string be secured? It's crucial to me that other people cannot view my Connection String when I use Entity framework 4.1 (first code) in C#.
c# entity-framework visual-studio-2010
asked by Mahdi jokar

Entity Framework via Code First, nullable property to entity field

Making use of the data annotation...Required... like this:...[Required] public int somefield {get; set;} ...somefield... will be set to...Not Null... How can I configure database ...somefield... to accept NULLs? , While using SQL Server Management Studio, I attempted to change it, but Entity Framework changed 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....Absolutely true. However, what matters most is that...Order... contains a collection for navigating...OrderDetail... This attribute a...
code-first entity-framework
asked by Slauma

EF Code First Encrypt/Decrypt Password Property

I have the following model:...public class User { private string password; public string Password { get { return Decrypt(password); } set { password = Encrypt(value); } } } ...I want the logic layer to handle encryption and decryption so that user code users may simply insert and choose passwords with ease and view ...
c# ef-code-first entity-framework
asked by lbrahim

How do I encrypt data in Entity Framework Code First?

I've got good news. The SaveChanges/ObjectMaterialized method was causing me to experience instability because...DetectChanges()... is not called until the DbContext completes the save operation....By phoning, I was able to resolve this....DetectChanges()... prior to obtaining the entries that have been Added/Modified from the...ObjectStateManager....
azure c# ef-code-first encryption entity-framework
asked by Albert Bori

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

You're going to run into a lot of issues here, I agree. First off, 1:1 connections can only be supported by Entity Framework when they make use of a "shared primary key". This requires that the Address ID and the Parent or Student ID match, and that the address be a foreign key to the other....I know it appears simple to establish navigation proper...
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

Okay, let's resolve this. In essence, this is impossible if a relationship is shared between the two contexts. However, it functions if you use a different connection for both....I appreciate Ben Robinson's help in directing me in the proper way.
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

ZZZ_tmp
c# entity-framework linq
asked by Shweta Saxena

Encrypting/Decrypting data is database first Entity Framework

The data may be encrypted using AES encryption:...Using C# and AES encryption... and store the information as varbinary in the database.... You must map the encrypted data as a byte in entity framework....For instance, you might develop an entity framework model that associates encrypted data with database columns represented as bytes, a datareader...
asp.net c# entity-framework-6
asked by Stefano Balzarotti

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

ZZZ_tmp
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