public void SimpleUpdateWorksWithMultiplePk()
{
// --- Arrange
var db = new FbDatabase(DB_CONN);
db.BeginTransaction();
db.Execute(@"create table ""sample"" (""Id1"" int not null, ""Id2"" int not null, ""Name"" varchar(50), ""Description"" varchar(50))");
db.CompleteTransaction();
var record = new SampleRecordWithMultiplePk {
Id1 = 1, Id2 = 2, Name = "First"
};
db.Insert(record);
// --- Act
record.Name = "NewFirst";
db.Update(record);
// --- Assert
var back = db.FirstOrDefault <SampleRecordWithMultiplePk>(
@"where ""Id1"" = @0 and ""Id2"" = @1", record.Id1, record.Id2);
back.ShouldNotBeNull();
back.Id1.ShouldEqual(record.Id1);
back.Id2.ShouldEqual(record.Id2);
back.Name.ShouldEqual("NewFirst");
}
public async Task DeleteAsyncWorksWithMultiplePk()
{
// --- Arrange
var db = new FbDatabase(DB_CONN);
await db.BeginTransactionAsync();
await db.ExecuteAsync(@"create table ""sample"" (""Id1"" int not null, ""Id2"" int not null, ""Name"" varchar(50), ""Description"" varchar(50))");
await db.CompleteTransactionAsync();
var record = new SampleRecordWithMultiplePk {
Id1 = 1, Id2 = 2, Name = "First"
};
await db.InsertAsync(record);
// --- Act
var back1 = await db.FirstOrDefaultAsync <SampleRecordWithMultiplePk>(
@"where ""Id1"" = @0 and ""Id2"" = @1", record.Id1, record.Id2);
await db.DeleteAsync(record);
var back2 = await db.FirstOrDefaultAsync <SampleRecordWithMultiplePk>(
@"where ""Id1"" = @0 and ""Id2"" = @1", record.Id1, record.Id2);
// --- Assert
back1.ShouldNotBeNull();
back2.ShouldBeNull();
}
public async Task SimpleUpdateAsyncWorksWithMultipleModifications()
{
// --- Arrange
var db = new SqlDatabase(DB_CONN);
await db.ExecuteAsync(@"create table sample(Id1 int not null, Id2 int not null, Name varchar(50) null, Description varchar(50) null)");
var record = new SampleRecordWithMultiplePk {
Id1 = 1, Id2 = 2, Name = "First"
};
await db.InsertAsync(record);
// --- Act
record.Name = "NewFirst";
record.Description = "Description";
await db.UpdateAsync(record);
// --- Assert
var back = await db.FirstOrDefaultAsync <SampleRecordWithMultiplePk>("where Id1 = @0 and Id2 = @1", record.Id1, record.Id2);
back.ShouldNotBeNull();
back.Id1.ShouldEqual(record.Id1);
back.Id2.ShouldEqual(record.Id2);
back.Name.ShouldEqual("NewFirst");
back.Description.ShouldEqual("Description");
}
public async Task DeleteAsyncWorksWithMultiplePk()
{
// --- Arrange
var db = new SqlDatabase(DB_CONN);
await db.ExecuteAsync(@"create table sample(Id1 int not null, Id2 int not null, Name varchar(50) null, Description varchar(50) null)");
var record = new SampleRecordWithMultiplePk {
Id1 = 1, Id2 = 2, Name = "First"
};
await db.InsertAsync(record);
// --- Act
var back1 = await db.FirstOrDefaultAsync <SampleRecordWithMultiplePk>("where Id1 = @0 and Id2 = @1", record.Id1, record.Id2);
await db.DeleteAsync(record);
var back2 = await db.FirstOrDefaultAsync <SampleRecordWithMultiplePk>("where Id1 = @0 and Id2 = @1", record.Id1, record.Id2);
// --- Assert
back1.ShouldNotBeNull();
back2.ShouldBeNull();
}
public void SimpleUpdateWorksWithMultiplePk()
{
// --- Arrange
var db = new SqlDatabase(DB_CONN);
db.Execute(@"create table sample(Id1 int not null, Id2 int not null, Name varchar(50) null, Description varchar(50) null)");
var record = new SampleRecordWithMultiplePk {
Id1 = 1, Id2 = 2, Name = "First"
};
db.Insert(record);
// --- Act
record.Name = "NewFirst";
db.Update(record);
// --- Assert
var back = db.FirstOrDefault <SampleRecordWithMultiplePk>("where Id1 = @0 and Id2 = @1", record.Id1, record.Id2);
back.ShouldNotBeNull();
back.Id1.ShouldEqual(record.Id1);
back.Id2.ShouldEqual(record.Id2);
back.Name.ShouldEqual("NewFirst");
}
