public static string ConectarSQL() { SqlConnection cn = new SqlConnection(); string dataSource = WebConfigurationManager.AppSettings["dataSource"]; string initialCatalog = WebConfigurationManager.AppSettings["initialCatalog"]; const string appName = "EntityFramework"; const string providerName = "System.Data.SqlClient"; string AppPath = HttpContext.Current.Server.MapPath("~/Application.xml"); ContextDelivery context = new ContextDelivery(AppPath); string ContextDeliveryApplicationAlias = WebConfigurationManager.AppSettings["ContextDeliveryApplicationAlias"]; string ContextDeliveryResourceAlias = WebConfigurationManager.AppSettings["ContextDeliveryResourceAlias"]; string ContextSet = WebConfigurationManager.AppSettings["ContextEnvironment"]; User usuario = context.GetUser( ContextDeliveryApplicationAlias, ContextDeliveryResourceAlias, ContextSet ); string nombre = usuario.GetUserName(); string password = usuario.GetPassword(); SqlConnectionStringBuilder sqlBuilder = new SqlConnectionStringBuilder(); sqlBuilder.DataSource = dataSource; sqlBuilder.InitialCatalog = initialCatalog; sqlBuilder.IntegratedSecurity = false; sqlBuilder.UserID = nombre; sqlBuilder.Password = password; return(sqlBuilder.ConnectionString); }
public static string GetUserPassword() { string AppPath = HttpContext.Current.Server.MapPath("~/ApplicationImpersonate.xml"); ContextDelivery context = new ContextDelivery(AppPath); string ContextDeliveryApplicationAlias = WebConfigurationManager.AppSettings["ContextDeliveryApplicationAliasImpersonate"]; string ContextDeliveryResourceAlias = WebConfigurationManager.AppSettings["ContextDeliveryResourceAliasImpersonate"]; string ContextSet = WebConfigurationManager.AppSettings["ContextEnvironment"]; User usuario = context.GetUser(ContextDeliveryApplicationAlias, ContextDeliveryResourceAlias, ContextSet); return(usuario.GetPassword()); }
public static string CreateConnectionString() { string metaData = WebConfigurationManager.AppSettings["metaData"]; string dataSource = WebConfigurationManager.AppSettings["dataSource"]; string initialCatalog = WebConfigurationManager.AppSettings["initialCatalog"]; const string appName = "EntityFramework"; const string providerName = "System.Data.SqlClient"; string AppPath = HttpContext.Current.Server.MapPath("~/Application.xml"); ContextDelivery context = new ContextDelivery(AppPath); string ContextDeliveryApplicationAlias = WebConfigurationManager.AppSettings["ContextDeliveryApplicationAlias"]; string ContextDeliveryResourceAlias = WebConfigurationManager.AppSettings["ContextDeliveryResourceAlias"]; string ContextSet = WebConfigurationManager.AppSettings["ContextEnvironment"]; User usuario = context.GetUser( ContextDeliveryApplicationAlias, ContextDeliveryResourceAlias, ContextSet ); string nombre = usuario.GetUserName(); string password = usuario.GetPassword(); SqlConnectionStringBuilder sqlBuilder = new SqlConnectionStringBuilder(); sqlBuilder.DataSource = dataSource; sqlBuilder.InitialCatalog = initialCatalog; sqlBuilder.MultipleActiveResultSets = true; sqlBuilder.IntegratedSecurity = false; sqlBuilder.UserID = nombre; sqlBuilder.Password = password; sqlBuilder.ApplicationName = appName; EntityConnectionStringBuilder efBuilder = new EntityConnectionStringBuilder(); efBuilder.Metadata = metaData; efBuilder.Provider = providerName; efBuilder.ProviderConnectionString = sqlBuilder.ConnectionString; return(efBuilder.ConnectionString); }