public Task Send(IList<Message> messages)
{
if (messages == null || messages.Count == 0)
{
return TaskAsyncHelper.Empty;
}
var parameter = _dbProviderFactory.CreateParameter();
parameter.ParameterName = "Payload";
parameter.DbType = DbType.Binary;
parameter.Value = SqlPayload.ToBytes(messages);
var operation = new DbOperation(_connectionString, _insertDml, _trace, parameter);
return operation.ExecuteNonQueryAsync();
}
public void DbExceptionThrown()
{
string msg = Guid.NewGuid().ToString("N");
var fakeDbCommand = A.Fake <IDbCommand>();
A.CallTo(() => fakeDbCommand.ExecuteNonQuery()).Throws(new Exception(msg));
A.CallTo(() => fakeDbCommand.ExecuteScalar()).Throws(new Exception(msg));
A.CallTo(() => fakeDbCommand.ExecuteReader()).Throws(new Exception(msg));
var fakeConnection = A.Fake <IDbConnection>();
A.CallTo(() => fakeConnection.CreateCommand())
.Returns(fakeDbCommand);
IDbProviderFactory fakeDbProviderFactory = A.Fake <IDbProviderFactory>();
var createConnectionCall = A.CallTo(() => fakeDbProviderFactory.CreateConnection());
createConnectionCall.Returns(fakeConnection);
DbOperation dbOperation = new DbOperation(string.Empty, string.Empty, new TraceSource("ss"), fakeDbProviderFactory);
try
{
dbOperation.ExecuteNonQuery();
Assert.Fail("Expected exception was not thrown.");
}
catch (Exception e)
{
Assert.AreEqual(msg, e.Message);
}
try
{
dbOperation.ExecuteScalar();
Assert.Fail("Expected exception was not thrown.");
}
catch (Exception e)
{
Assert.AreEqual(msg, e.Message);
}
try
{
dbOperation.ExecuteReader(A.Fake <Action <IDataRecord, IDbOperation> >());
Assert.Fail("Expected exception was not thrown.");
}
catch (Exception e)
{
Assert.AreEqual(msg, e.Message);
}
try
{
dbOperation.ExecuteNonQueryAsync().Wait();
Assert.Fail("Expected exception was not thrown.");
}
catch (Exception e)
{
Assert.AreEqual(msg, e.Message);
}
}
