public void DictionaryWithParametersValue_ReturnsCorrectlyComposedSqlParameters() { // Arrange var sqlServerProvider = new SqlServerProvider(); var parametersDictionary = new Dictionary<string, object> { {"TestParameterInt", 123}, {"TestParameterString", "TestStringValue"} }; // Act IEnumerable<IDataParameter> parameters = sqlServerProvider.CreateParameters(parametersDictionary); // Assert var sqlParameterInt = parameters.ElementAt(0) as SqlParameter; var sqlParameterString = parameters.ElementAt(1) as SqlParameter; Assert.IsNotNull(sqlParameterInt); Assert.AreEqual("@TestParameterInt", sqlParameterInt.ParameterName); Assert.AreEqual(123, sqlParameterInt.Value); Assert.IsNotNull(sqlParameterString); Assert.AreEqual("@TestParameterString", sqlParameterString.ParameterName); Assert.AreEqual("TestStringValue", sqlParameterString.Value); }
public void ConnectionString_ReturnsSqlConnection() { // Arrange var sqlServerProvider = new SqlServerProvider(TestConnectionString); // Act var sqlConnection = sqlServerProvider.CreateConnection(); // Assert Assert.IsInstanceOf<SqlConnection>(sqlConnection); Assert.AreEqual(TestConnectionString, sqlConnection.ConnectionString); }
public void QuerySqlConnectionAndCommandType_ReturnsCorrectlyComposedSqlCommand() { // Arrange var sqlServerProvider = new SqlServerProvider(TestConnectionString) {CommandTimeout = CommandTimeout}; var mockSqlConnection = new SqlConnection(TestConnectionString); // Act var command = sqlServerProvider.CreateCommand(SelectQuery, mockSqlConnection, CommandType.Text); // Assert Assert.IsInstanceOf<SqlCommand>(command); Assert.AreEqual(SelectQuery, command.CommandText); Assert.AreEqual(mockSqlConnection, command.Connection); Assert.AreEqual(CommandType.Text, command.CommandType); Assert.AreEqual(CommandTimeout, command.CommandTimeout); }