運(yùn)行測(cè)試，又會(huì)出現(xiàn)紅條了，測(cè)試失敗。現(xiàn)在要考慮實(shí)現(xiàn)一個(gè)真正的在數(shù)據(jù)庫(kù)中的查找功能，怎么開(kāi)始做呢?當(dāng)然還是由測(cè)試開(kāi)始，有了上面的基礎(chǔ)，現(xiàn)在寫(xiě)的測(cè)試跨庫(kù)可以稍微大點(diǎn)：
[TestFixture]
public class CustomerDAOTests
{
[Test]
public void ShouldFoundCustomerByID()
{
string id = "ALFKI";
string comName = "Alfreds Futterkiste";
CustomerDAO customerDAO = new CustomerDAO();
Customer found = customerDAO.FindCustomerByID(id);
Assert.That(found， Is.Not.Null);
Assert.That(found.CustomerID， Is.EqualTo(id));
Assert.That(found.CompanyName， Is.EqualTo(comName));
id = "AROUT";
comName = "Around the Horn";
found = customerDAO.FindCustomerByID(id);
Assert.That(found， Is.Not.Null);
Assert.That(found.CustomerID， Is.EqualTo(id));
Assert.That(found.CompanyName， Is.EqualTo(comName));
}
}
這段代碼不能編譯，因?yàn)椴](méi)有CustomerDAO這個(gè)類(lèi)，所以得新增該類(lèi)以及FindCustomerByID方法，而且上面的測(cè)試中已經(jīng)包括了兩個(gè)測(cè)試場(chǎng)景，現(xiàn)在可以直接寫(xiě)實(shí)現(xiàn)：
public class CustomerDAO
{
public Customer FindCustomerByID(string id)
{
using (NorthwindDataContext ctx = new NorthwindDataContext())
{
IQueryable customers = ctx.Customers.Where(c => c.CustomerID == id);
if (customers.Count() > 0)
return customers.Single();
else
return null;
}
}
}
運(yùn)行一下該測(cè)試，通過(guò)!然后再將aspx.cs里面的代碼進(jìn)行改動(dòng)使Web頁(yè)面的測(cè)試通過(guò)
void btn_find_customer_Click(object sender， EventArgs e)
{
string id = tb_customerID.Text;
Customer c = customerDAO.FindCustomerByID(id);
if (c == null)
return;
lbl_customerID.Text = c.CustomerID;
lbl_companyName.Text = c.CompanyName;
pnl_customerInfo.Visible = true;
}
