protected void Application_Start() { AreaRegistration.RegisterAllAreas(); FilterConfig.RegisterGlobalFilters(GlobalFilters.Filters); RouteConfig.RegisterRoutes(RouteTable.Routes); BundleConfig.RegisterBundles(BundleTable.Bundles); SqlDependency.Start(con); }
protected void Application_Start() { AntiForgeryConfig.UniqueClaimTypeIdentifier = ClaimsIdentity.DefaultNameClaimType; AreaRegistration.RegisterAllAreas(); FilterConfig.RegisterGlobalFilters(GlobalFilters.Filters); RouteConfig.RegisterRoutes(RouteTable.Routes); BundleConfig.RegisterBundles(BundleTable.Bundles); SqlDependency.Start(connString); }
public Listener(string connectionString, SqlCommand command) { _Connection = new SqlConnection(connectionString); _Command = command; _Command.Connection = _Connection; _Connection.Open(); SqlDependency.Start(_Connection.ConnectionString); }
public EntityChangeNotifier(Expression <Func <TEntity, bool> > query) { _context = new TDbContext(); _query = query; _connectionString = _context.Database.Connection.ConnectionString; SqlDependency.Start(_connectionString); RegisterNotification(); }
protected void Application_Start() { AreaRegistration.RegisterAllAreas(); FilterConfig.RegisterGlobalFilters(GlobalFilters.Filters); RouteConfig.RegisterRoutes(RouteTable.Routes); BundleConfig.RegisterBundles(BundleTable.Bundles); //Start SqlDependency with application initialization SqlDependency.Start(connString); }
private void EstablishConnection() { sqlConnection = new SqlConnection(); sqlConnection.ConnectionString = "Data Source=(LocalDb)\\MSSQLLocalDB;Integrated Security=true;Database=CarsDB;"; sqlConnection.Open(); SqlDependency.Start("Data Source=(LocalDb)\\MSSQLLocalDB;Integrated Security=true;Database=CarsDB;"); }
private void Refresh(SqlCommand sqlCommand) { SqlDependency.Stop(DatabaseConnection.ConnectionString); SqlDependency.Start(DatabaseConnection.ConnectionString); SqlDependency dependency = new SqlDependency(sqlCommand); dependency.OnChange += new OnChangeEventHandler(OnChange); }
protected void Application_Start() { LastRunTime = DateTime.Now; GlobalConfiguration.Configure(WebApiConfig.Register); AreaRegistration.RegisterAllAreas(); RouteConfig.RegisterRoutes(RouteTable.Routes); BundleConfig.RegisterBundles(BundleTable.Bundles); SqlDependency.Start(providerConnectionString); }
private void dbChangeNotification(object sender, SqlNotificationEventArgs e) { var DonHangs = new List <DonHang>(); int num1, num2; using (SqlConnection conn = new SqlConnection(connectionString)) { conn.Open(); SqlDependency.Start(connectionString); string commandText = "select MaDH, TinhTrangDH from dbo.DonHang"; SqlCommand cmd = new SqlCommand(commandText, conn); SqlDependency dependency = new SqlDependency(cmd); var reader = cmd.ExecuteReader(); num1 = num2 = 0; while (reader.Read()) { var DonHang = new DonHang { MaDh = reader["MaDH"].ToString(), }; if (reader["TinhTrangDH"].ToString() == "1") { num1++; } else if (reader["TinhTrangDH"].ToString() == "2") { num2++; } DonHangs.Add(DonHang); } newID = DonHangs.LastOrDefault().MaDh; }; if (e.Type == SqlNotificationType.Change && e.Info == SqlNotificationInfo.Update) { _context.Clients.All.SendAsync("updateDonHangs", num1.ToString(), num2.ToString()); } else { if (e.Type == SqlNotificationType.Change && e.Info == SqlNotificationInfo.Insert && a) { _context.Clients.All.SendAsync("refreshDonHangs", newID, num1.ToString(), num2.ToString()); a = false; } else { a = true; } } }
protected void Application_Start() { AreaRegistration.RegisterAllAreas(); FilterConfig.RegisterGlobalFilters(GlobalFilters.Filters); RouteConfig.RegisterRoutes(RouteTable.Routes); BundleConfig.RegisterBundles(BundleTable.Bundles); GlobalFilters.Filters.Add(new UserAuditFilter()); SqlDependency.Start(ConfigurationManager.ConnectionStrings["TimesheetDBEntities"].ToString()); }
protected void Application_Start() { AreaRegistration.RegisterAllAreas(); GlobalConfiguration.Configure(WebApiConfig.Register); FilterConfig.RegisterGlobalFilters(GlobalFilters.Filters); RouteConfig.RegisterRoutes(RouteTable.Routes); BundleConfig.RegisterBundles(BundleTable.Bundles); SqlDependency.Start(_dbContext.Connectionstring()); }
//-------------------------------------------------------------------------------------------------------- //-------------------------------------------------------------------------------------------------------- //-------------------------------------------------------------------------------------------------------- //---------------------------------------INICIA EL PROCESO------------------------------------------------ //-------------------------------------------------------------------------------------------------------- //-------------------------------------------------------------------------------------------------------- //-------------------------------------------------------------------------------------------------------- /*public static void showNotification(int days) * { * Notificacion VentanaNotificacion = new Notificacion(days); * VentanaNotificacion.Show();--- * PopupNotifier popup = new PopupNotifier(); * popup.TitleText = "Alerta de deias"; * popup.ContentText = "7 dias de trabajo"; * popup.AnimationDuration = 1000; * * popup.Popup(); * }*/ public Inicio() { string connectionString = "Server = DESKTOP-P78S0RT; Database = AxTrax1; Trusted_Connection = True;"; InitializeComponent(); SqlDependency.Stop(connectionString); SqlDependency.Start(connectionString); RegisterForChanges(); }
public SqlDependencyHelper(Action obj, string cmd) { ConnectionString = QLGN.Properties.Settings.Default.CATSHIPConnectionString; Act = obj; command = cmd; // Start listening notification SqlDependency.Stop(ConnectionString); SqlDependency.Start(ConnectionString); }
protected void Application_Start() { AreaRegistration.RegisterAllAreas(); FilterConfig.RegisterGlobalFilters(GlobalFilters.Filters); RouteConfig.RegisterRoutes(RouteTable.Routes); BundleConfig.RegisterBundles(BundleTable.Bundles); SqlDependency.Start(ConfigurationManager.ConnectionStrings["DataQuickJob"].ConnectionString); }
/// <summary> /// Starts the notification of SqlDependency /// </summary> /// <param name="context">An instance of dbcontext</param> public static void StartMonitor(DbContext context) { try { SqlDependency.Start(context.Database.Connection.ConnectionString); } catch (Exception ex) { throw new System.Exception("Fails to Start the SqlDependency in the RegularlyNotificationRegister class", ex); } }
/** * @ 构造函数 * @ dbString 数据库连接字符串 * */ public SqlCacheExpiration(string dbString) { if (string.IsNullOrEmpty(dbString)) { throw new ArgumentNullException("dbConnectionStr不能为空"); } dbConnectionString = dbString; SqlDependency.Start(dbConnectionString); }
protected void Application_Start() { AreaRegistration.RegisterAllAreas(); FilterConfig.RegisterGlobalFilters(GlobalFilters.Filters); RouteConfig.RegisterRoutes(RouteTable.Routes); BundleConfig.RegisterBundles(BundleTable.Bundles); SqlDependency.Start(con); log4net.Config.XmlConfigurator.Configure(new FileInfo(Server.MapPath("~/Web.config"))); }
//initiate notification private void NotifyNewItem() { if (DoesUserHavePermission()) { if (isFirst) { SqlDependency.Stop(ConnectionString); SqlDependency.Start(ConnectionString); } try { using (SqlConnection conn = new SqlConnection(ConnectionString)) { var cmd = Command; if (!string.IsNullOrEmpty(_controlField)) { cmd += (cmd.Contains(" WHERE ") ? " AND " : " WHERE ") + _controlField + " > " + _controlConsecutive; } using (SqlCommand com = new SqlCommand(cmd, conn)) { com.Notification = null; SqlDependency dep = new SqlDependency(com); //subscribe to sql dependency event handler dep.OnChange += new OnChangeEventHandler(dep_OnChange); conn.Open(); using (var reader = com.ExecuteReader()) { //convert reader to list<T> using reflection while (reader.Read()) { var obj = Activator.CreateInstance <T>(); var properties = obj.GetType().GetProperties(); foreach (var property in properties) { try { if (reader[property.Name] != DBNull.Value) { property.SetValue(obj, reader[property.Name], null); } if (!string.IsNullOrEmpty(_controlField) && reader[_controlField] != DBNull.Value) { int.TryParse(reader[_controlField].ToString(), out _controlConsecutive); } } catch (Exception ex) { Console.WriteLine(ex.Message); } } CollectionReturn.Add(obj); } } } } } catch (Exception ex) { Console.WriteLine(ex.Message); } } }
static void Main(string[] args) { SqlDependency.Start(connectionString); getDataWithSqlDependency(); Console.WriteLine("Waiting for data changes"); Console.WriteLine("Press enter to quit"); Console.ReadLine(); SqlDependency.Stop(connectionString); }
protected void Application_Start() { AreaRegistration.RegisterAllAreas(); GlobalConfiguration.Configure(WebApiConfig.Register); FilterConfig.RegisterGlobalFilters(GlobalFilters.Filters); RouteConfig.RegisterRoutes(RouteTable.Routes); BundleConfig.RegisterBundles(BundleTable.Bundles); StripeConfiguration.SetApiKey(ConfigurationManager.AppSettings["stripeSecretKey"]); SqlDependency.Start(con); }
public EntityChangeNotifier(Expression <Func <TEntity, bool> > query) { _context = new TDbContext(); _query = query; _connectionString = _context.Database.Connection.ConnectionString; SafeCountDictionary.Increment(_connectionString, x => { SqlDependency.Start(x); }); RegisterNotification(); }
protected void Application_Start() { AreaRegistration.RegisterAllAreas(); GlobalConfiguration.Configure(WebApiConfig.Register); FilterConfig.RegisterGlobalFilters(GlobalFilters.Filters); RouteConfig.RegisterRoutes(RouteTable.Routes); BundleConfig.RegisterBundles(BundleTable.Bundles); SqlDependency.Start(Constants.CONNECTIONSTRING); }
private void DtFill(DataTable table, string query) { command.Notification = null; Dependency.AddCommandDependency(command); SqlDependency.Start(Connection.ConnectionString); command.CommandText = query; Connection.Open(); table.Load(command.ExecuteReader()); Connection.Close(); }
protected void Application_Start() { AreaRegistration.RegisterAllAreas(); FilterConfig.RegisterGlobalFilters(GlobalFilters.Filters); RouteConfig.RegisterRoutes(RouteTable.Routes); BundleConfig.RegisterBundles(BundleTable.Bundles); AntiForgeryConfig.UniqueClaimTypeIdentifier = ClaimTypes.NameIdentifier; SqlDependency.Start(ConfigurationManager.ConnectionStrings["MusicProject"].ConnectionString); }
protected void Application_Start() { AreaRegistration.RegisterAllAreas(); FilterConfig.RegisterGlobalFilters(GlobalFilters.Filters); //RouteTable.Routes.MapHubs(); RouteConfig.RegisterRoutes(RouteTable.Routes); WebApiConfig.Register(GlobalConfiguration.Configuration); BundleConfig.RegisterBundles(BundleTable.Bundles); SqlDependency.Start(ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString); }
protected void Application_Start() { SqlDependency.Start(ConfigurationManager.ConnectionStrings["proworldzdbNEWEntities1"].ConnectionString); AreaRegistration.RegisterAllAreas(); WebApiConfig.Register(GlobalConfiguration.Configuration); FilterConfig.RegisterGlobalFilters(GlobalFilters.Filters); RouteConfig.RegisterRoutes(RouteTable.Routes); BundleConfig.RegisterBundles(BundleTable.Bundles); }
private void InitSqlDependency() { LazyInitializer.EnsureInitialized(ref _sqlDependencyInit, () => { SqlDependency.Start(_connectionString); var perm = new SqlClientPermission(PermissionState.Unrestricted); perm.Demand(); return(new object()); }); }
//public void dbEnter(string login, string password) //{ // command.CommandText = "SELECT count(*) FROM [dbo].[Employee] " + // "where [Employee_Login] = '" + login + "' and [Employee_Password] = '" + // password + "'"; // connection.Open(); // IDuser = Convert.ToInt32(command.ExecuteScalar().ToString()); // connection.Close(); //} // Функция на вывод данных из таблицы БД private void dtFill(DataTable table, string query) { command.Notification = null; Dependency.AddCommandDependency(command); SqlDependency.Start(connection.ConnectionString); command.CommandText = query; // Кладем запрос в переменную connection.Open(); // Открываем подключение table.Load(command.ExecuteReader()); // Считывание таблицы баз данных connection.Close(); // ЗАкрываем подключение }
public void Test_DoubleStart_SameConnStr() { Assert.True(SqlDependency.Start(_startConnectionString), "Failed to start listener."); Assert.False(SqlDependency.Start(_startConnectionString), "Expected failure when trying to start listener."); Assert.False(SqlDependency.Stop(_startConnectionString), "Expected failure when trying to completely stop listener."); Assert.True(SqlDependency.Stop(_startConnectionString), "Failed to stop listener."); }
protected void Application_Start() { AreaRegistration.RegisterAllAreas(); RouteConfig.RegisterRoutes(RouteTable.Routes); //Uygulama Başladığında SQL Dependency Çalışır SqlDependency.Start(connString); UnityConfig.RegisterComponents(); }