string GetConnectionString()
{
var connection = new EntityConnection("name=KsmedEntities");
var sqlBuild = new SqlConnectionStringBuilder(connection.StoreConnection.ConnectionString);
sqlBuild.Password = ConnectionStringsSecurity.DecryptPassword(sqlBuild.Password);
return(sqlBuild.ConnectionString);
}
public static string GetConnectionString()
{
var connectionStringBuilder = new SqlConnectionStringBuilder
{
DataSource = ConfigurationManager.AppSettings[DataSourceKey],
InitialCatalog = ConfigurationManager.AppSettings[InitialCatalogKey],
UserID = Const.DataBaseAdminUser,
Password = ConnectionStringsSecurity.DecryptPassword(Const.DataBaseAdminCryptedPassword)
};
return(connectionStringBuilder.ConnectionString);
}
public void ConnectionStringsSecurityTest()
{
var connection = ConnectionStringsSecurity.GetConnectionString(KsmedEntities.ConnectionString);
Assert.IsNotNull(connection);
connection.Open();
Assert.AreEqual(System.Data.ConnectionState.Open, connection.State);
connection.Close();
}
private static void ExportApplicationDB(string connectionString = "db")
{
_resources.Clear();
var cs = ConfigurationManager.ConnectionStrings[connectionString];
var csb = new SqlConnectionStringBuilder(cs.ConnectionString);
csb.Password = ConnectionStringsSecurity.DecryptPassword(csb.Password);
using (var connection = new SqlConnection(csb.ToString()))
{
connection.Open();
using (var command = connection.CreateCommand())
{
string query = @"SELECT k.ResourceKey, LanguageCode, v.Value, v.Comment
FROM AppResourceValue v LEFT JOIN AppResourceKey k ON v.ResourceId = k.ResourceId WHERE LanguageCode IN ({0})";
var whereQUery = new StringBuilder();
foreach (var culture in _appCultures)
{
whereQUery.Append("'");
whereQUery.Append(culture.ToString());
whereQUery.Append("',");
}
whereQUery.Remove(whereQUery.Length - 1, 1);
query = string.Format(query, whereQUery.ToString());
command.CommandText = query;
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
AddResource(
Source.ApplicationDB,
reader.GetString(0),
CultureInfo.GetCultureInfo(reader.GetString(1)),
reader.GetString(2),
reader.IsDBNull(3) ? null : reader.GetString(3)
);
}
}
}
}
}
static void Main(string[] args)
{
Console.WriteLine("Test connection to database");
Console.WriteLine("ConnectionString:");
Console.WriteLine(ConnectionStringsSecurity.GetConnectionString(null).ConnectionString);
try
{
using (var context = ContextFactory.GetNewContext())
{
var test = context.Users.ToArray();
}
}
catch (Exception ex)
{
Console.WriteLine("Exception :");
var currentEx = ex;
while (currentEx != null)
{
Console.WriteLine(currentEx.Message);
currentEx = currentEx.InnerException;
}
}
}
private static SqlConnection GetConnection(bool admin)
{
var connectionString = ConnectionStringsSecurity.GetConnectionString(admin ? "name=KsmedEntitiesAdmin" : KsmedEntities.ConnectionString);
return(new SqlConnection(connectionString.StoreConnection.ConnectionString));
}
