asp.net - Create DB trigger to crud operation for audit -

asp.net - Create DB trigger to crud operation for audit -

i need create db trigger azure db when user click alter in table trigger write event table,write changed ,timestemp etc.

currently have 2 basic questions.

1.this model

public class userroles { public int id { get; set; } public string username { get; set; } public boolean address { get; set; } public boolean email { get; set; } public boolean work { get; set; } public boolean home { get; set; } } public class userrolesdbcontext : dbcontext { public userrolesdbcontext() : base("defaultconnection") { this.database.connection.connectionstring = my.getdbconnectionstring(); if (!string.isnullorempty(this.database.connection.connectionstring)) { this.database.sqlquery("here set sql") } } public dbset<userroles> userrolescollection { get; set; } }

should set trigger (in sqlquery) if want created when deploy cloud service ?currenlty db created in azure when im doing deployment...

2.assume want re-create fields db triger userroles table userrolescopy , when changed audit, how should write sql code?

my schema name :userdb myorginal table is:userroles want re-create userrolecopy

i new topic , i've read next page in msdn

http://msdn.microsoft.com/en-us/library/ms189799%28v=sql.120%29.aspx

-- windows azure sql database syntax trigger on insert, update, or delete statement table or view (dml trigger)

create trigger [ schema_name . ]trigger_name on { table | view } [ <dml_trigger_option> [ ,...n ] ] { | after | instead of } { [ insert ] [ , ] [ update ] [ , ] [ delete ] } { sql_statement [ ; ] [ ,...n ] [ ; ] > } <dml_trigger_option> ::= [ execute clause ]

you can utilize next method audit table alter :

use database audit specifications

create server audit , database audit specification

cdc (change info capture)

about alter info capture

dml trigger

>

create trigger yourschema.triggername on yourtable after insert, update, delete begin -- log deleted rows , old value in updated rows insert logtable(username, columns) select current_user, columns deleted -- log inserted row , new value in updated rows insert logtable(username, columns) select current_user, columns inserted end

asp.net sql-server asp.net-mvc azure sql-azure