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; }