public void TheConnectionStringIsSetAndANewInsertHasTheSameColumns() { const string connection = "some connection"; var insertStatement = new Insert(SomeTable)[FirstColumn.WillBe(FirstValue)].ConnectTo(connection); var newStatement = insertStatement.ConnectTo(connection); newStatement.Columns.Should().BeEquivalentTo(insertStatement.Columns); }
public void TheConnectionStringIsAllowedToBeSet() { const string connection = "some connection"; var insertStatement = new Insert(SomeTable) [ FirstColumn.WillBe(_fakeValue) ] .ConnectTo(connection); RetrieveValueFromObject(insertStatement, ConnectionKeyword).ToString().Should().Be(connection); }
public void ANewInsertIsCreatedWhenSettingTheColumnsAndTheConnectionIsTheSame() { const string firstConnection = "connectionA"; const string secondConnection = "connectionB"; var insertStatement = new Insert(SomeTable)[FirstColumn.WillBe(_fakeValue)].ConnectTo(firstConnection); var newStatement = insertStatement.ConnectTo(secondConnection); var connectionA = RetrieveValueFromObject(insertStatement, ConnectionKeyword); var connectionB = RetrieveValueFromObject(newStatement, ConnectionKeyword); connectionA.Should().Be(connectionB); }
public void ANewInsertIsCreatedWhenSettingTheColumns() { var insertStatement = new Insert(SomeTable) [ FirstColumn.WillBe(_fakeValue), SecondColumn.WillBe(SecondValue) ]; var newStatement = insertStatement[FirstColumn.WillBe(_fakeValue)]; insertStatement.Should().NotBe(newStatement); }
public Insert this[params ColumnItem[] items] { get { var result = new Insert(TableName) { _connection = _connection, _columns = Columns }; foreach (var item in items) { _columns.Add(item); } return result; } }
public void TheInsertCanCreateAValidStatement() { var insertStatement = new Insert(SomeTable) [ FirstColumn.WillBe(_fakeValue), SecondColumn.WillBe(SecondValue) ]; insertStatement.CreateSql().Should().Be("INSERT INTO " + SomeTable + "(" + FirstColumn + ", " + SecondColumn + ") VALUES (@" + FirstColumn + ", @" + SecondColumn + ")"); }
public void TheConnectionStringIsSetAndANewInsertIsCreated() { const string connection = "some connection"; var insertStatement = new Insert(SomeTable).ConnectTo(connection); var newStatement = insertStatement.ConnectTo(connection); insertStatement.Should().NotBe(newStatement); }