public void ConnectionStringsSecurityTest()
{
var connection = ConnectionStringsSecurity.GetConnectionString(KsmedEntities.ConnectionString);
Assert.IsNotNull(connection);
connection.Open();
Assert.AreEqual(System.Data.ConnectionState.Open, connection.State);
connection.Close();
}
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));
}