public void TestSqlConnectionDataAnnotationMappingInsertAndUpdateAndQueryForNonIdentityViaQueryFields() { // Setup var entity = GetMappedCompleteTable(); using (var connection = new SqlConnection(Database.ConnectionStringForRepoDb)) { // Act Insert var id = connection.Insert(entity); // Setup var fields = new QueryField("SessionId", id).AsEnumerable(); entity.ColumnNVarCharMapped = $"{entity.ColumnNVarCharMapped} (Updated)"; // Act Update var affectedRows = connection.Update <MappedCompleteTable>(entity, fields); // Assert Assert.AreEqual(1, affectedRows); // Act Query fields.ResetAll(); var data = connection.Query <MappedCompleteTable>(fields).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 TestSqlConnectionObjectMappingInsertAndInlineUpdateViaQueryFields() { // 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 fields = new QueryField("SessionId", id).AsEnumerable(); // Act Update var affectedRows = connection.InlineUpdate <MappedObject>(new { ColumnNVarChar = $"{entity.ColumnNVarCharMapped} (Updated)" }, fields); // Assert Assert.AreEqual(1, affectedRows); // Act Query fields.ResetAll(); var data = connection.Query <MappedObject>(fields).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); } }