public void TestSqlConnectionDataAnnotationMappingInsertAndUpdateAndQueryForNonIdentityViaQueryField()
{
// Setup
var entity = GetMappedCompleteTable();
using (var connection = new SqlConnection(Database.ConnectionStringForRepoDb))
{
// Act Insert
var id = connection.Insert(entity);
// Setup
var field = new QueryField("SessionId", id);
entity.ColumnNVarCharMapped = $"{entity.ColumnNVarCharMapped} (Updated)";
// Act Update
var affectedRows = connection.Update <MappedCompleteTable>(entity, field);
// Assert
Assert.AreEqual(1, affectedRows);
// Act Query
field.Reset();
var data = connection.Query <MappedCompleteTable>(field).FirstOrDefault();
// Assert
Assert.IsNotNull(data);
Assert.AreEqual(entity.ColumnBigIntMapped, data.ColumnBigIntMapped);
Assert.AreEqual(entity.ColumnBitMapped, data.ColumnBitMapped);
Assert.AreEqual(entity.ColumnDateTime2Mapped, data.ColumnDateTime2Mapped);
Assert.AreEqual(entity.ColumnDateTimeMapped, data.ColumnDateTimeMapped);
Assert.AreEqual(entity.ColumnIntMapped, data.ColumnIntMapped);
Assert.AreEqual(entity.ColumnNVarCharMapped, data.ColumnNVarCharMapped);
}
}
public void TestSqlConnectionObjectMappingInsertAndInlineUpdateViaQueryField()
{
// Setup
var entity = new MappedObject
{
SessionIdMapped = Guid.NewGuid(),
ColumnBigIntMapped = long.MaxValue,
ColumnBitMapped = true,
ColumnDateTime2Mapped = DateTime.Parse("1970-01-01 1:25:00.44569"),
ColumnDateTimeMapped = DateTime.Parse("1970-01-01 10:30:30"),
ColumnIntMapped = int.MaxValue,
ColumnNVarCharMapped = Helper.GetAssemblyDescription()
};
using (var connection = new SqlConnection(Database.ConnectionStringForRepoDb))
{
// Act Insert
var id = connection.Insert(entity);
// Setup
var field = new QueryField("SessionId", id);
// Act Update
var affectedRows = connection.InlineUpdate <MappedObject>(new
{
ColumnNVarChar = $"{entity.ColumnNVarCharMapped} (Updated)"
}, field);
// Assert
Assert.AreEqual(1, affectedRows);
// Act Query
field.Reset();
var data = connection.Query <MappedObject>(field).FirstOrDefault();
// Assert
Assert.IsNotNull(data);
Assert.AreEqual(entity.ColumnBigIntMapped, data.ColumnBigIntMapped);
Assert.AreEqual(entity.ColumnBitMapped, data.ColumnBitMapped);
Assert.AreEqual(entity.ColumnDateTime2Mapped, data.ColumnDateTime2Mapped);
Assert.AreEqual(entity.ColumnDateTimeMapped, data.ColumnDateTimeMapped);
Assert.AreEqual(entity.ColumnIntMapped, data.ColumnIntMapped);
Assert.AreEqual($"{entity.ColumnNVarCharMapped} (Updated)", data.ColumnNVarCharMapped);
}
}
