private string SqlCommand(SqlDependencyExOptions options)
{
return(string.Format(
SQL_FORMAT_RECEIVE_EVENT,
options.DatabaseName,
ConversationQueueName,
CommandTimeout / 2,
options.SchemaName));
}
public SqlDependencyEx(SqlDependencyExOptions opts,
NotificationTypes listenerType = NotificationTypes.Insert | NotificationTypes.Update | NotificationTypes.Delete,
bool receiveDetails = true,
int identity = 1)
{
ConnectionOptions = opts;
ConnectionOptions.SchemaName = opts.SchemaName ?? "dbo";
Notifications = listenerType;
DetailsIncluded = receiveDetails;
Identity = identity;
}