예제 #1
0
        public void test_actually_inserting()
        {
            _dataAccess.ExecuteCommand(@"
CREATE TABLE Things(
    ThingId INT IDENTITY(1,1),
    ThingName NVARCHAR(20)
)");

            var thing = new Thing {ThingName = "test"};
            thing.ThingId = (int)_dataAccess.Insert(thing);

            var retrievedThing = _dataAccess.Select<Thing>(where: new {thing.ThingId}).First();

            retrievedThing.ThingId.ShouldBe(thing.ThingId);
            retrievedThing.ThingName.ShouldBe(thing.ThingName);
        }