我是 Nunit 框架、C# 和 dotnet 的新手。如何使用 Nunit 為資料庫連接撰寫測驗用例。我找不到任何涵蓋資料庫連接的 nunit 示例。測驗用例必須涵蓋檢查連接并關閉它。
namespace TestConnection
{
class Program
{
static void Main(string[] args)
{
Connection con = new Connection();
con.ConnectionString = "Server = ab1-vm.app.test.com ;Port = 6080;Database = MY_DB;Schema = SCHM;User id = admin;PWD = *****;level=3;logname=C:\\my_logs";
Command cmd = con.CreateCommand();
Encoding e1 = Encoding.Default;
con.Open();
cmd.Connection = con;
try
{
string query = "SELECT \"X\", \"Y\", 1 FROM MY_DB..DIM_CONTRACT Z LIMIT 50 ";
cmd.CommandText = query;
DataReader rdr = cmd.ExecuteReader();
while (rdr.HasRows)
{
rdr.Read();
System.Console.WriteLine(rdr.GetString(0));
System.Console.WriteLine(rdr.GetString(1));
System.Console.WriteLine(rdr.GetInt32(2));
}
rdr.Close();
con.Close();
}
catch (Exception e)
{
System.Console.WriteLine(e.Message);
}
}
}
}
uj5u.com熱心網友回復：
NUnit.Framework.Assert.That(con.State == ConnectionState)為con.Open()和呼叫斷言函式con.close()
namespace TestProject
{
[TestClass] //Test Framework
public class UnitTest1
{
Connection con = new Connection();
[TestMethod] //Test Case 1
public void TestOpenConnection()
{
con.ConnectionString = "Server = ab1-vm.app.test.com ;Port = 6080;Database = MY_DB;Schema = SCHM;User id = admin;PWD = *****;level=3;logname=C:\\my_logs";
con.Open();
NUnit.Framework.Assert.That(con.State == ConnectionState.Open);
}
[TestMethod] //Test Case 2
public void TestCloseConnection()
{
con.ConnectionString = "Server = ab1-vm.app.test.com ;Port = 6080;Database = MY_DB;Schema = SCHM;User id = admin;PWD = *****;level=3;logname=C:\\my_logs";
con.Open(); //open the connection
con.Close(); //close to test if the connection closes
NUnit.Framework.Assert.That(con.State == ConnectionState.Closed);
}
}
}
轉載請註明出處，本文鏈接：https://www.uj5u.com/qianduan/483080.html
上一篇：排序陣列串列的JUnit測驗