asp.net - Create DB trigger to Sql DB -

asp.net - Create DB trigger to Sql DB -

im new db stuff , need create db trigger azure sql db.

i've create mvc5 project model first , have model reflect db table.

public class employee { public int id { get; set; } public string employeename { get; set; } public string empaddress { get; set; } public string empemail { get; set; } public string empphone { get; set; } } public class employeedbcontext : dbcontext { public employeedbcontext() : base("defaultconnection") { } public dbset<employee> employeecollection { get; set; } } }

now want create db trigger , seek following.(i take illustration , adjust it...)

create trigger dbo.triggername on employee after insert, update, delete begin -- log deleted rows , old value insert employeecopy(id ,employeename, empaddress,empemail,empphone) select current_employee, columns deleted -- log inserted row , new value insert employeecopy(id ,employeename, empaddress,empemail,empphone) select current_employee, columns inserted end

i want create new table employeecopy , re-create rows it. so question (i new topic)

1. trigger name? 2.do write insert right ? 3. select current_employee, columns ..here im not sure if right way write it?

your insert into statement may changed (see below) - did not specify status of select => insert rows deleted , inserted tables on each trigger operation.

see more details insert into, example, here.

you should write , test select statement stand-alone query (just run new query window), when you'll expected results - set in trigger's logic.

generally, i'll suggest seek each part of trigger logic stand-alone statements.

create trigger dbo.mytrigger on employee after insert, update, delete begin -- log deleted rows , old value insert employeecopy select (id ,current_employee, empaddress,empemail,empphone) deleted your_conditions_logic_here -- log inserted row , new value insert employeecopy select (id ,current_employee, empaddress,empemail,empphone) inserted your_conditions_logic_here end

asp.net sql sql-server database azure