AsyncPoco.Tests.Tests.UpdateByKeyCompositePK C# (CSharp) Method

		public async Task UpdateByKeyCompositePK() {
			await db.ExecuteAsync("DELETE FROM composite_pk");
			await db.InsertAsync(new composite_pk { id1 = 1, id2 = 1, value = "fizz" });
			await db.InsertAsync(new composite_pk { id1 = 1, id2 = 2, value = "fizz" });
			await db.InsertAsync(new composite_pk { id1 = 2, id2 = 1, value = "fizz" });
			await db.InsertAsync(new composite_pk { id1 = 2, id2 = 2, value = "fizz" });

			await db.UpdateAsync("composite_pk", "id1,id2", new { value = "buzz" }, new { id1 = 2, id2 = 1 });

			var rows = await db.FetchAsync<composite_pk>("SELECT * FROM composite_pk WHERE value = 'buzz'");
			Assert.AreEqual(1, rows.Count);
			Assert.AreEqual(2, rows[0].id1);
			Assert.AreEqual(1, rows[0].id2);
		}