ADS 11 event notifications to .net client

[Former Member]

I need to receive event notifications created via sp_CreateEvent(....) in an .net (c#) client.

Is waiting for an event ( EXECUTE PROCEDURE sp_WaitForEvent( ‘my_event’, 2000, 0, 0 ); )  - so actually polling - the only way to receive the notification or will AdsConnection.InfoMessage be fired as well?

Thanks

Oskar

[chrisfranz]

Oskar,

  The wait for event call you described above is not a polling mechanism. However, it does tie up a thread waiting for the notification from the server. Our recommended best practice is to create a second thread to wait for events.

  An example of this can be found here.

Chris