Assembly: Microsoft.SqlServer.Smo (in microsoft.sqlserver.smo.dll)
Notification fields store data that subscribers are interested in or that are otherwise used to generate the final notification.
Defining the custom fields for a notification class requires that you know what data you want to send, and must match the data produced by the subscription rule that generates notifications.
For each notification field, you must define the field name and data type.
If you add or delete a notification field, updating the application deletes and re-creates the notification class to which it corresponds. This includes dropping and re-creating the database tables used by this notification class. Make sure to back up your application database before updating the application.
The following examples show how to define a notification field and add it to the collection of notification fields for a notification class:
// Define a LeavingFrom notification field and use it for grouping // digest messages. Add it to the end of the field collection NotificationField notificationOrgin = new NotificationField(flightNotifications, "LeavingFrom"); notificationOrgin.Type = "nvarchar(6)"; notificationOrgin.DigestGrouping = true; flightNotifications.NotificationFields.Add(notificationOrgin);