internal static string GetConnectionString(NameValueCollection config) { Debug.Assert(config != null); string connectionString = config["connectionString"]; if (!String.IsNullOrEmpty(connectionString)) { return(connectionString); } else { string connectionStringName = config["connectionStringName"]; if (String.IsNullOrEmpty(connectionStringName)) { throw new ProviderException(SR.GetString(SR.Connection_name_not_specified)); } connectionString = SqlConnectionHelper.GetConnectionString(connectionStringName, lookupConnectionString: true, appLevel: true); if (String.IsNullOrEmpty(connectionString)) { throw new ProviderException(SR.GetString(SR.Connection_string_not_found, connectionStringName)); } else { return(connectionString); } } }
internal static void InitPolling(string database) { SqlCacheDependencySection sqlCacheDependency = RuntimeConfig.GetAppConfig().SqlCacheDependency; if (!sqlCacheDependency.Enabled) { throw new ConfigurationErrorsException(System.Web.SR.GetString("Polling_not_enabled_for_sql_cache"), sqlCacheDependency.ElementInformation.Properties["enabled"].Source, sqlCacheDependency.ElementInformation.Properties["enabled"].LineNumber); } SqlCacheDependencyDatabase databaseConfig = GetDatabaseConfig(database); if (databaseConfig.PollTime == 0) { throw new ConfigurationErrorsException(System.Web.SR.GetString("Polltime_zero_for_database_sql_cache", new object[] { database }), databaseConfig.ElementInformation.Properties["pollTime"].Source, databaseConfig.ElementInformation.Properties["pollTime"].LineNumber); } if (!s_DatabaseNotifStates.ContainsKey(database)) { string connection = SqlConnectionHelper.GetConnectionString(databaseConfig.ConnectionStringName, true, true); if ((connection == null) || (connection.Length < 1)) { throw new ConfigurationErrorsException(System.Web.SR.GetString("Connection_string_not_found", new object[] { databaseConfig.ConnectionStringName }), databaseConfig.ElementInformation.Properties["connectionStringName"].Source, databaseConfig.ElementInformation.Properties["connectionStringName"].LineNumber); } lock (s_DatabaseNotifStates) { if (!s_DatabaseNotifStates.ContainsKey(database)) { DatabaseNotifState state; state = new DatabaseNotifState(database, connection, databaseConfig.PollTime) { _timer = new Timer(s_timerCallback, state, 0, databaseConfig.PollTime) }; s_DatabaseNotifStates.Add(database, state); } } } }
public async Task <DataSet> ExecuteDataSet(string procedureName, IDictionary <string, object> values = null) { DataSet dataSet = null; using (var connection = new SqlConnection(_connectionHelper.GetConnectionString())) { var procedure = CreateProcedure(procedureName, values); procedure.Connection = connection; connection.Open(); var adapter = new SqlDataAdapter(procedure); dataSet = new DataSet(); await Task.FromResult(adapter.Fill(dataSet)); } return(dataSet); }
public override void Initialize(string name, NameValueCollection config) { Debug.Trace("SqlWebEventProvider", "Initializing: name=" + name); _SchemaVersionCheck = 0; string temp = null; ProviderUtil.GetAndRemoveStringAttribute(config, "connectionStringName", name, ref temp); ProviderUtil.GetAndRemoveStringAttribute(config, "connectionString", name, ref _sqlConnectionString); if (!String.IsNullOrEmpty(temp)) { if (!String.IsNullOrEmpty(_sqlConnectionString)) { throw new ConfigurationErrorsException(SR.GetString(SR.Only_one_connection_string_allowed)); } _sqlConnectionString = SqlConnectionHelper.GetConnectionString(temp, true, true); if (_sqlConnectionString == null || _sqlConnectionString.Length < 1) { throw new ConfigurationErrorsException(SR.GetString(SR.Connection_string_not_found, temp)); } } else { // If a connection string is specified explicitly, verify that its not using integrated security SqlConnectionStringBuilder builder = new SqlConnectionStringBuilder(_sqlConnectionString); if (builder.IntegratedSecurity) { throw new ConfigurationErrorsException(SR.GetString(SR.Cannot_use_integrated_security)); } } if (String.IsNullOrEmpty(_sqlConnectionString)) { throw new ConfigurationErrorsException(SR.GetString(SR.Must_specify_connection_string_or_name, temp)); } ProviderUtil.GetAndRemovePositiveOrInfiniteAttribute(config, "maxEventDetailsLength", name, ref _maxEventDetailsLength); if (_maxEventDetailsLength == ProviderUtil.Infinite) { _maxEventDetailsLength = NO_LIMIT; } else if (_maxEventDetailsLength > SQL_MAX_NTEXT_SIZE) { throw new ConfigurationErrorsException(SR.GetString(SR.Invalid_max_event_details_length, name, _maxEventDetailsLength.ToString(CultureInfo.CurrentCulture))); } ProviderUtil.GetAndRemovePositiveAttribute(config, "commandTimeout", name, ref _commandTimeout); base.Initialize(name, config); }
public override void Initialize(string name, NameValueCollection configSettings) { HttpRuntime.CheckAspNetHostingPermission(AspNetHostingPermissionLevel.Low, "Feature_not_supported_at_this_level"); if (configSettings == null) { throw new ArgumentNullException("configSettings"); } if (string.IsNullOrEmpty(name)) { name = "SqlPersonalizationProvider"; } if (string.IsNullOrEmpty(configSettings["description"])) { configSettings.Remove("description"); configSettings.Add("description", System.Web.SR.GetString("SqlPersonalizationProvider_Description")); } base.Initialize(name, configSettings); this._SchemaVersionCheck = 0; this._applicationName = configSettings["applicationName"]; if (this._applicationName != null) { configSettings.Remove("applicationName"); if (this._applicationName.Length > 0x100) { object[] args = new object[] { 0x100.ToString(CultureInfo.CurrentCulture) }; throw new ProviderException(System.Web.SR.GetString("PersonalizationProvider_ApplicationNameExceedMaxLength", args)); } } string str = configSettings["connectionStringName"]; if (string.IsNullOrEmpty(str)) { throw new ProviderException(System.Web.SR.GetString("PersonalizationProvider_NoConnection")); } configSettings.Remove("connectionStringName"); string str2 = SqlConnectionHelper.GetConnectionString(str, true, true); if (string.IsNullOrEmpty(str2)) { throw new ProviderException(System.Web.SR.GetString("PersonalizationProvider_BadConnection", new object[] { str })); } this._connectionString = str2; this._commandTimeout = SecUtility.GetIntValue(configSettings, "commandTimeout", -1, true, 0); configSettings.Remove("commandTimeout"); if (configSettings.Count > 0) { string key = configSettings.GetKey(0); throw new ProviderException(System.Web.SR.GetString("PersonalizationProvider_UnknownProp", new object[] { key, name })); } }
public override void Initialize(string name, NameValueCollection config) { this._SchemaVersionCheck = 0; string val = null; ProviderUtil.GetAndRemoveStringAttribute(config, "connectionStringName", name, ref val); ProviderUtil.GetAndRemoveStringAttribute(config, "connectionString", name, ref this._sqlConnectionString); if (!string.IsNullOrEmpty(val)) { if (!string.IsNullOrEmpty(this._sqlConnectionString)) { throw new ConfigurationErrorsException(System.Web.SR.GetString("Only_one_connection_string_allowed")); } this._sqlConnectionString = SqlConnectionHelper.GetConnectionString(val, true, true); if ((this._sqlConnectionString == null) || (this._sqlConnectionString.Length < 1)) { throw new ConfigurationErrorsException(System.Web.SR.GetString("Connection_string_not_found", new object[] { val })); } } else { SqlConnectionStringBuilder builder = new SqlConnectionStringBuilder(this._sqlConnectionString); if (builder.IntegratedSecurity) { throw new ConfigurationErrorsException(System.Web.SR.GetString("Cannot_use_integrated_security")); } } if (string.IsNullOrEmpty(this._sqlConnectionString)) { throw new ConfigurationErrorsException(System.Web.SR.GetString("Must_specify_connection_string_or_name", new object[] { val })); } ProviderUtil.GetAndRemovePositiveOrInfiniteAttribute(config, "maxEventDetailsLength", name, ref this._maxEventDetailsLength); if (this._maxEventDetailsLength == 0x7fffffff) { this._maxEventDetailsLength = -1; } else if (this._maxEventDetailsLength > 0x3fffffff) { throw new ConfigurationErrorsException(System.Web.SR.GetString("Invalid_max_event_details_length", new object[] { name, this._maxEventDetailsLength.ToString(CultureInfo.CurrentCulture) })); } ProviderUtil.GetAndRemovePositiveAttribute(config, "commandTimeout", name, ref this._commandTimeout); base.Initialize(name, config); }
internal static string GetConnectionString(NameValueCollection config) { string str = config["connectionString"]; if (string.IsNullOrEmpty(str)) { string str2 = config["connectionStringName"]; if (string.IsNullOrEmpty(str2)) { throw new ProviderException(System.Web.SR.GetString("Connection_name_not_specified")); } bool lookupConnectionString = true; bool appLevel = true; str = SqlConnectionHelper.GetConnectionString(str2, lookupConnectionString, appLevel); if (string.IsNullOrEmpty(str)) { throw new ProviderException(System.Web.SR.GetString("Connection_string_not_found", new object[] { str2 })); } } return(str); }
public override void Initialize(string name, NameValueCollection configSettings) { HttpRuntime.CheckAspNetHostingPermission(AspNetHostingPermissionLevel.Low, SR.Feature_not_supported_at_this_level); // configSettings cannot be null because there are required settings needed below if (configSettings == null) { throw new ArgumentNullException("configSettings"); } if (String.IsNullOrEmpty(name)) { name = "SqlPersonalizationProvider"; } // description will be set from the base class' Initialize method if (string.IsNullOrEmpty(configSettings["description"])) { configSettings.Remove("description"); configSettings.Add("description", SR.GetString(SR.SqlPersonalizationProvider_Description)); } base.Initialize(name, configSettings); _SchemaVersionCheck = 0; // If not available, the default value is set in the get accessor of ApplicationName _applicationName = configSettings["applicationName"]; if (_applicationName != null) { configSettings.Remove("applicationName"); if (_applicationName.Length > maxStringLength) { throw new ProviderException(SR.GetString(SR.PersonalizationProvider_ApplicationNameExceedMaxLength, maxStringLength.ToString(CultureInfo.CurrentCulture))); } } string connectionStringName = configSettings["connectionStringName"]; if (String.IsNullOrEmpty(connectionStringName)) { throw new ProviderException(SR.GetString(SR.PersonalizationProvider_NoConnection)); } configSettings.Remove("connectionStringName"); string connectionString = SqlConnectionHelper.GetConnectionString(connectionStringName, true, true); if (String.IsNullOrEmpty(connectionString)) { throw new ProviderException(SR.GetString(SR.PersonalizationProvider_BadConnection, connectionStringName)); } _connectionString = connectionString; _commandTimeout = SecUtility.GetIntValue(configSettings, "commandTimeout", -1, true, 0); configSettings.Remove("commandTimeout"); if (configSettings.Count > 0) { string invalidAttributeName = configSettings.GetKey(0); throw new ProviderException(SR.GetString(SR.PersonalizationProvider_UnknownProp, invalidAttributeName, name)); } }