EventLoader.EventSchema Property

Article
12/03/2008

Sets the event schema for the EventLoader object.

Namespace: Microsoft.SqlServer.NotificationServices
Assembly: Microsoft.SqlServer.NotificationServices (in microsoft.sqlserver.notificationservices.dll)

Syntax

'Declaration
Public Property EventSchema As String

public string EventSchema { get; set; }

public:
property String^ EventSchema {
    String^ get ();
    void set (String^ value);
}

/** @property */
public String get_EventSchema ()

/** @property */
public void set_EventSchema (String value)

public function get EventSchema () : String

public function set EventSchema (value : String)

Remarks

This property expects a string representing the path and name of a SQL-annotated XML schema file. This schema file must contain the event class schema, and is used to map the event data in the XML document to the event fields.

Example

The following example shows how to map the event element to the event class named MyEventClassName. The StockSymbol and StockPrice elements are mapped to event fields of the same name.

<xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlns:sql="urn:schemas-microsoft-com:mapping-schema">
   <xsd:element name="event" sql:relation="MyEventClassName">
      <xsd:complexType>
         <xsd:sequence>
            <xsd:element name="StockSymbol" type="xsd:string" />
            <xsd:element name="StockPrice" type="xsd:float" />
         </xsd:sequence>
      </xsd:complexType>
   </xsd:element>
</xsd:schema>

Thread Safety

Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Platforms

Development Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

Target Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

Share via