public void SpGetMember()
{
using (var cn = new System.Data.SqlClient.SqlConnection(Settings.ConnectionString))
{
cn.Open();
using (var cmd = cn.CreateCommand())
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "spGetMember";
using (var dr = cmd.ExecuteReader())
{
var message = "";
var ismatch = ResultChecker.IsMatch(dr, Path.Combine(Settings.BasePath, "spGetMemberTestData.xlsx"), "result", out message);
Assert.AreEqual(true, ismatch, message);
}
}
}
}