2 // System.Data.SqlClient.SqlDependency.cs
5 // Veerapuram Varadhan (vvaradhan@novell.com)
7 // Copyright (C) 2008 Novell, Inc (http://www.novell.com)
9 // Permission is hereby granted, free of charge, to any person obtaining
10 // a copy of this software and associated documentation files (the
11 // "Software"), to deal in the Software without restriction, including
12 // without limitation the rights to use, copy, modify, merge, publish,
13 // distribute, sublicense, and/or sell copies of the Software, and to
14 // permit persons to whom the Software is furnished to do so, subject to
15 // the following conditions:
17 // The above copyright notice and this permission notice shall be
18 // included in all copies or substantial portions of the Software.
20 // THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND,
21 // EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF
22 // MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND
23 // NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE
24 // LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION
25 // OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION
26 // WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
30 using System.Security.Permissions;
32 using System.Data.SqlClient;
34 namespace System.Data.SqlClient
36 public sealed class SqlDependency
38 string uniqueId = Guid.NewGuid().ToString();
41 public SqlDependency()
46 public SqlDependency (SqlCommand command)
52 public SqlDependency (SqlCommand command, string options, int timeout)
58 get { return uniqueId; }
62 public bool HasChanges {
66 public event OnChangeEventHandler OnChange;
69 public void AddCommandDependency(SqlCommand command)
75 [HostProtectionAttribute(SecurityAction.LinkDemand, ExternalThreading = true)]
76 public static bool Start(string connectionString)
82 [HostProtectionAttribute(SecurityAction.LinkDemand, ExternalThreading = true)]
83 public static bool Start(string connectionString, string queue)
89 [HostProtectionAttribute(SecurityAction.LinkDemand, ExternalThreading = true)]
90 public static bool Stop(string connectionString)
96 [HostProtectionAttribute(SecurityAction.LinkDemand, ExternalThreading = true)]
97 public static bool Stop(string connectionString, string queue)