public static string generateEntityConnectionString(string modelName, LCADatabaseSettings dbSettings, LCADBTypes dbType)
{
System.Data.EntityClient.EntityConnectionStringBuilder cStr = new System.Data.EntityClient.EntityConnectionStringBuilder();
string pcs = "";
if (dbSettings.dbServer.ToUpper() == "LOCAL")
{
// Replace the word local with the actual ip address of this machine
if (!System.Net.NetworkInformation.NetworkInterface.GetIsNetworkAvailable())
{
return("");
}
IPHostEntry host = Dns.GetHostEntry(Dns.GetHostName());
dbSettings.dbServer = host.AddressList.FirstOrDefault(ip => ip.AddressFamily == AddressFamily.InterNetwork).ToString();
}
// Build up an entity connection string for the database settings provided
// Metadata taken from generated App.Config code
cStr.Metadata = "res://*/" + modelName + ".csdl|res://*/" + modelName + ".ssdl|res://*/" + modelName + ".msl";
cStr.Provider = "System.Data.SqlClient";
// Actual sql server connection string with options provided on the config screen
pcs = "data source=" + dbSettings.dbServer + ";initial catalog=";
switch (dbType)
{
case LCADBTypes.DB_Config:
pcs += dbSettings.dbConfigDatabase;
break;
case LCADBTypes.DB_Data:
pcs += dbSettings.dbDataDatabase;
break;
case LCADBTypes.DB_Ctrl:
pcs += dbSettings.dbCtrlDatabase;
break;
case LCADBTypes.DB_Price:
pcs += dbSettings.dbPriceDatabase;
break;
}
if (dbSettings.dbNeedUser == true)
{
pcs += ";integrated security=false;User ID=" + dbSettings.dbUser + ";password="******";";
}
else
{
pcs += ";integrated security=True;";
}
pcs += "Connection Timeout=20;multipleactiveresultsets=True;App=EntityFramework;";
cStr.ProviderConnectionString = pcs;
return(cStr.ConnectionString);
}
public static string generateEntityConnectionString(string modelName, LCADatabaseSettings dbSettings)
{
return(generateEntityConnectionString(modelName, dbSettings, LCADBTypes.DB_Data));
}
//public static DataSet runQuery(string dbCnStr, string query)
//{
// DataSet result = null;
// using (SqlConnection cn = new SqlConnection(dbCnStr))
// {
// cn.Open();
// SqlCommand cmd = new SqlCommand(query, cn);
// if (cmd.Connection.State == System.Data.ConnectionState.Open)
// {
// SqlDataReader reader = cmd.ExecuteReader();
// reader.
// }
// }
// return result;
//}
public static string generateConnectionString(LCADatabaseSettings dbSettings)
{
return(generateConnectionString(dbSettings, LCADBTypes.DB_Data));
}
