max-mulawa

using System;
using System.Collections.Generic;
using System.Data.SqlClient;
using Microsoft.SqlServer.Server;
using Weather.com.Client;
using Weather.com.Client.WeatherConditions.Forecasts;
using Weather.com.Client.WeatherConditions.Location;

namespace Mulawa.SqlServer.CLRTriggers
{

max-mulawa

use master;
GO
CREATE DATABASE TriggerDatabase;
GO
use TriggerDatabase;
GO
CREATE TABLE dbo.Customers
( 
	CustomerName Varchar(10) NOT NULL 
)

max-mulawa

CREATE VIEW dbo.vCustomers
AS
  SELECT CustomerName FROM dbo.Customers
GO
CREATE TRIGGER dbo.vCustomers_AfterDelete
    ON dbo.vCustomers
INSTEAD OF DELETE
AS
BEGIN
DELETE c

max-mulawa

CREATE TRIGGER dbo.Customers_AfterUpdate
    ON dbo.Customers
AFTER UPDATE
AS
BEGIN
  PRINT 'After Update'
END
GO
DISABLE TRIGGER dbo.Customers_AfterUpdate ON dbo.Customers;
GO

max-mulawa

CREATE TRIGGER dbo.Customers_AfterUpdate
    ON dbo.Customers
AFTER UPDATE
AS
BEGIN
  PRINT 'After Update'
END
GO
DISABLE TRIGGER dbo.Customers_AfterUpdate 
     ON dbo.Customers;

max-mulawa

SELECT t.*, te.*
  FROM sys.triggers t
 INNER JOIN sys.trigger_events te
    ON t.object_id = te.object_id

max-mulawa

CREATE TABLE dbo.CustomerNameAudit
( 
  CustomerName Varchar(10) NOT NULL, 
  ChangeDate DATETIME DEFAULT(GETDATE()) NOT NULL
)
GO
CREATE TRIGGER dbo.Customers_AfterUpdateInsertAudit
    ON dbo.Customers
 AFTER UPDATE, INSERT
AS

max-mulawa

CREATE TRIGGER dbo.Customers_stopUpdates
    ON dbo.Customers
 AFTER UPDATE
AS
BEGIN
  RAISERROR ('Cutomers table cannot be updated.', 16, 1)
  ROLLBACK TRAN
END 
GO
DROP TRIGGER dbo.Customers_stopUpdates;

max-mulawa

CREATE TRIGGER dbo.Customers_stopUpdates
    ON dbo.Customers
INSTEAD OF UPDATE
AS
BEGIN
  RAISERROR ('Cutomers table cannot be updated.', 16, 1)
  ROLLBACK TRAN
END 
GO
DROP TRIGGER dbo.Customers_stopUpdates

max-mulawa

WeatherClient client = new WeatherClient(
                       "[Partner Id here]"
                    , "[License Key here]");
List<Location>= client.GetLocation("Warsaw,Poland");