資源簡介
實時監控數據庫變化更新前臺顯示,可以實現你修改數據庫的信息,就可以在前臺直接看到變化。并包含詳細的代碼注釋以及知識點整理。
代碼片段和文件信息
using?System;
using?System.Collections.Generic;
using?System.Configuration;
using?System.Data.SqlClient;
using?System.Linq;
using?System.Web;
using?System.Web.Http;
using?System.Web.Mvc;
using?System.Web.Optimization;
using?System.Web.Routing;
namespace?DBChangeNotifyDemo
{
????//?注意:?有關啟用?IIS6?或?IIS7?經典模式的說明,
????//?請訪問?http://go.microsoft.com/?linkId=9394801
????public?class?MvcApplication?:?System.Web.HttpApplication
????{
????????protected?void?Application_Start()
????????{
????????????AreaRegistration.RegisterAllAreas();
????????????WebApiConfig.Register(GlobalConfiguration.Configuration);
????????????FilterConfig.RegisterGlobalFilters(GlobalFilters.Filters);
????????????RouteConfig.RegisterRoutes(RouteTable.Routes);
????????????BundleConfig.RegisterBundles(BundleTable.Bundles);
????????????AuthConfig.RegisterAuth();
????????????//啟動用于接收依賴項更改通知的偵聽器?該通知來自由連接字符串指定的?SQL?Server?實例
????????????//使用下面方法的前提是將對應的數據庫設置為ENABLE_BROKER?設置方法就是在數據庫中執行如下兩句:
????????????//ALTER?DATAbase?DBName?SET?NEW_BROKER?WITH?ROLLBACK?IMMEDIATE;
????????????//ALTER?DATAbase?DBName?SET?ENABLE_BROKER;
????????????SqlDependency.Start(ConfigurationManager.ConnectionStrings[“DefaultConnection“].ConnectionString);?
????????}
????????protected?void?Application_End()
????????{
????????????//關閉用于接收依賴項更改通知的偵聽器
????????????SqlDependency.Stop(ConfigurationManager.ConnectionStrings[“DefaultConnection“].ConnectionString);
????????}
????}
}
?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????文件????3145728??2014-12-26?22:23??DBChangeNotifyDemo\DBChangeNotifyDemo\App_Data\DBChangeNotify.mdf
?????文件????4784128??2014-12-26?22:23??DBChangeNotifyDemo\DBChangeNotifyDemo\App_Data\DBChangeNotify_log.ldf
?????文件???????1020??2014-12-15?11:58??DBChangeNotifyDemo\DBChangeNotifyDemo\App_Start\AuthConfig.cs
?????文件???????2178??2014-12-15?11:58??DBChangeNotifyDemo\DBChangeNotifyDemo\App_Start\BundleConfig.cs
?????文件????????284??2014-12-15?11:58??DBChangeNotifyDemo\DBChangeNotifyDemo\App_Start\FilterConfig.cs
?????文件????????609??2014-12-15?11:58??DBChangeNotifyDemo\DBChangeNotifyDemo\App_Start\RouteConfig.cs
?????文件????????894??2014-12-15?11:58??DBChangeNotifyDemo\DBChangeNotifyDemo\App_Start\WebApiConfig.cs
?????文件?????105544??2014-12-15?11:58??DBChangeNotifyDemo\DBChangeNotifyDemo\bin\Antlr3.Runtime.dll
?????文件??????33280??2014-12-26?22:27??DBChangeNotifyDemo\DBChangeNotifyDemo\bin\DBChangeNotifyDemo.dll
?????文件??????79360??2014-12-26?22:27??DBChangeNotifyDemo\DBChangeNotifyDemo\bin\DBChangeNotifyDemo.pdb
?????文件??????66160??2014-12-15?11:58??DBChangeNotifyDemo\DBChangeNotifyDemo\bin\de\Microsoft.Data.Edm.resources.dll
?????文件?????251504??2014-12-15?11:58??DBChangeNotifyDemo\DBChangeNotifyDemo\bin\de\Microsoft.Data.OData.resources.dll
?????文件??????17512??2014-12-15?11:58??DBChangeNotifyDemo\DBChangeNotifyDemo\bin\de\System.Spatial.resources.dll
?????文件??????40960??2014-12-15?11:58??DBChangeNotifyDemo\DBChangeNotifyDemo\bin\DotNetOpenAuth.AspNet.dll
?????文件??????84709??2014-12-15?11:58??DBChangeNotifyDemo\DBChangeNotifyDemo\bin\DotNetOpenAuth.AspNet.xm
?????文件?????227328??2014-12-15?11:58??DBChangeNotifyDemo\DBChangeNotifyDemo\bin\DotNetOpenAuth.Core.dll
?????文件?????600385??2014-12-15?11:58??DBChangeNotifyDemo\DBChangeNotifyDemo\bin\DotNetOpenAuth.Core.xm
?????文件??????17920??2014-12-15?11:58??DBChangeNotifyDemo\DBChangeNotifyDemo\bin\DotNetOpenAuth.OAuth.Consumer.dll
?????文件??????25168??2014-12-15?11:58??DBChangeNotifyDemo\DBChangeNotifyDemo\bin\DotNetOpenAuth.OAuth.Consumer.xm
?????文件??????55808??2014-12-15?11:58??DBChangeNotifyDemo\DBChangeNotifyDemo\bin\DotNetOpenAuth.OAuth.dll
?????文件?????104764??2014-12-15?11:58??DBChangeNotifyDemo\DBChangeNotifyDemo\bin\DotNetOpenAuth.OAuth.xm
?????文件?????268288??2014-12-15?11:58??DBChangeNotifyDemo\DBChangeNotifyDemo\bin\DotNetOpenAuth.OpenId.dll
?????文件??????89600??2014-12-15?11:58??DBChangeNotifyDemo\DBChangeNotifyDemo\bin\DotNetOpenAuth.OpenId.RelyingParty.dll
?????文件?????225464??2014-12-15?11:58??DBChangeNotifyDemo\DBChangeNotifyDemo\bin\DotNetOpenAuth.OpenId.RelyingParty.xm
?????文件?????631411??2014-12-15?11:58??DBChangeNotifyDemo\DBChangeNotifyDemo\bin\DotNetOpenAuth.OpenId.xm
?????文件????1116760??2014-12-15?11:58??DBChangeNotifyDemo\DBChangeNotifyDemo\bin\Entityfr
?????文件????1138045??2014-12-15?11:58??DBChangeNotifyDemo\DBChangeNotifyDemo\bin\Entityfr
?????文件??????65632??2014-12-15?11:58??DBChangeNotifyDemo\DBChangeNotifyDemo\bin\es\Microsoft.Data.Edm.resources.dll
?????文件?????246880??2014-12-15?11:58??DBChangeNotifyDemo\DBChangeNotifyDemo\bin\es\Microsoft.Data.OData.resources.dll
?????文件??????17496??2014-12-15?11:58??DBChangeNotifyDemo\DBChangeNotifyDemo\bin\es\System.Spatial.resources.dll
............此處省略921個文件信息
評論
共有 條評論