public ConnectionState OpenSqlConnection(ISqlConnectionWrap connection)
{
connection.Open();
ConnectionState connectionState = connection.State;
connection.Close();
return connectionState;
}
public ConnectionState OpenSqlConnection(ISqlConnectionWrap connection)
{
connection.Open();
ConnectionState connectionState = connection.State;
connection.Close();
return(connectionState);
}
public void OpenSqlConnection_test()
{
ISqlConnectionWrap connectionStub = MockRepository.GenerateStub <ISqlConnectionWrap>();
connectionStub.Stub(x => x.State).Return(ConnectionState.Open);
Assert.AreEqual(ConnectionState.Open, new SqlConnectionSample().OpenSqlConnection(connectionStub));
connectionStub.AssertWasCalled(x => x.Open());
connectionStub.AssertWasCalled(x => x.Close());
}
/// <summary>
/// Initializes a new instance of the SqlCommandWrap class with the text of the query and a ISqlConnectionWrap.
/// </summary>
/// <param name="cmdText">The text of the query.</param>
/// <param name="connection">A ISqlConnectionWrap that represents the connection to an instance of SQL Server.</param>
public void Initialize(string cmdText, ISqlConnectionWrap connection)
{
SqlCommandInstance = new SqlCommand(cmdText, connection.SqlConnectionInstance);
}
/// <summary>
/// Initializes a new instance of the SqlCommandWrap class with the text of the query and a ISqlConnectionWrap.
/// </summary>
/// <param name="cmdText">The text of the query.</param>
/// <param name="connection">A ISqlConnectionWrap that represents the connection to an instance of SQL Server.</param>
public SqlCommandWrap(string cmdText, ISqlConnectionWrap connection)
{
Initialize(cmdText, connection);
}
/// <summary>
/// Initializes a new instance of the SqlCommandWrap class with the text of the query and a ISqlConnectionWrap.
/// </summary>
/// <param name="cmdText">The text of the query.</param>
/// <param name="connection">A ISqlConnectionWrap that represents the connection to an instance of SQL Server.</param>
public void Initialize(string cmdText, ISqlConnectionWrap connection)
{
SqlCommandInstance = new SqlCommand(cmdText, connection.SqlConnectionInstance);
}
/// <summary>
/// Initializes a new instance of the SqlCommandWrap class with the text of the query and a ISqlConnectionWrap.
/// </summary>
/// <param name="cmdText">The text of the query.</param>
/// <param name="connection">A ISqlConnectionWrap that represents the connection to an instance of SQL Server.</param>
public SqlCommandWrap(string cmdText, ISqlConnectionWrap connection)
{
Initialize(cmdText, connection);
}
