// =====================
// Get Connection String
// =====================
public static String GetConnectionString()
{
String path = Path.Combine(Path.GetDirectoryName(Assembly.GetExecutingAssembly().Location), @"SysConnectionString.json");
String json;
using (StreamReader trmRead = new StreamReader(path)) { json = trmRead.ReadToEnd(); }
JavaScriptSerializer javaScriptSerializer = new JavaScriptSerializer();
Models.SysConnectionStringModel sysConnectionStringEntity = javaScriptSerializer.Deserialize <Models.SysConnectionStringModel>(json);
String connectionString = sysConnectionStringEntity.ConnectionString;
return(connectionString);
}
public static String GetConnectionString()
{
String path = Path.Combine(Path.GetDirectoryName(Assembly.GetExecutingAssembly().Location), @"Settings/SysConnectionStringSettings.json");
String json;
using (StreamReader streamReader = new StreamReader(path)) { json = streamReader.ReadToEnd(); }
JavaScriptSerializer javaScriptSerializer = new JavaScriptSerializer();
Models.SysConnectionStringModel sysConnectionString = javaScriptSerializer.Deserialize <Models.SysConnectionStringModel>(json);
String connectionString = "Data Source=" + sysConnectionString.DataSource
+ ";Initial Catalog=" + sysConnectionString.InitialCatalog
+ ";Persist Security Info=True;User ID=" + sysConnectionString.UserId
+ ";Password=" + sysConnectionString.Password;
return(connectionString);
}
