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); } } }