public async Task DeleteAllTest() { IEnumerable <TestTableEntity> rows = null; IEnumerable <TestTableEntity> rowsAfterDelete = null; using (var connection = new SqlConnection(Settings.ConnectionString)) { await TableUtils.ClearTestDB(connection); IEnumerable <object> list = new List <object>() { new { TestString = "HI", TestInt = 5 }, new { TestString = "HI2", TestInt = 6 }, new { TestString = "HI3", TestInt = 7 } }; await connection.InsertMulti("TestTable", list); rows = await connection.QueryAsync <TestTableEntity>("Select * from TestTable ORDER BY TestTableID;"); await connection.DeleteAll("TestTable"); rowsAfterDelete = await connection.QueryAsync <TestTableEntity>("Select * from TestTable ORDER BY TestTableID;"); } Assert.AreEqual(3, rows.Count()); Assert.AreEqual(0, rowsAfterDelete.Count()); }
public async Task DeleteByIDTest() { IEnumerable <TestTableEntity> rows = null; IEnumerable <TestTableEntity> rowsAfterDelete = null; using (var connection = new SqlConnection(Settings.ConnectionString)) { await TableUtils.ClearTestDB(connection); IEnumerable <object> list = new List <object>() { new { TestString = "HI", TestInt = 5 }, new { TestString = "HI2", TestInt = 6 }, new { TestString = "HI3", TestInt = 7 } }; await connection.InsertMulti("TestTable", list); rows = await connection.QueryAsync <TestTableEntity>("Select * from TestTable ORDER BY TestTableID;"); await connection.Delete("TestTable", new { TestTableID = rows.First().TestTableID }); rowsAfterDelete = await connection.QueryAsync <TestTableEntity>("Select * from TestTable ORDER BY TestTableID;"); } Assert.AreEqual(3, rows.Count()); Assert.AreEqual(2, rowsAfterDelete.Count()); // Compare IDs to ensure proper entity was deleted. Assert.AreEqual(rows.Skip(1).First().TestTableID, rowsAfterDelete.First().TestTableID); Assert.AreEqual(rows.Skip(2).First().TestTableID, rowsAfterDelete.Skip(1).First().TestTableID); }
public async Task InsertSingleTest() { IEnumerable <TestTableEntity> rows = null; using (var connection = new SqlConnection(Settings.ConnectionString)) { await TableUtils.ClearTestDB(connection); int id = await connection.Insert("TestTable", new { TestString = "HI", TestInt = 5 }); rows = await connection.QueryAsync <TestTableEntity>("Select * from TestTable WHERE TestTableID = @ID", new { ID = id }); } Assert.AreEqual(1, rows.Count()); Assert.AreEqual("HI", rows.First().TestString); Assert.AreEqual(5, rows.First().TestInt); }
public async Task UpdateSinglePropertyTest() { TestTableEntity firstRow = null; TestTableEntity afterUpdate = null; using (var connection = new SqlConnection(Settings.ConnectionString)) { await TableUtils.ClearTestDB(connection); int id = await connection.Insert("TestTable", new { TestString = "HI", TestInt = 5 }); firstRow = await connection.QuerySingleAsync <TestTableEntity>("Select * from TestTable WHERE TestTableID = @ID", new { ID = id }); await connection.Update("TestTable", new { TestTableID = id }, new { TestString = "UPDATED" }); afterUpdate = await connection.QuerySingleAsync <TestTableEntity>("Select * from TestTable WHERE TestTableID = @ID", new { ID = id }); } Assert.AreEqual("HI", firstRow.TestString); Assert.AreEqual("UPDATED", afterUpdate.TestString); }