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