What I have found out is that many .NET users use:
SHA256Managed
and the federal government requires that if you do encrypt the Connections, that you use:
SHA256CryptoServiceProvider
Here is how I create the connection to the database:
Code: Select all
private void makeConnectionString()
{
Devart.Common.DbConnectionStringBuilder csb = new Devart.Common.DbConnectionStringBuilder();
ViewModel vm = ViewModel.myself;
csb["Host"] = vm.HostName;
csb["Port"] = vm.PortNumber;
csb["User Id"] = vm.UserID;
csb["Password"] = vm.Password;
csb["Database"] = vm.DataBaseName;
csb["Max Pool Size"] = 150;
csb["Connection Timeout"] = 30;
csb["Default Command Timeout"] = 600; // ten minutes for one search request
this.connString = csb.ConnectionString;
}