1.需求数据库表添加,修改,删除数据,触发器生效,推送数据数据到WCF接口
a)创建WCF服务,发布服务
b)启用数据库CLR功能,默认是关闭状态
EXEC sp_configure 'show advanced options' , '1';
go
reconfigure;
go
EXEC sp_configure 'clr enabled' , '1'
go
reconfigure;
-- Turn advanced options back off
EXEC sp_configure 'show advanced options' , '0';
go
c)设置数据库安全选项
use custdb
ALTER DATABASE custdb SET TRUSTWORTHY ON
reconfigure
d)创建WCF触发器运行环境
CREATE ASSEMBLY
SMDiagnostics from
'C:\Windows\Microsoft.NET\Framework\v3.0\Windows Communication Foundation\SMdiagnostics.dll'
with permission_set = UNSAFE
GO
CREATE ASSEMBLY
[System.Web] from
'C:\Windows\Microsoft.NET\Framework\v2.0.50727\System.Web.dll'
with permission_set = UNSAFE
GO
CREATE ASSEMBLY
[System.Messaging] from
'C:\Windows\Microsoft.NET\Framework\v2.0.50727\System.Messaging.dll&#