SQL Server ADO.NET SQLHelper类的使用

using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;

namespace ConsoleApp
{
    class Program
    {
        static void Main(string[] Args)
        {

            #region 添加对象
            1.准备好SQL语句
            //string sql = "insert into StudentClass (ClassName) values(N'C#基础班')";
            2.调用我们的SQLHelper类
            //int result =SQLHelper.GetSingleResult(sql);

            返回结果
            //if(result>=1)
            //{
            //    Console.WriteLine("添加成功！");

            //}
            //else
            //{
            //    Console.WriteLine("添加失败！");
            //}
            #endregion

            #region 修改对象
            1.准备好SQL语句
            //string sql = "update StudentClass set ClassName=N'C#进阶班' where ClassId=10001";
            2.调动我们的SQLHelper类
            //int result = SQLHelper.GetSingleResult(sql);
            返回结果
            //if (result >= 1)
            //{
            //    Console.WriteLine("修改成功！");

            //}
            //else
            //{
            //    Console.WriteLine("修改失败！");
            //}
            #endregion

            #region 删除对象
            1.准备好SQL语句
            //string sql = "delete from StudentClass where ClassId=10001";
            2.调动我们的SQLHelper类
            //int result = SQLHelper.GetSingleResult(sql);
            返回结果
            //if (result >= 1)
            //{
            //    Console.WriteLine("删除成功！");

            //}
            //else
            //{
            //    Console.WriteLine("删除失败！");
            //}
            #endregion



            #region 读取单个对象
            //      //1.准备好SQL语句
            //      string sql = "select ClassId,ClassName from StudentClass where ClassId=10000";
            //      //2.调动我们的SQLHelper类
            //      object stuObject = SQLHelper.GetSingleObject(sql);
            //      //解析对象
            //int classid =(int)stuObject;

            //      //展示数据
            //      Console.WriteLine("班级名称：" +classid );
            #endregion


            #region 读取多个对象
            //1.准备好SQL语句
            string sql = "select ClassId,ClassName from StudentClass";
            //2.调动我们的SQLHelper类
            SqlDataReader reader = SQLHelper.GetDataReader(sql);
            //解析对象
            List<StudentClass> stulist = new List<StudentClass>();

         while(reader.Read())
            {

                stulist.Add(new StudentClass()
                {
                    ClassId = Convert.ToInt32(reader["ClassId"]),
                    ClassName = reader["ClassName"].ToString()
                });

 
             }


            //展示数据
          foreach(StudentClass item in stulist)
            {
                Console.WriteLine("班级ID:" + item.ClassId + "班级名称：" + item.ClassName);
            }
            #endregion
            Console.ReadKey();
        }
    }
}