对于.net来讲触发器也是方法,在上方标注[Microsoft.SqlServer.Server.SqlTrigger]标签(只我这样翻译)。
我们看一个小例子
using
System;
using System.Data;
using System.Data.Sql;
using Microsoft.SqlServer.Server;
using System.Data.SqlClient;
public partial class Triggers
{
//Name触发器的名字
//Target触发器对应表
//Event可以是{ FOR | AFTER | INSTEAD OF } { [ INSERT ] [ , ] [ UPDATE ] [ , ] [ DELETE ] }
[Microsoft.SqlServer.Server.SqlTrigger(Name = "NameInfoTrigger", Target = "NameInfo", Event = "FOR UPDATE")]
public static void GetChange()
{
using (SqlConnection cn = new SqlConnection())
{
cn.ConnectionString = "context connection=true";
cn.Open();
using (SqlCommand cmd = cn.CreateCommand())
{
cmd.CommandText = "insert into ChangeHistory select b.name + '->' + a.name,getdate() from INSERTED a JOIN DELETED b ON a.id = b.id";
SqlContext.Pipe.ExecuteAndSend(cmd);
}
}
}
}
using System.Data;
using System.Data.Sql;
using Microsoft.SqlServer.Server;
using System.Data.SqlClient;
public partial class Triggers
{
//Name触发器的名字
//Target触发器对应表
//Event可以是{ FOR | AFTER | INSTEAD OF } { [ INSERT ] [ , ] [ UPDATE ] [ , ] [ DELETE ] }
[Microsoft.SqlServer.Server.SqlTrigger(Name = "NameInfoTrigger", Target = "NameInfo", Event = "FOR UPDATE")]
public static void GetChange()
{
using (SqlConnection cn = new SqlConnection())
{
cn.ConnectionString = "context connection=true";
cn.Open();
using (SqlCommand cmd = cn.CreateCommand())
{
cmd.CommandText = "insert into ChangeHistory select b.name + '->' + a.name,getdate() from INSERTED a JOIN DELETED b ON a.id = b.id";
SqlContext.Pipe.ExecuteAndSend(cmd);
}
}
}
}
右键部署
数据库里的两张表
我执行两条UPDATE语句
update
[
NameInfo
]
set
[
name
]
=
'
David
'
where
id
=
1
update [ nameinfo ] set [ name ] = ' Fan ' where id = 2
结果
update [ nameinfo ] set [ name ] = ' Fan ' where id = 2
再执行两条
update
[
NameInfo
]
set
[
name
]
=
'
*David*
'
where
id
=
1
update [ nameinfo ] set [ name ] = ' *Fan* ' where id = 2
再看结果
update [ nameinfo ] set [ name ] = ' *Fan* ' where id = 2
题外话:上午比较不忙,随手写了第三篇。都这个时候了公司领导层还在想搞什么视频分享,国内的视频分享类网站已经倒了一批又一批了,仅有一些苟活于世,表面大红大紫的日子也未必好过,VC哪能那么容易就掏钱出来给你烧,哎!最近比较郁闷,忙完手上这点活,想换份工作了。