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)); }