How do i encrypt and decrypt in model in asp.net mvc 5

Question

I have Model named Users in ASP.NET MVC 5. I have Encrypt() and Decrypt() Extension Methods to Encrypt and Decrypt string respectively. I want to encrypt and decrypt data while sving and fetching from database. So, I used:

private string _mob;
public string mob
    {
        get
        {
            return _mob.Decrypt();
        }
        set
        {
            _mob = value.Encrypt();
        }
    }

But I am unable to achieve my goal. When I use

public string mob
    {
        get
        {
            return _mob;
        }
        set
        {
            _mob = value.Encrypt();
        }
    }

I get encryption done but as soon as I add Decrypt() in get{} there is no encryption/decryption done. I see plain text data in database.

D Stanley · Accepted Answer · 2016-05-14T04:21:08.120

3

EF will use the property accessors when storing the data in the database, not the backing field, so if you want the encrypted value stored you need to return the encrypted value from the getter.

Since you probably want a property that returns the decrypted value as well you probably want a separate unmapped property for the decrypted text. You can use the [NotMapped] attribute so EF doesn't try to save it to the database as well::

public string mob {get; set; }

[NotMapped]
public string mobDecrypted
{
    get
    {
        return mob.Decrypt();
    }
    set
    {
        mob = value.Encrypt();
    }
}

edited May 14 '16 at 04:21

answered May 14 '16 at 02:50

D Stanley

149,601
11
178
240

sir could you please elaborate? I would be glad to learn from you. – Abhishek Singh May 14 '16 at 02:59
Elaborate on what? EF will use the property getter, so if your getter returns unencrypted text, that's what's stored in the database. – D Stanley May 14 '16 at 03:07
it worked perfectly.. thanks a lot.. please edit so i could upvote.. I accidentally downvoted it :) – Abhishek Singh May 14 '16 at 03:59
When taken to Index list MVC it took a longer time to load. any idea to resolve? – Saravanan Arunagiri Oct 18 '18 at 08:36

How do i encrypt and decrypt in model in asp.net mvc 5

1 Answers1