public static bool GetEntityConnection(string Username, string Password, string Host, string Database, string Name, bool IntegratedSecurity)
{
string connectionString;
if (IntegratedSecurity)
{
connectionString = new System.Data.EntityClient.EntityConnectionStringBuilder
{
Metadata = "res://*",
Provider = "System.Data.SqlClient",
ProviderConnectionString = new System.Data.SqlClient.SqlConnectionStringBuilder
{
InitialCatalog = Database,
DataSource = Host,
IntegratedSecurity = true,
MultipleActiveResultSets = true
}.ConnectionString
}.ConnectionString;
}
else
{
connectionString = new System.Data.EntityClient.EntityConnectionStringBuilder
{
Metadata = "res://*",
Provider = "System.Data.SqlClient",
ProviderConnectionString = new System.Data.SqlClient.SqlConnectionStringBuilder
{
InitialCatalog = Database,
DataSource = Host,
IntegratedSecurity = false,
UserID = Username,
Password = Password,
MultipleActiveResultSets = true
}.ConnectionString
}.ConnectionString;
}
try
{
using (var Context = new finalDBEContext(connectionString))
{
Context.Database.Connection.Open();
Context.Database.Connection.Close();
}
}
catch(Exception e)
{
Debug.WriteLine("Connection Failed. Message: " + e.Message);
return false;
}
string BaseConnStr = connectionString;
ConnDictionary.Add(Name, BaseConnStr.Replace(Password, "{0}"));
ConnectionString = connectionString;
return true;
}
private void MenuItemNewEmp_Click(object sender, RoutedEventArgs e)
{
using (var Context = new finalDBEContext())
{
}
}