Encrypt connection string in c# code

Question

I have connection string in my c# code, so i can get data from database using a stored procedure.

The connection string is like this:

connection.ConnectionString = "Data Source=192.168.4.33;Initial Catalog=database;Persist Security Info=True;User ID=test;Password=@test312321";

How can i Encrypt the connection, and then when i want to use it decrypt?

You can use RijndaelManaged to encrypt/decrypt your connection string — mbadeveloper, Sep 28 '17 at 15:17
In google everything that i find is talking about encryting connection string on web.config. — Phill, Sep 28 '17 at 15:30
@smoore4 actually it's not well documented for Xamarin, as the concept of Web.Config does not exist. — Bejasc, Sep 28 '17 at 23:45
@mbadeveloper using RijndaelManaged where can i store the encrypted text? In a file? — Phill, Sep 29 '17 at 10:44

score 0 · Answer 1 · answered Sep 28 '17 at 15:30

You can use this :

try
{
    // Open the configuration file and retrieve 
    // the connectionStrings section.
    Configuration config = ConfigurationManager.
        OpenExeConfiguration(exeConfigName);

    ConnectionStringsSection section =
        config.GetSection("connectionStrings")
        as ConnectionStringsSection;

    if (section.SectionInformation.IsProtected)
    {
        // Remove encryption.
        section.SectionInformation.UnprotectSection();
    }
    else
    {
        // Encrypt the section.
        section.SectionInformation.ProtectSection(
            "DataProtectionConfigurationProvider");
    }
    // Save the current configuration.
    config.Save();

    Console.WriteLine("Protected={0}",
        section.SectionInformation.IsProtected);
}
catch (Exception ex)
{
    Console.WriteLine(ex.Message);
}

or you Enterprise Library Data Access Application Block to perform the encryption using RSAProtectedConfigurationProvider or DPAPIProtectedConfigurationProvider. the link: http://msdn.microsoft.com/en-us/library/89211k9b(VS.80).aspx

Encrypt connection string in c# code

1 Answers1

Linked