public void InsertWorksWithGetTurnedOff()
{
// --- Arrange
var db = new SqlDatabase(DB_CONN);
db.Execute(@"create table sample(Id int identity(1, 1) not null, Name varchar(50) null)");
// --- Act
var record1 = new SampleRecordWithIdentity {
Name = "First"
};
db.Insert(record1);
var record2 = new SampleRecordWithIdentity {
Name = "Second"
};
db.Insert(record2, withGet: false);
// --- Assert
record1.Id.ShouldEqual(1);
record2.Id.ShouldEqual(0);
}
public async Task InsertAsyncWorksWithGetTurnedOff()
{
// --- Arrange
var db = new SqlDatabase(DB_CONN);
await db.ExecuteAsync(@"create table sample(Id int identity(1, 1) not null, Name varchar(50) null)");
// --- Act
var record1 = new SampleRecordWithIdentity {
Name = "First"
};
await db.InsertAsync(record1);
var record2 = new SampleRecordWithIdentity {
Name = "Second"
};
await db.InsertAsync(record2, withGet : false);
var count = await db.ExecuteScalarAsync <int>("select count(*) from sample");
// --- Assert
record1.Id.ShouldEqual(1);
record2.Id.ShouldEqual(0);
count.ShouldEqual(2);
}
