How Do I Make Signalr Works With Oracle

See more:

Oracle

SignalR

CODE:

public class JobInfoRepository
{
OracleDependency oracleDependency = null;
public static bool IsNotified = false;

public IEnumerable<jobinfo> GetData()
{
try
{
using (var oracleConnection = new OracleConnection(ConfigurationManager.ConnectionStrings["WBConnectionString"].ConnectionString))
{
oracleConnection.Open();
using (OracleCommand oracleCommand = new OracleCommand(@"SELECT [CA_ID],[CA_SUMMARY],[CA_DESCRIPTION] FROM [WB_CASES]", oracleConnection))
{
// Make sure the command object does not already have
// a notification object associated with it.
OracleDependency.Port = 1521;

oracleDependency = new OracleDependency(oracleCommand);
oracleCommand.Notification.IsNotifiedOnce = false;

//oracleCommand.AddRowid = true;

oracleDependency.OnChange += new OnChangeEventHandler(dependency_OnChange);

//OracleDependency.GetOracleDependency(Convert.ToString(ConfigurationManager.ConnectionStrings["WBConnectionString"].ConnectionString));

if (oracleConnection.State == ConnectionState.Closed)
oracleConnection.Open();

List<jobinfo> jobInfoList = new List<jobinfo>();

DataTable _DataTable = new DataTable();

OracleDataAdapter oracleDataAdapter = new OracleDataAdapter(oracleCommand);
oracleDataAdapter.Fill(_DataTable);

for (int i = 0; i < _DataTable.Rows.Count; i++)
{
JobInfo jobInfo = new JobInfo();
jobInfo.CA_ID = Convert.ToInt32(_DataTable.Rows[i][0]);
jobInfo.CA_SUMMARY = Convert.ToString(_DataTable.Rows[i][1]);
jobInfo.CA_DESCRIPTION = Convert.ToString(_DataTable.Rows[i][2]);
jobInfoList.Add(jobInfo);
jobInfo = null;
}

return jobInfoList;
}
}
}
catch (Exception ex)
{
throw ex;
}

}

private void dependency_OnChange(object sender, OracleNotificationEventArgs e)
{
new GetRecordsHub().ShowRecords();
}
}

public class JobInfo
{
public int CA_ID { get; set; }

public string CA_SUMMARY { get; set; }

public string CA_DESCRIPTION { get; set; }
}



Problem: Oracledependency object is not calling event "dependency_OnChange".