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