public void TestTypeMapAttributeUnquotedNameViaEntityViaCreateParameters()
{
// Act
using (var connection = new CustomDbConnection())
{
var command = connection.CreateCommand();
DbCommandExtension
.CreateParameters(command, new TestTypeMapAttributeUnquotedNameClass
{
ColumnString = "ColumnStringValue"
});
// Assert
Assert.AreEqual(1, command.Parameters.Count);
// Assert
var parameter = command.Parameters["@ColumnString"];
Assert.AreEqual(DbType.StringFixedLength, parameter.DbType);
}
}
public void TestColumnAttributeUnquotedNameViaEntityViaCreateParameters()
{
// Act
using (var connection = new CustomDbConnection())
{
var command = connection.CreateCommand();
DbCommandExtension
.CreateParameters(command, new TestColumnAttributeUnquotedNameClass
{
Id = 1
});
// Assert
Assert.AreEqual(1, command.Parameters.Count);
// Assert
var parameter = command.Parameters["@PrimaryId"];
Assert.IsNotNull(parameter);
}
}
public void TestMySqlTypeMapAttributeViaEntityViaCreateParameters()
{
// Act
using (var connection = new MySqlConnection())
{
using (var command = connection.CreateCommand())
{
DbCommandExtension
.CreateParameters(command, new MySqlDbTypeAttributeTestClass
{
ColumnName = "Test"
});
// Assert
Assert.AreEqual(1, command.Parameters.Count);
// Assert
var parameter = command.Parameters["@ColumnName"];
Assert.AreEqual(MySqlDbType.Geometry, parameter.MySqlDbType);
}
}
}
public void TestPropertyValueAttributeViaDerivedClassViaEntityViaCreateParameters()
{
// Act
using (var connection = new CustomDbConnection())
{
using (var command = connection.CreateCommand())
{
DbCommandExtension
.CreateParameters(command, new PropertyValueAttributeViaDerivedTestClass
{
ColumnName = "Test"
});
// Assert
Assert.AreEqual(1, command.Parameters.Count);
// Assert
var parameter = command.Parameters["@ColumnName"];
Assert.AreEqual("ValueOfTag", ((CustomDbParameter)parameter).Tag);
}
}
}
public void TestXmlSchemaCollectionNameAttributeViaEntityViaCreateParameters()
{
// Act
using (var connection = new SqlConnection())
{
using (var command = connection.CreateCommand())
{
DbCommandExtension
.CreateParameters(command, new XmlSchemaCollectionNameAttributeTestClass
{
ColumnName = "Test"
});
// Assert
Assert.AreEqual(1, command.Parameters.Count);
// Assert
var parameter = command.Parameters["@ColumnName"];
Assert.AreEqual("XmlSchemaCollectionName", parameter.XmlSchemaCollectionName);
}
}
}
public void TestCompareInfoAttributeViaEntityViaCreateParameters()
{
// Act
using (var connection = new SqlConnection())
{
using (var command = connection.CreateCommand())
{
DbCommandExtension
.CreateParameters(command, new CompareInfoAttributeTestClass
{
ColumnName = "Test"
});
// Assert
Assert.AreEqual(1, command.Parameters.Count);
// Assert
var parameter = command.Parameters["@ColumnName"];
Assert.AreEqual(SqlCompareOptions.IgnoreCase, parameter.CompareInfo);
}
}
}
public void TestIsNullableAttributeViaEntityViaCreateParameters()
{
// Act
using (var connection = new CustomDbConnection())
{
using (var command = connection.CreateCommand())
{
DbCommandExtension
.CreateParameters(command, new IsNullableAttributeTestClass
{
ColumnName = "Test"
});
// Assert
Assert.AreEqual(1, command.Parameters.Count);
// Assert
var parameter = command.Parameters["@ColumnName"];
Assert.AreEqual(true, ((CustomDbParameter)parameter).IsNullable);
}
}
}
public void TestForceColumnEncryptionAttributeViaEntityViaCreateParameters()
{
// Act
using (var connection = new SqlConnection())
{
using (var command = connection.CreateCommand())
{
DbCommandExtension
.CreateParameters(command, new ForceColumnEncryptionAttributeTestClass
{
ColumnName = "Test"
});
// Assert
Assert.AreEqual(1, command.Parameters.Count);
// Assert
var parameter = command.Parameters["@ColumnName"];
Assert.IsTrue(parameter.ForceColumnEncryption);
}
}
}
public void TestConvertedValueAttributeViaEntityViaCreateParameters()
{
// Act
using (var connection = new NpgsqlConnection())
{
using (var command = connection.CreateCommand())
{
DbCommandExtension
.CreateParameters(command, new ConvertedValueAttributeTestClass
{
ColumnName = "Test"
});
// Assert
Assert.AreEqual(1, command.Parameters.Count);
// Assert
var parameter = command.Parameters["@ColumnName"];
Assert.AreEqual("NameColumn", parameter.ConvertedValue);
}
}
}
public void TestDbTypeAttributeViaEntityViaCreateParameters()
{
// Act
using (var connection = new CustomDbConnection())
{
using (var command = connection.CreateCommand())
{
DbCommandExtension
.CreateParameters(command, new DbTypeAttributeTestClass
{
ColumnName = "Test"
});
// Assert
Assert.AreEqual(1, command.Parameters.Count);
// Assert
var parameter = command.Parameters["@ColumnName"];
Assert.AreEqual(DbType.AnsiStringFixedLength, ((CustomDbParameter)parameter).DbType);
}
}
}
public void TestSqlDbTypeAttributeViaAnonymousViaCreateParameters()
{
// Act
using (var connection = new SqlConnection())
{
using (var command = connection.CreateCommand())
{
DbCommandExtension
.CreateParameters(command, new
{
ColumnName = "Test"
},
typeof(SqlDbTypeAttributeTestClass));
// Assert
Assert.AreEqual(1, command.Parameters.Count);
// Assert
var parameter = command.Parameters["@ColumnName"];
Assert.AreEqual(SqlDbType.DateTime2, parameter.SqlDbType);
}
}
}
public void TestXmlSchemaCollectionOwningSchemaAttributeViaAnonymousViaCreateParameters()
{
// Act
using (var connection = new SqlConnection())
{
using (var command = connection.CreateCommand())
{
DbCommandExtension
.CreateParameters(command, new
{
ColumnName = "Test"
},
typeof(XmlSchemaCollectionOwningSchemaAttributeTestClass));
// Assert
Assert.AreEqual(1, command.Parameters.Count);
// Assert
var parameter = command.Parameters["@ColumnName"];
Assert.AreEqual("XmlSchemaCollectionOwningSchema", parameter.XmlSchemaCollectionOwningSchema);
}
}
}
public void TestDirectionAttributeViaAnonymousViaCreateParameters()
{
// Act
using (var connection = new CustomDbConnection())
{
using (var command = connection.CreateCommand())
{
DbCommandExtension
.CreateParameters(command, new
{
ColumnName = "Test"
},
typeof(DirectionAttributeTestClass));
// Assert
Assert.AreEqual(1, command.Parameters.Count);
// Assert
var parameter = command.Parameters["@ColumnName"];
Assert.AreEqual(ParameterDirection.Output, ((CustomDbParameter)parameter).Direction);
}
}
}