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