I wanna create a trigger using c#. basing on the SQL 2005 Sample, I have
written following code:
[SqlTrigger(Name = "TestForInsert", Target = "[MySchema].[TestTable]",
Event = "FOR INSERT")]
……// c sharp code
when compiling the source code, VS 2005 pops an error which means that it can
not find the object "[MySchema].[TestTable]"
Using the Profiler, I found that when compiling, .Net runtime just adds
square brackets at the Target parameter value. In my code, the target is just
[[MySchema].[TestTable]], but [MySchema] should be a schema
how should i do?