如何应用TDD/BDD方法使用来自Oracle数据库的数据从C#创建Excel文件

[Test]
public void Test_GenerateExcelFromOracleData()
{
    // Arrange
    var oracleData = new List<OracleData>
    {
        new OracleData { Id = 1, Name = "John" },
        new OracleData { Id = 2, Name = "Jane" }
    };
    var expectedExcelData = new List<ExcelData>
    {
        new ExcelData { Id = 1, Name = "John" },
        new ExcelData { Id = 2, Name = "Jane" }
    };

    // Act
    var actualExcelData = GenerateExcelFromOracleData(oracleData);

    // Assert
    Assert.AreEqual(expectedExcelData.Count, actualExcelData.Count);
    for (int i = 0; i< expectedExcelData.Count; i++)
    {
        Assert.AreEqual(expectedExcelData[i].Id, actualExcelData[i].Id);
        Assert.AreEqual(expectedExcelData[i].Name, actualExcelData[i].Name);
    }
}

public List<ExcelData> GenerateExcelFromOracleData(List<OracleData> oracleData)
{
    // Connect to Oracle database and get data
    var oracleConnectionString = "Data Source=myOracleDB;User Id=myUsername;Password=myPassword;";
    var oracleCommandText = "SELECT * FROM myTable";
    var oracleDataTable = new DataTable();
    using (var oracleConnection = new OracleConnection(oracleConnectionString))
    {
        oracleConnection.Open();
        using (var oracleCommand = new OracleCommand(oracleCommandText, oracleConnection))
        {
            using (var oracleDataReader = oracleCommand.ExecuteReader())
            {
                oracleDataTable.Load(oracleDataReader);
            }
        }
    }

    // Convert Oracle data to Excel data
    var excelData = new List<ExcelData>();
    foreach (DataRow row in oracleDataTable.Rows)
    {
        var excelRow = new ExcelData
        {
            Id = Convert.ToInt32(row["Id"]),
            Name = row["Name"].ToString()
        };
        excelData.Add(excelRow);
    }

    // Write Excel data to file
    var excelFileName = "output.xlsx";
    using (var excelPackage = new ExcelPackage(new FileInfo(excelFileName)))
    {
        var worksheet = excelPackage.Workbook.Worksheets.Add("Sheet1");
        worksheet.Cells["A1"].LoadFromCollection(excelData, true);
        excelPackage.Save();
    }

    return excelData;
}