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);
}
