public void Can_GetData() { var target = new MySqlReader(); var dataTable = target.GetData(connectionString, $"Select * from ex8_db1.ATeam"); int expectedOutput = target.ExecuteScalar <int>(connectionString, $"Select count(*) from ex8_db1.ATeam"); int actualOutput = dataTable.Tables[0].Rows.Count; dataTable.Tables.Should().NotBeEmpty(); dataTable.Tables[0].Rows.Should().NotBeEmpty(); expectedOutput.Should().Be(actualOutput); }