private SqlConnectionString(SqlConnectionString value) : base(value, false) { // Clone _permission = value._permission; _integratedSecurity = value._integratedSecurity; _connectionReset = value._connectionReset; _enlist = value._enlist; _encrypt = value._encrypt; _persistSecurityInfo = value._persistSecurityInfo; _pooling = value._pooling; _connectionLifeTime = value._connectionLifeTime; _connectTimeout = value._connectTimeout; _maxPoolSize = value._maxPoolSize; _minPoolSize = value._minPoolSize; _packetSize = value._packetSize; _applicationName = value._applicationName; _attachDBFileName = value._attachDBFileName; _currentLanguage = value._currentLanguage; _dataSource = value._dataSource; _initialCatalog = value._initialCatalog; _networkLibrary = value._networkLibrary; _userID = value._userID; _password = value._password; _workstationId = value._workstationId; }
private SqlConnectionString(string connectionString) : base(connectionString, UdlSupport.ThrowIfFound) { #endif if (base.IsEmpty()) { _integratedSecurity = DEFAULT.Integrated_Security; _connectionReset = DEFAULT.Connection_Reset; _enlist = DEFAULT.Enlist; _encrypt = DEFAULT.Encrypt; _persistSecurityInfo = DEFAULT.Persist_Security_Info; _pooling = DEFAULT.Pooling; _connectionLifeTime = DEFAULT.Connection_Lifetime; _connectTimeout = DEFAULT.Connect_Timeout; _maxPoolSize = DEFAULT.Max_Pool_Size; _minPoolSize = DEFAULT.Min_Pool_Size; _packetSize = DEFAULT.Packet_Size; _applicationName = DEFAULT.Application_Name; _attachDBFileName = DEFAULT.AttachDBFilename; _currentLanguage = DEFAULT.Current_Language; _dataSource = DEFAULT.Data_Source; _initialCatalog = DEFAULT.Initial_Catalog; _networkLibrary = DEFAULT.Network_Library; _userID = DEFAULT.User_ID; _password = DEFAULT.Password; _workstationId = _workstation_ID; } _permission = new SqlClientPermission(this); }
public void None () { SqlClientPermission perm = new SqlClientPermission (PermissionState.None); Check ("None-1", perm, false, false, 0); perm.AllowBlankPassword = true; Check ("None-2", perm, true, false, 0); SqlClientPermission copy = (SqlClientPermission)perm.Copy (); Check ("Copy_None-1", copy, true, false, 0); copy.AllowBlankPassword = false; Check ("Copy_None-2", copy, false, false, 0); }
public bool CanRequestNotifications() { try { SqlClientPermission perm = new SqlClientPermission(PermissionState.Unrestricted); perm.Demand(); return true; } catch { return false; } }
public Pedido() { InitializeComponent(); try { SqlClientPermission perm = new SqlClientPermission(PermissionState.Unrestricted); perm.Demand(); } catch { throw new ApplicationException("No tiene permisos de notificación"); } }
static private bool EnoughPermission() { SqlClientPermission perm = new SqlClientPermission(System.Security.Permissions.PermissionState.Unrestricted); try { perm.Demand(); return true; } catch (System.Exception) { return false; } }
public void None_Childs () { SqlClientPermission perm = new SqlClientPermission (PermissionState.None); perm.Add ("data source=localhost;", String.Empty, KeyRestrictionBehavior.AllowOnly); perm.Add ("data source=127.0.0.1;", "password=;", KeyRestrictionBehavior.PreventUsage); Check ("None-Childs-1", perm, false, false, 2); perm.AllowBlankPassword = true; Check ("None-Childs-2", perm, true, false, 2); SqlClientPermission copy = (SqlClientPermission)perm.Copy (); Check ("Copy_None-Childs-1", copy, true, false, 2); copy.AllowBlankPassword = false; Check ("Copy_None-Childs-2", copy, false, false, 2); }
private bool CanRequestNotifications() { // In order to use the callback feature of the // SqlDependency, the application must have // the SqlClientPermission permission. try { SqlClientPermission perm = new SqlClientPermission( PermissionState.Unrestricted); perm.Demand(); return true; } catch { return false; } }
//private Thread myThread; //Initialize public HostingForm() { InitializeComponent(); _rkApp.SetValue("Vents service", Application.ExecutablePath); try { var perm = new SqlClientPermission(PermissionState.Unrestricted); perm.Demand(); } catch { throw new ApplicationException("No permission"); } CheckPdmVault(); Program.HostForm = this; }
internal static bool HasSqlClientPermission() { NamedPermissionSet namedPermissionSet = HttpRuntime.NamedPermissionSet; if (namedPermissionSet == null) { return true; } IPermission target = namedPermissionSet.GetPermission(typeof(SqlClientPermission)); if (target == null) { return false; } IPermission permission2 = null; try { permission2 = new SqlClientPermission(PermissionState.Unrestricted); } catch { return false; } return permission2.IsSubsetOf(target); }
internal static bool HasSqlClientPermission() { NamedPermissionSet permissionset = HttpRuntime.NamedPermissionSet; // If we don't have a NamedPermissionSet, we're in full trust if (permissionset == null) return true; // Check that the user has unrestricted SqlClientPermission IPermission allowedPermission = permissionset.GetPermission(typeof(SqlClientPermission)); if (allowedPermission == null) { return false; } IPermission askedPermission = null; try { askedPermission = new SqlClientPermission(PermissionState.Unrestricted); } catch { return false; } return askedPermission.IsSubsetOf(allowedPermission); }
private void EnsureSqlDependencyListening() { if (!_sqlDependencyListenerStarted) { lock (_ensureSqlDependencyListeningLocker) { if (!_sqlDependencyListenerStarted) { SqlDependency.Start(ConnectionString); var perm = new SqlClientPermission(PermissionState.Unrestricted); perm.Demand(); _sqlDependencyListenerStarted = true; } } } }
public static bool DoesUserHavePermission() { try { SqlClientPermission clientPermission = new SqlClientPermission(PermissionState.Unrestricted); clientPermission.Demand(); return true; } catch { return false; } }
private SqlClientPermission(SqlClientPermission permission) : base(permission) { // for Copy }
public void Unrestricted () { SqlClientPermission perm = new SqlClientPermission (PermissionState.Unrestricted); Check ("Unrestricted-1", perm, false, true, 0); perm.AllowBlankPassword = true; Check ("Unrestricted-2", perm, true, true, 0); SqlClientPermission copy = (SqlClientPermission)perm.Copy (); // note: Unrestricted is always created with default values (so AllowBlankPassword is false) Check ("Copy_Unrestricted-1", copy, false, true, 0); copy.AllowBlankPassword = true; Check ("Copy_Unrestricted-2", copy, true, true, 0); }
private void InitSqlDependency() { LazyInitializer.EnsureInitialized(ref _sqlDependencyInit, () => { SqlDependency.Start(_connectionString); var perm = new SqlClientPermission(PermissionState.Unrestricted); perm.Demand(); return new object(); }); }
private void StartNotifyConnection() { _sqlConn = new SqlConnection(_connectString); // check if hosting enviromnet can listen to exceptions SqlClientPermission perm =new SqlClientPermission(PermissionState.Unrestricted); try { perm.Demand(); } catch (Exception ex) { var secEx = new Exception("The hosting enviromnent does not have SqlClientPermission",ex); broadCastException(secEx); throw secEx; } try { _sqlConn.Open(); SqlDependency.Stop(_connectString); SqlDependency.Start(_connectString); StartNotifying(); } catch (Exception ex) { broadCastException(ex); throw; } }
public override void Initialize(string name, System.Collections.Specialized.NameValueCollection config) { SqlClientPermission pSql = new SqlClientPermission(System.Security.Permissions.PermissionState.Unrestricted); pSql.Assert(); string connectionStringName = config["connectionStringName"]; if (string.IsNullOrEmpty(connectionStringName)) { throw new ProviderException("Connection string not specified"); } this.connectionString = ConfigurationManager.ConnectionStrings[connectionStringName].ConnectionString; base.Initialize(name, config); }
public void PermissionState_Invalid () { PermissionState ps = (PermissionState)Int32.MinValue; SqlClientPermission perm = new SqlClientPermission (ps); }
public void Unrestricted_Add () { SqlClientPermission perm = new SqlClientPermission (PermissionState.Unrestricted); Check ("Unrestricted-NoChild", perm, false, true, 0); perm.Add ("data source=localhost;", String.Empty, KeyRestrictionBehavior.AllowOnly); // note: Lost unrestricted state when children was added Check ("Unrestricted-WithChild", perm, false, false, 1); }
static internal void Demand(SqlConnectionString constr) { SqlClientPermission permission = ((null != constr) ? constr._permission : SqlConnection.SqlClientPermission); permission.Demand(); }
private SqlClientPermission(SqlClientPermission permission) : base(permission) { }
private SqlClientPermission(SqlClientPermission permission) : base(permission) // for Copy { }
private SqlClientPermission(SqlClientPermission permission) : base(permission) { }
private bool DoesUserHavePermission() { try { SqlClientPermission clientPermission = new SqlClientPermission(PermissionState.Unrestricted); // will throw an error if user does not have permissions clientPermission.Demand(); return true; } catch { return false; } }