public void ThrowExceptionIfTheIdentityFieldIsNotTheClassMappingIdField()
{
// Setup
var statementBuilder = new SqlDbStatementBuilder();
var queryBuilder = new QueryBuilder <ThrowExceptionIfTheIdentityFieldIsNotTheClassMappingIdFieldClass>();
// Act/Assert
Assert.Throws <InvalidOperationException>(() => statementBuilder.CreateInsert(queryBuilder));
}
public void ThrowExceptionIfTheIdentityFieldIsNotTheIdField()
{
// Setup
var statementBuilder = new SqlDbStatementBuilder();
var queryBuilder = new QueryBuilder <ThrowExceptionIfTheIdentityFieldIsNotTheIdFieldClass>();
// Act/Assert
statementBuilder.CreateInsert(queryBuilder);
}
public void TestWithFieldMappings()
{
// Setup
var statementBuilder = new SqlDbStatementBuilder();
var queryBuilder = new QueryBuilder <TestWithFieldMappingsClass>();
// Act
var actual = statementBuilder.CreateInsert(queryBuilder);
var expected = $"" +
$"INSERT INTO [TestWithFieldMappingsClass] " +
$"( [Field1], [Field2], [Field4] ) " +
$"VALUES " +
$"( @Field1, @Field2, @Field4 ) ; " +
$"SELECT NULL AS [Result] ;";
// Assert
Assert.AreEqual(expected, actual);
}
public void TestWithClassMappingId()
{
// Setup
var statementBuilder = new SqlDbStatementBuilder();
var queryBuilder = new QueryBuilder <TestWithClassMappingIdClass>();
// Act
var actual = statementBuilder.CreateInsert(queryBuilder);
var expected = $"" +
$"INSERT INTO [ClassName] " +
$"( [ClassNameId], [Field2], [Field3] ) " +
$"VALUES " +
$"( @ClassNameId, @Field2, @Field3 ) ; " +
$"SELECT @ClassNameId AS [Result] ;";
// Assert
Assert.AreEqual(expected, actual);
}
