public void TestProfiledSqlQuery() { var profiled = new GlimpseDbConnection(_connection); var result = profiled.QuerySql<int>("SELECT @p --GLIMPSE", new { p = 1 }).First(); Assert.AreEqual((int)1, result); }
public void TestProfiledStoredProcWithParameters() { using (var connection = _connectionStringBuilder.OpenWithTransaction()) { connection.ExecuteSql("CREATE PROC InsightTestProcGlimpse (@Value int = 5) AS SELECT Value=@Value"); var profiled = new GlimpseDbConnection(connection); var result = profiled.Query<int>("InsightTestProcGlimpse", new { Value = 1 }).First(); Assert.AreEqual((int)1, result); } }
public GlimpseDbTransaction(DbTransaction transaction, GlimpseDbConnection connection) { InnerTransaction = transaction; InnerConnection = connection; TransactionId = Guid.NewGuid(); if (MessageBroker != null && TimerStrategy != null) { timerTimeSpan = TimerStrategy.Start(); MessageBroker.Publish( new TransactionBeganMessage(connection.ConnectionId, TransactionId, transaction.IsolationLevel) .AsTimedMessage(timerTimeSpan)); } }
public GlimpseDbTransaction(DbTransaction transaction, GlimpseDbConnection connection) { InnerTransaction = transaction; InnerConnection = connection; TransactionId = Guid.NewGuid(); if (MessageBroker != null && TimerStrategy != null) { timerTimeSpan = TimerStrategy.Start(); MessageBroker.Publish( new TransactionBeganMessage(connection.ConnectionId, TransactionId, transaction.IsolationLevel) .AsTimedMessage(timerTimeSpan)); } }
public void TestBulkCopyWithInterface() { const int ItemCount = 10; // build test data InsightTestData[] array = new InsightTestData[ItemCount]; for (int j = 0; j < ItemCount; j++) array[j] = new InsightTestData() { Int = j }; var profiled = new GlimpseDbConnection((DbConnection)Connection()); using (var i = profiled.OpenWithTransactionAs<ICanBulkCopy>()) { i.BulkCopy("BulkCopyData", array); } }
public GlimpseDbTransaction(DbTransaction transaction, GlimpseDbConnection connection, IMessageBroker messageBroker, IExecutionTimer timerStrategy) : this(transaction, connection) { MessageBroker = messageBroker; TimerStrategy = timerStrategy; }
public GlimpseDbCommand(DbCommand innerCommand, GlimpseDbConnection connection, IMessageBroker messageBroker, IExecutionTimer timerStrategy) : this(innerCommand, connection) { MessageBroker = messageBroker; TimerStrategy = timerStrategy; }
public GlimpseDbCommand(DbCommand innerCommand, GlimpseDbConnection connection) : this(innerCommand) { InnerConnection = connection; }
public GlimpseDbCommand(DbCommand innerCommand, GlimpseDbConnection connection, IMessageBroker messageBroker, IExecutionTimer timerStrategy) : this(innerCommand, connection) { MessageBroker = messageBroker; TimerStrategy = timerStrategy; }
public GlimpseDbCommand(DbCommand innerCommand, GlimpseDbConnection connection) : this(innerCommand) { InnerConnection = connection; }
public GlimpseDbTransaction(DbTransaction transaction, GlimpseDbConnection connection, IMessageBroker messageBroker, IExecutionTimer timerStrategy) : this(transaction, connection) { MessageBroker = messageBroker; TimerStrategy = timerStrategy; }