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();
}
internal ConnectionConfiguration(IDbProviderFactory providerFactory, string connectionString)
{
Debug.Assert(!String.IsNullOrEmpty(connectionString), "connectionString should not be null");
ProviderFactory = providerFactory;
ConnectionString = connectionString;
}
public SqlSender(string connectionString, string tableName, TraceSource traceSource, IDbProviderFactory dbProviderFactory)
{
_connectionString = connectionString;
_insertDml = BuildInsertString(tableName);
_trace = traceSource;
_dbProviderFactory = dbProviderFactory;
}
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 SqlSender(string connectionString, string tableName, ILogger logger, IDbProviderFactory dbProviderFactory)
{
_connectionString = connectionString;
_insertDml = BuildInsertString(tableName);
_logger = logger;
_dbProviderFactory = dbProviderFactory;
}
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();
}
