public void ReadAll_ShouldReturnOneDataRow() { // Insert the Session data row in the database. int sessionID = SessionTestTable.InsertWithValues( "6dk61ufcuzp3f7vs", "Session Alpha", new DateTime(2001, 1, 1)); // Build the database connection. SessionDataRow[] sessionDataRows = null; using (DatabaseConnection databaseConnection = new DatabaseConnection(TestDatabase.ConnectionString)) { // Open the database connection. databaseConnection.Open().Wait(); // Read the Session data rows. SessionDataAccessComponent sessionDataAccessComponent = new SessionDataAccessComponent(); sessionDataRows = sessionDataAccessComponent.ReadAll(databaseConnection).Result; } // Validate the Session data rows. Assert.IsNotNull(sessionDataRows); Assert.AreEqual(1, sessionDataRows.Length); // Validate the first Session data row. Assert.AreEqual(sessionID, sessionDataRows[0].SessionID); Assert.AreEqual("6dk61ufcuzp3f7vs", sessionDataRows[0].SessionCode); Assert.AreEqual("Session Alpha", sessionDataRows[0].Name); Assert.AreEqual(new DateTime(2001, 1, 1), sessionDataRows[0].StartDate); }
public void ReadAll_ShouldReturnZeroDataRows() { // Build the database connection. SessionDataRow[] sessionDataRows = null; using (DatabaseConnection databaseConnection = new DatabaseConnection(TestDatabase.ConnectionString)) { // Open the database connection. databaseConnection.Open().Wait(); // Read the Session data rows. SessionDataAccessComponent sessionDataAccessComponent = new SessionDataAccessComponent(); sessionDataRows = sessionDataAccessComponent.ReadAll(databaseConnection).Result; } // Validate the Session data rows. Assert.IsNotNull(sessionDataRows); Assert.AreEqual(0, sessionDataRows.Length); }
public void ReadAll_ShouldReturnMultipleDataRows() { // Insert the first Session data row in the database. int firstSessionID = SessionTestTable.InsertWithValues( "6dk61ufcuzp3f7vs", "Session Alpha", new DateTime(2001, 1, 1)); // Insert the second Session data row in the database. int secondSessionID = SessionTestTable.InsertWithValues( "n3p4y556gt9f17hw", "Session Bravo", new DateTime(2002, 2, 2)); // Insert the third Session data row in the database. int thirdSessionID = SessionTestTable.InsertWithValues( "x36s2tccz8yxp1hq", "Session Charlie", new DateTime(2003, 3, 3)); // Build the database connection. SessionDataRow[] sessionDataRows = null; using (DatabaseConnection databaseConnection = new DatabaseConnection(TestDatabase.ConnectionString)) { // Open the database connection. databaseConnection.Open().Wait(); // Read the Session data rows. SessionDataAccessComponent sessionDataAccessComponent = new SessionDataAccessComponent(); sessionDataRows = sessionDataAccessComponent.ReadAll(databaseConnection).Result; } // Validate the Session data rows. Assert.IsNotNull(sessionDataRows); Assert.AreEqual(3, sessionDataRows.Length); // Validate the first Session data row. Assert.AreEqual(firstSessionID, sessionDataRows[0].SessionID); Assert.AreEqual("6dk61ufcuzp3f7vs", sessionDataRows[0].SessionCode); Assert.AreEqual("Session Alpha", sessionDataRows[0].Name); Assert.AreEqual(new DateTime(2001, 1, 1), sessionDataRows[0].StartDate); // Validate the second Session data row. Assert.AreEqual(secondSessionID, sessionDataRows[1].SessionID); Assert.AreEqual("n3p4y556gt9f17hw", sessionDataRows[1].SessionCode); Assert.AreEqual("Session Bravo", sessionDataRows[1].Name); Assert.AreEqual(new DateTime(2002, 2, 2), sessionDataRows[1].StartDate); // Validate the third Session data row. Assert.AreEqual(thirdSessionID, sessionDataRows[2].SessionID); Assert.AreEqual("x36s2tccz8yxp1hq", sessionDataRows[2].SessionCode); Assert.AreEqual("Session Charlie", sessionDataRows[2].Name); Assert.AreEqual(new DateTime(2003, 3, 3), sessionDataRows[2].StartDate); }