dataacess.cs

学生成绩管理系统

using System;
using System.Configuration;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
using System.Data.SqlTypes;
using Microsoft.Practices.EnterpriseLibrary.Data;
using Microsoft.Practices.EnterpriseLibrary.Data.Sql;
using System.Data.Common;

namespace TeachHelper.DataAccessLayer
{
    public class DataAccess 
    {
        /*** PROPERTIES ***/
        public static string ConnectionString 
        {
            get 
            {
                if (ConfigurationManager.ConnectionStrings["LocalSqlServer"] == null)
                    throw (new NullReferenceException("ConnectionString configuration is missing from you web.config. It should contain  <connectionStrings> <add key=\"aspnet_staterKits_TimeTracker\" value=\"Server=(local);Integrated Security=True;Database=Issue_Tracker\" </connectionStrings>"));

                string connectionString = ConfigurationManager.ConnectionStrings["LocalSqlServer"].ConnectionString;

                if (String.IsNullOrEmpty(connectionString))
                    throw (new NullReferenceException("ConnectionString configuration is missing from you web.config. It should contain  <connectionStrings> <add key=\"aspnet_staterKits_TimeTracker\" value=\"Server=(local);Integrated Security=True;Database=Issue_Tracker\" </connectionStrings>"));
                else
                    return (connectionString);
            }
        }

        public static DataSet ExecuteDataSet(string sqlCommand)
        {
            Database db = DatabaseFactory.CreateDatabase();
            DbCommand dbCommand = db.GetSqlStringCommand(sqlCommand);
            DataSet ds = db.ExecuteDataSet(dbCommand);
            return ds;
        }
    }
}