Exposing MySql Events

[Mr Wakazula]

Good morning,

Currently, an external application (like a service) must poll a database in order to detect changes (to data, to tables,…). In many ways, this is inefficient. It would be much more useful to construct an event driven model whereby a MySql trigger could raise a Microsoft event inside an application's .Net connector.

I've tried to hack a work around whereby a MySql trigger would terminate (KILL CONNECTION) a specified connection. The hope was that this would intern raise the MySqlConnection.StateChange event. Unfortunately, this was not the case.

I would be interested in anyone's thoughts on this matter.



Edited 2 time(s). Last edit at 08/31/2006 09:07AM by Mr Wakazula.