public void Commit_BindColumnToForInsert_InsertWorksCorrectly() { var factory = GetProviderFactory(); var provider = new StubSqlProvider(); provider.SetObjectToReturn(1); using (mocks.Record()) { factory.CreateProvider("somestring"); LastCall.Return(provider).IgnoreArguments(); } Guid personId = Guid.NewGuid(); Guid addressId = Guid.NewGuid(); DataBoy .ForTable("Person") .Row("Id", personId) .ReturnValue("IdPerson").AtKey("IdOfPerson") .ForTable("Address") .Row("Id", addressId) .BindColumn("IdPerson").To("IdOfPerson") .Commit(); string expectedSql = string.Format("INSERT INTO Address (ID, IdPerson) VALUES('{0}', 1)", addressId); Assert.IsTrue(provider.HasAnySqlMatching(expectedSql)); }
public void Commit_WithReturnValue_SelectExecutedAsExpected() { //INSERT INTO Address (ID, IdPerson) VALUES('7e7304db-2b77-4040-ae64-9eb6a686a036', 1) var factory = GetProviderFactory(); var provider = new StubSqlProvider(); provider.SetObjectToReturn(1); using (mocks.Record()) { factory.CreateProvider("somestring"); LastCall.Return(provider).IgnoreArguments(); } Guid personId = Guid.NewGuid(); DataBoy .ForTable("Person") .Row("Id", personId) .ReturnValue("IdPerson").AtKey("IdOfPerson") //.ForTable("Address") // .Row("Id", Guid.NewGuid()) // .BindColumn("IdPerson").To("IdOfPerson") .Commit(); //HasAnySqlMatching string expectedSql = string.Format("SELECT IdPerson FROM Person WHERE Id = '{0}'", personId); Assert.IsTrue(provider.HasAnySqlMatching(expectedSql)); }