studentdalfixture.cs

连接数据库的基本操作,可以作为入门的学习参考

using System;
using System.Data;
using System.Data.SqlClient;
using NUnit.Framework;
using Model.Dxs;

namespace SQLServerDAL.Dxs.Nunit
{
	/// <summary>
	/// StudentDALFixture 的摘要说明。
	/// </summary>
	[TestFixture]
	public class StudentDALFixture
	{
		private Student student;
		private StudentDAL studentDAL;
		[SetUp]
		public void Initial()	
		{
			SQLHelper.CONN_STRING="Server=(local);Database=student;User ID=sa;Password=lpxuan;Connection Timeout=30;";
			student=new Student();
			studentDAL=new StudentDAL();
			student.Name="测试更新";
			student.Age="22";
			student.Height="1.77";
		}

		[Test]
		public void GetAll()
		{
			bool flag=false;
			DataTable dt=studentDAL.GetAll();
			if(dt.Rows.Count==2)
				flag=true;
			Assert.AreEqual(flag,true);
		}

		[Test]
		public void GetStudentInfoById()
		{
			bool flag=false;
			int id=1;
			Student student=studentDAL.GetStudentInfoById(id);
			if(student.Name=="张三")
				flag=true;
			Assert.AreEqual(flag,true);
		}

		[Test]
		public void Insert()
		{
			bool flag=studentDAL.InsertStudentInfo(student);
			Assert.AreEqual(flag,true);
		}

		[Test]
		public void Update()
		{
			student.ID=3;
			bool flag=studentDAL.UpdateStudentInfo(student);
			Assert.AreEqual(flag,true);
		}

		[Test]
		public void Delete()
		{
			student.ID=3;
			bool flag=studentDAL.DeleteStudentInfo(student);
			Assert.AreEqual(flag,true);
		}
	}
}