SqlDependency Event Handler Getting Fired continously - SQL Notification Service

[das]

Hello all,
I am using the SqlDependency to subscribe to any new inserts into
a database table, I enabled the DB to be borker ready and subscrbed to
Query notifications on the database.

My C# Windows service has a simple query that checks if a new entry is
made into a table,
select * from Cast_Member where isMajor = '1'

When I insert a new record into this table with isMajor = 1, then the
event handler gets fired, but doesn't stop there, it continously gets
fired on the same record. Also if I already have a OLD record in the
table with the isMajor = 1, then the event handler gets fired as soon
as I start the windows service - repeatedly.

Here's the code,
------------------------------------------------------------------------------------------------------------------------------------------------

protected override void OnStart(string[] args)
{
CanRequestNotif ications();
NotificationLis tener();

}
private bool CanRequestNotif ications()
{
SqlClientPermis sion permit = new
SqlClientPermis sion(System.Sec urity.Permissio ns.PermissionSt ate.Unrestricte d);
try
{
permit.Demand() ;
return true;
}
catch (System.Excepti on exc)
{
return false;
}
}

private void NotificationLis tener()
{
string mailSQL;
SqlConnection sqlConn;
try
{
this.connection String =
ConfigurationMa nager.AppSettin gs["connectionStri ng"];
mailSQL = "select * from Cast_Member where isMajor =
'1'";

SqlDependency.S top(this.connec tionString);
SqlDependency.S tart(this.conne ctionString);

sqlConn = new SqlConnection(t his.connectionS tring);
sqlCmd = new SqlCommand(mail SQL, sqlConn);
this.GetNotific ationData();
}
catch (Exception e)
{
// handle exception
}
}

private void GetNotification Data()
{
DataSet myDataSet = new DataSet();
sqlCmd.Notifica tion = null;

dependency = new SqlDependency(s qlCmd);
dependency.OnCh ange += new
OnChangeEventHa ndler(dependenc y_OnChange);
using (SqlDataAdapter adapter = new
SqlDataAdapter( sqlCmd))
{
adapter.Fill(my DataSet, "CAST");
DataTable mailLogTbl = (DataTable)myDa taSet.Tables[0];

foreach (DataRow dataRow in mailLogTbl.Rows )
{
int castID = (int)dataRow[0];
logFile.WriteLi ne("New Entry into CAST_MEMBER table: " +
castID.ToString ());
}

}
}
private void dependency_OnCh ange(object sender,
SqlNotification EventArgs e)
{

SqlDependency dependency = (SqlDependency) sender;
dependency.OnCh ange -= dependency_OnCh ange;
this.GetNotific ationData();
}
protected override void OnStop()
{
dependency.OnCh ange -= dependency_OnCh ange;
SqlDependency.S top(this.connec tionString);
}
------------------------------------------------------------------------------------------------------------------------------------------------

If anyone sees any problems with this code please point it out. As you
can see for every new entry into the table I write it into a log file,
so my log file has the same exact information multiple times for just
one new inserted record into the table.

thanks in advance. (btw, I copied the above code from MSDN, so its not
mine except for writing it to log)