public void Update(ITransactionHandler transactionHandler, IDbProviderFactory providerFactory, MenuData menuData) { if (menuData.DataStateManager.GetState(menuData) == DataStateManagerState.Updated) { providerFactory.EstablishTransaction(transactionHandler, menuData); using (IDbCommand command = transactionHandler.Connection.CreateCommand()) { command.CommandText = "vte.USP_Menu"; command.CommandType = CommandType.StoredProcedure; command.Transaction = transactionHandler.Transaction.InnerTransaction; IDataParameter timestamp = Util.CreateParameter(providerFactory, "timestamp", DbType.DateTime); timestamp.Direction = ParameterDirection.Output; command.Parameters.Add(timestamp); Util.AddParameter(providerFactory, command.Parameters, "id", DbType.Int32, Util.GetParameterValue(menuData.MenuId)); Util.AddParameter(providerFactory, command.Parameters, "title", DbType.String, Util.GetParameterValue(menuData.Title)); Util.AddParameter(providerFactory, command.Parameters, "description", DbType.String, Util.GetParameterValue(menuData.Description)); Util.AddParameter(providerFactory, command.Parameters, "sortOrder", DbType.Int32, Util.GetParameterValue(menuData.SortOrder)); command.ExecuteNonQuery(); menuData.UpdateTimestamp = (DateTime)timestamp.Value; } } }
internal ConnectionConfiguration(IDbProviderFactory providerFactory, string connectionString) { Debug.Assert(!String.IsNullOrEmpty(connectionString), "connectionString should not be null"); ProviderFactory = providerFactory; ConnectionString = connectionString; }
public IDbOperation CreateDbOperation(string connectionString, string commandText, TraceSource traceSource, IDbProviderFactory dbProviderFactory, params IDataParameter[] parameters) { return(new DbOperation(connectionString, commandText, traceSource, dbProviderFactory, parameters)); }
public SqlSender(string connectionString, string tableName, ILogger logger, IDbProviderFactory dbProviderFactory) { _connectionString = connectionString; _insertDml = BuildInsertString(tableName); _logger = logger; _dbProviderFactory = dbProviderFactory; }
public DbOperation(string connectionString, string commandText, ILogger logger, IDbProviderFactory dbProviderFactory) { ConnectionString = connectionString; CommandText = commandText; Logger = logger; _dbProviderFactory = dbProviderFactory; }
internal static Database OpenConnectionStringInternal( IDbProviderFactory providerFactory, string connectionString ) { return(new Database(() => providerFactory.CreateConnection(connectionString))); }
public SqlSender(string connectionString, string tableName, TraceSource traceSource, IDbProviderFactory dbProviderFactory) { _connectionString = connectionString; _insertDml = BuildInsertString(tableName); _trace = traceSource; _dbProviderFactory = dbProviderFactory; }
/// <summary> /// Initializes a new instance of the <see cref="OracleMessageBus"/> class. /// </summary> /// <param name="resolver">The resolver to use.</param> /// <param name="configuration">The Oracle scale-out configuration options.</param> public OracleMessageBus(IDependencyResolver resolver, OracleScaleoutConfiguration configuration) : base(resolver, configuration) { if (configuration == null) { throw new ArgumentNullException("configuration"); } if (configuration.UseOracleDependency && configuration.OracleDependencyPort.HasValue) { OracleDependency.Port = configuration.OracleDependencyPort.Value; } _connectionString = configuration.ConnectionString; _dbProviderFactory = OracleClientFactory.Instance.AsIDbProviderFactory(configuration.ConnectionString); var traceManager = resolver.Resolve <ITraceManager>(); _trace = traceManager[typeof(OracleMessageBus).Name]; _dbOperationFactory = new DbOperationFactory(); _observableDbOperationFactory = new ObservableDbOperationFactory(null, new OracleDependencyManager(_dbProviderFactory, _trace), new SignalrDbDependencyFactory()); _useOracleDependency = configuration.UseOracleDependency; Task.Run(() => Initialize()); }
/// <summary> /// Initializes a new instance of the DbDalc for specified factory and connection string. /// </summary> public DbDalc(IDbProviderFactory factory, string connectionStr) { DbFactory = factory; Connection = factory.CreateConnection(); Connection.ConnectionString = connectionStr; CommandGenerator = new DbCommandGenerator(factory); }
public DbOperation(string connectionString, string commandText, TraceSource traceSource, IDbProviderFactory dbProviderFactory) { ConnectionString = connectionString; CommandText = commandText; Trace = traceSource; _dbProviderFactory = dbProviderFactory; }
public void Update(ITransactionHandler transactionHandler, IDbProviderFactory providerFactory, InvitationData invitationData) { if (invitationData.DataStateManager.GetState(invitationData) == DataStateManagerState.Updated) { providerFactory.EstablishTransaction(transactionHandler, invitationData); using (IDbCommand command = transactionHandler.Connection.CreateCommand()) { command.CommandText = "vte.USP_Invitation"; command.CommandType = CommandType.StoredProcedure; command.Transaction = transactionHandler.Transaction.InnerTransaction; IDataParameter timestamp = Util.CreateParameter(providerFactory, "timestamp", DbType.DateTime); timestamp.Direction = ParameterDirection.Output; command.Parameters.Add(timestamp); Util.AddParameter(providerFactory, command.Parameters, "id", DbType.Guid, Util.GetParameterValue(invitationData.InvitationId)); Util.AddParameter(providerFactory, command.Parameters, "invitee", DbType.String, Util.GetParameterValue(invitationData.Invitee)); Util.AddParameter(providerFactory, command.Parameters, "title", DbType.String, Util.GetParameterValue(invitationData.Title)); Util.AddParameter(providerFactory, command.Parameters, "note", DbType.String, Util.GetParameterValue(invitationData.Note)); Util.AddParameter(providerFactory, command.Parameters, "eventDate", DbType.Date, Util.GetParameterValue(invitationData.EventDate)); Util.AddParameter(providerFactory, command.Parameters, "rsvpDue", DbType.Date, Util.GetParameterValue(invitationData.RSVPDueDate)); command.ExecuteNonQuery(); invitationData.UpdateTimestamp = (DateTime)timestamp.Value; } } }
public IEnumerable <InvitationData> GetAll(ISettings settings, IDbProviderFactory providerFactory) { return(m_genericDataFactory.GetData(settings, providerFactory, "vte.SSP_Invitation_All", () => new InvitationData(), Util.AssignDataStateManager )); }
public ObservableDbOperation(string connectionString, string commandText, TraceSource traceSource, IDbProviderFactory dbProviderFactory, IDbBehavior dbBehavior) : base(connectionString, commandText, traceSource, dbProviderFactory) { _dbBehavior = dbBehavior ?? this; InitEvents(); }
public OracleStream(int streamIndex, string connectionString, bool useOracleDependency, TraceSource traceSource, IDbProviderFactory dbProviderFactory, IDbOperationFactory dbOperationFactory, IObservableDbOperationFactory observableDbOperationFactory) { _streamIndex = streamIndex; _trace = traceSource; _tracePrefix = string.Format(CultureInfo.InvariantCulture, "Stream {0} : ", _streamIndex); _cts = new CancellationTokenSource(); _messageCollection = new BlockingCollection <MessageWrapper>(); _sender = new OracleSender(connectionString, _trace, dbProviderFactory, dbOperationFactory); _receiver = new OracleReceiver(connectionString, useOracleDependency, _trace, dbProviderFactory, dbOperationFactory, observableDbOperationFactory); _receiver.Queried += () => { if (Queried != null) { Queried(); } }; _receiver.Faulted += ex => { if (Faulted != null) { Faulted(ex); } }; _receiver.Received += OnReceived; StartReceiving(_cts.Token); }
public void Create(ITransactionHandler transactionHandler, IDbProviderFactory providerFactory, InvitationResponseData responseData) { if (responseData.DataStateManager.GetState(responseData) == DataStateManagerState.New) { providerFactory.EstablishTransaction(transactionHandler, responseData); using (IDbCommand command = transactionHandler.Connection.CreateCommand()) { command.CommandText = "vte.ISP_InvitationResponse"; command.CommandType = CommandType.StoredProcedure; command.Transaction = transactionHandler.Transaction.InnerTransaction; IDataParameter id = Util.CreateParameter(providerFactory, "id", DbType.Int32); id.Direction = ParameterDirection.Output; command.Parameters.Add(id); IDataParameter timestamp = Util.CreateParameter(providerFactory, "timestamp", DbType.DateTime); timestamp.Direction = ParameterDirection.Output; command.Parameters.Add(timestamp); Util.AddParameter(providerFactory, command.Parameters, "invitationId", DbType.Guid, Util.GetParameterValue(responseData.InvitationId)); Util.AddParameter(providerFactory, command.Parameters, "isAttending", DbType.Boolean, Util.GetParameterValue(responseData.IsAttending)); Util.AddParameter(providerFactory, command.Parameters, "attendeeCount", DbType.Int16, Util.GetParameterValue(responseData.AttendeeCount)); Util.AddParameter(providerFactory, command.Parameters, "note", DbType.String, Util.GetParameterValue(responseData.Note)); command.ExecuteNonQuery(); responseData.InvitationResponseId = (int)id.Value; responseData.CreateTimestamp = (DateTime)timestamp.Value; } } }
public void Create(ITransactionHandler transactionHandler, IDbProviderFactory providerFactory, MenuCommentData commentData) { if (commentData.DataStateManager.GetState(commentData) == DataStateManagerState.Updated) { providerFactory.EstablishTransaction(transactionHandler, commentData); using (IDbCommand command = transactionHandler.Connection.CreateCommand()) { command.CommandText = "vte.ISP_MenuComment"; command.CommandType = CommandType.StoredProcedure; command.Transaction = transactionHandler.Transaction.InnerTransaction; IDataParameter id = Util.CreateParameter(providerFactory, "id", DbType.Int32); id.Direction = ParameterDirection.Output; command.Parameters.Add(id); IDataParameter timestamp = Util.CreateParameter(providerFactory, "timestamp", DbType.DateTime); timestamp.Direction = ParameterDirection.Output; command.Parameters.Add(timestamp); Util.AddParameter(providerFactory, command.Parameters, "menuId", DbType.Int32, Util.GetParameterValue(commentData.MenuId)); Util.AddParameter(providerFactory, command.Parameters, "text", DbType.String, Util.GetParameterValue(commentData.Text)); Util.AddParameter(providerFactory, command.Parameters, "createUser", DbType.String, Util.GetParameterValue(commentData.CreateUser)); command.ExecuteNonQuery(); commentData.MenuCommentId = (int)id.Value; commentData.CreateTimestamp = (DateTime)timestamp.Value; } } }
public static void SetDb(Type factoryType, DbProviderSettings settings) { var fac = Activator.CreateInstance(factoryType) as IDbProviderFactory; fac.Settings = settings; fac.Update(); if(Factory != null) Factory.Dispose(); Factory = fac; }
public ObservableDbOperation(string connectionString, string commandText, ILogger logger, IDbProviderFactory dbProviderFactory, IDbBehavior dbBehavior) : base(connectionString, commandText, logger, dbProviderFactory) { _dbBehavior = dbBehavior ?? this; _logger = logger; InitEvents(); }
public OracleInstaller(string connectionString, TraceSource traceSource, IDbProviderFactory dbProviderFactory, IDbOperationFactory dbOperationFactory) { _connectionString = connectionString; _trace = traceSource; _dbProviderFactory = dbProviderFactory; _dbOperationFactory = dbOperationFactory; }
public ZDbOperation(string connectionString, string commandText, TraceSource traceSource, IDbProviderFactory dbProviderFactory) { CommandText = commandText; Trace = traceSource; SessionFactoryInfo = SessionFactoryFactory.GetSessionFactoryInfo(connectionString); }
public DbOperation(string connectionString, string commandText, TraceSource traceSource, IDbProviderFactory dbProviderFactory, params IDataParameter[] parameters) : this(connectionString, commandText, traceSource, dbProviderFactory) { if (parameters != null) { _parameters.AddRange(parameters); } }
public DataRepository(DataSourceType dst) { //create correct type of data order IDataOrderFactory dataorderfactory = new DataOrderFactory(dst); _dataOrder = dataorderfactory.getDataOrder(); IDbProviderFactory provider = new DbProviderFactory(_dataOrder); _providerFactory = provider; }
public async Task <IEnumerable <T> > GetData(ISettings settings, IDbProviderFactory providerFactory, string commandText, Func <T> createModelObject, Action <IEnumerable <T> > assignDataStateManager, IEnumerable <IDataParameter> parameters, CommandType commandType) { IEnumerable <T> data = await GetData(settings, providerFactory, commandText, createModelObject, parameters, commandType); if (assignDataStateManager != null) { assignDataStateManager(data); } return(data); }
public DataRepository(string datasource, DataSourceType dst, string uid, string password) { //create correct type of data order IDataOrderFactory dataorderfactory = new DataOrderFactory(datasource, dst, uid, password); _dataOrder = dataorderfactory.getDataOrder(); IDbProviderFactory provider = new DbProviderFactory(_dataOrder); _providerFactory = provider; }
public static void AddParameter( IDbProviderFactory providerFactory, IList parameterCollection, string name, DbType dbType, object value ) { parameterCollection.Add(CreateParameter(providerFactory, name, dbType, value)); }
public OracleSender(string connectionString, TraceSource traceSource, IDbProviderFactory dbProviderFactory, IDbOperationFactory dbOperationFactory) { _connectionString = connectionString; _insertSql = "SIGNALR.PAYLOAD_INSERT"; _traceSource = traceSource; _dbProviderFactory = dbProviderFactory; _dbOperationFactory = dbOperationFactory; }
public IEnumerable <MenuCommentData> GetByMenuId(ISettings settings, IDbProviderFactory providerFactory, int menuId) { IDataParameter parameter = Util.CreateParameter(providerFactory, "menuId", DbType.Int32); parameter.Value = menuId; return(m_genericDataFactory.GetData(settings, providerFactory, "vte.SSP_MenuComment_by_MenuId", () => new MenuCommentData(), Util.AssignDataStateManager, new IDataParameter[] { parameter } )); }
public InvitationData Get(ISettings settings, IDbProviderFactory providerFactory, Guid id) { IDataParameter parameter = Util.CreateParameter(providerFactory, "id", DbType.Guid); parameter.Value = id; return(m_genericDataFactory.GetData(settings, providerFactory, "vte.SSP_Invitation", () => new InvitationData(), Util.AssignDataStateManager, new IDataParameter[] { parameter } ).FirstOrDefault()); }
public static void AddParameter(IDbProviderFactory providerFactory, IList parameterCollection, string name, DbType dbType, Object value) { IDataParameter parameter = CreateParameter(providerFactory, name, dbType); parameter.Value = value; parameterCollection.Add(parameter); }
public static IDataParameter CreateParameter(IDbProviderFactory providerFactory, string name, DbType type) { IDataParameter parameter = providerFactory.CreateParameter(); if (String.IsNullOrEmpty(name) == false) { parameter.ParameterName = name; } parameter.DbType = type; return(parameter); }
public static DbParameter Clone(this DbParameter sourceParameter, IDbProviderFactory dbProviderFactory) { var newParameter = dbProviderFactory.CreateParameter(); newParameter.ParameterName = sourceParameter.ParameterName; newParameter.DbType = sourceParameter.DbType; newParameter.Value = sourceParameter.Value; newParameter.Direction = sourceParameter.Direction; return newParameter; }
public static IDataParameter Clone(this IDataParameter sourceParameter, IDbProviderFactory dbProviderFactory) { var newParameter = dbProviderFactory.CreateParameter(); newParameter.ParameterName = sourceParameter.ParameterName; newParameter.DbType = sourceParameter.DbType; newParameter.Value = sourceParameter.Value; newParameter.Direction = sourceParameter.Direction; return(newParameter); }
public static IDataParameter CreateParameter( IDbProviderFactory providerFactory, string name, DbType dbType, object value ) { IDataParameter parameter = CreateParameter(providerFactory, name, dbType); parameter.Value = value; return(parameter); }
public SqlReceiver(string connectionString, string tableName, Action onQuery, Action<ulong, IList<Message>> onReceived, Action<Exception> onError, TraceSource traceSource, string tracePrefix, IDbProviderFactory dbProviderFactory) { _connectionString = connectionString; _tableName = tableName; _tracePrefix = tracePrefix; _onQuery = onQuery; _onReceived = onReceived; _onError = onError; _trace = traceSource; _dbProviderFactory = dbProviderFactory; _maxIdSql = String.Format(CultureInfo.InvariantCulture, _maxIdSql, SqlMessageBus.SchemaName, _tableName); _selectSql = String.Format(CultureInfo.InvariantCulture, _selectSql, SqlMessageBus.SchemaName, _tableName); }
public SqlReceiver(string connectionString, string tableName, Action onQuery, Action <ulong, IList <Message> > onReceived, Action <Exception> onError, TraceSource traceSource, string tracePrefix, IDbProviderFactory dbProviderFactory) { _connectionString = connectionString; _tableName = tableName; _tracePrefix = tracePrefix; _onQuery = onQuery; _onReceived = onReceived; _onError = onError; _trace = traceSource; _dbProviderFactory = dbProviderFactory; _maxIdSql = String.Format(CultureInfo.InvariantCulture, _maxIdSql, SqlMessageBus.SchemaName, _tableName); _selectSql = String.Format(CultureInfo.InvariantCulture, _selectSql, SqlMessageBus.SchemaName, _tableName); }
public SqlReceiver(string connectionString, string tableName, ILogger logger, string loggerPrefix, IDbProviderFactory dbProviderFactory) { _connectionString = connectionString; _tableName = tableName; _loggerPrefix = loggerPrefix; _logger = logger; _dbProviderFactory = dbProviderFactory; Queried += () => { }; Received += (_, __) => { }; Faulted += _ => { }; _maxIdSql = String.Format(CultureInfo.InvariantCulture, _maxIdSql, SqlMessageBus.SchemaName, _tableName); _selectSql = String.Format(CultureInfo.InvariantCulture, _selectSql, SqlMessageBus.SchemaName, _tableName); }
public SqlStream(int streamIndex, string connectionString, string tableName, Action open, Action<int, ulong, IList<Message>> onReceived, Action<Exception> onError, TraceSource traceSource, IDbProviderFactory dbProviderFactory) { _streamIndex = streamIndex; _trace = traceSource; _tracePrefix = String.Format(CultureInfo.InvariantCulture, "Stream {0} : ", _streamIndex); _sender = new SqlSender(connectionString, tableName, _trace, dbProviderFactory); _receiver = new SqlReceiver(connectionString, tableName, onQuery: () => open(), onReceived: (id, messages) => onReceived(_streamIndex, id, messages), onError: ex => onError(ex), traceSource: _trace, tracePrefix: _tracePrefix, dbProviderFactory: dbProviderFactory); }
public SqlStream(int streamIndex, string connectionString, string tableName, TraceSource traceSource, IDbProviderFactory dbProviderFactory) { _streamIndex = streamIndex; _trace = traceSource; _tracePrefix = String.Format(CultureInfo.InvariantCulture, "Stream {0} : ", _streamIndex); Queried += () => { }; Received += (_, __) => { }; Faulted += _ => { }; _sender = new SqlSender(connectionString, tableName, _trace, dbProviderFactory); _receiver = new SqlReceiver(connectionString, tableName, _trace, _tracePrefix, dbProviderFactory); _receiver.Queried += () => Queried(); _receiver.Faulted += (ex) => Faulted(ex); _receiver.Received += (id, messages) => Received(id, messages); }
internal SqlMessageBus(IStringMinifier stringMinifier, ILoggerFactory loggerFactory, IPerformanceCounterManager performanceCounterManager, IOptions<MessageBusOptions> optionsAccessor, IOptions<SqlScaleoutOptions> scaleoutOptionsAccessor, IDbProviderFactory dbProviderFactory) : base(stringMinifier, loggerFactory, performanceCounterManager, optionsAccessor, scaleoutOptionsAccessor) { var configuration = scaleoutOptionsAccessor.Options; _connectionString = configuration.ConnectionString; _configuration = configuration; _dbProviderFactory = dbProviderFactory; _logger = loggerFactory.CreateLogger<SqlMessageBus>(); ThreadPool.QueueUserWorkItem(Initialize); }
internal SqlMessageBus(IDependencyResolver resolver, SqlScaleoutConfiguration configuration, IDbProviderFactory dbProviderFactory) : base(resolver, configuration) { if (configuration == null) { throw new ArgumentNullException("configuration"); } _connectionString = configuration.ConnectionString; _configuration = configuration; _dbProviderFactory = dbProviderFactory; var traceManager = resolver.Resolve<ITraceManager>(); _trace = traceManager["SignalR." + typeof(SqlMessageBus).Name]; ThreadPool.QueueUserWorkItem(Initialize); }
internal ConnectionConfiguration(IDbProviderFactory providerFactory, string connectionString) { this.ProviderFactory = providerFactory; this.ConnectionString = connectionString; }
protected SqlServerDatabase(ISisoConnectionInfo connectionInfo, IDbProviderFactory dbProviderFactory) : base(connectionInfo, dbProviderFactory) { }
public EmployeeTask(IDbProviderFactory providerfactory) { this._providerfactory = providerfactory; }
/// <summary> /// 刷新数据库提供者 /// </summary> public static void ResetDbProvider() { BaseConfigs.ResetConfig(); DatabaseProvider.ResetDbProvider(); m_connectionstring = null; m_factory = null; m_provider = null; }
public virtual ISisoDatabase CreateDatabase(ISisoConnectionInfo connectionInfo, IDbProviderFactory providerFactory = null) { return new SqlAzureDatabase(connectionInfo, providerFactory ?? new SqlAzureProviderFactory()); }
internal static Database OpenConnectionStringInternal(IDbProviderFactory providerFactory, string connectionString) { return new Database(() => providerFactory.CreateConnection(connectionString)); }
public SqlAzureDatabase(ISisoConnectionInfo connectionInfo, IDbProviderFactory dbProviderFactory) : base(connectionInfo, dbProviderFactory) { }
static SqlCe4DbFactory() { ProviderFactory = new SqlCe4ProviderFactory(); }