public static void SqlTrigger()
{
using (var connection = new SqlConnection(@"context connection=true"))
{
connection.Open();
switch (SqlContext.TriggerContext.TriggerAction)
{
case TriggerAction.Insert:
{
var command = new SqlCommand(@"SELECT * FROM INSERTED;", connection);
var reader = command.ExecuteReader();
while (reader.Read())
{
var inserted = new Login.Sqlserver.Login(reader);
repo.Apply(inserted, "POST", false);
}
reader.Close();
}
break;
case TriggerAction.Update:
{
var command = new SqlCommand(@"SELECT * FROM INSERTED;", connection);
var reader = command.ExecuteReader();
while (reader.Read())
{
var inserted = new Login.Sqlserver.Login(reader);
repo.Apply(inserted, "PUT", false);
}
reader.Close();
}
break;
case TriggerAction.Delete:
{
var commandDeleted = new SqlCommand(@"SELECT * FROM DELETED;", connection);
var reader = commandDeleted.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
var deleted = new Login.Sqlserver.Login(reader);
repo.Delete(deleted, false);
}
reader.Close();
}
else
{
SqlContext.Pipe.Send("No rows affected.");
}
}
break;
default:
break;
}
}
}