databaseabstract.cs

来自「数据访问框架.用于选择不同数据源的操作.包含了所有的ADO.NET的操作.不知道」· CS 代码 · 共 52 行

using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.Common;
using System.Configuration;
using System.Collections;
namespace ConsoleAbstract
{
    public abstract class DataBaseAbstract
    {
        protected string connString
        {
            get
            {
                return ConfigurationManager.ConnectionStrings["xiaoshouConnectionString2"].ToString();
            }
        }

        public abstract void Close();
        public object ExecuteScalar(CommandType comandType, string commandText)
        {
            return ExecuteScalar(comandType, commandText, null);
        }
        public abstract object ExecuteScalar(CommandType comandType, string commandText, DbParameter[] par);
        public DataSet GetDataAdapter(CommandType commType, string commandText)
        {
            return GetDataAdapter(commType, commandText, null);
        }
        public abstract DataSet GetDataAdapter(CommandType commType, string commandText, DbParameter[] par);
        public int ExecuteNonQuery(CommandType commType, string commandText)
        {
            return ExecuteNonQuery(commType, commandText, null);
        }
        public abstract int ExecuteNonQuery(CommandType commType, string commandText, DbParameter[] par);
        public DbDataReader ExecuteReader(CommandType commType, string commandText)
        {
            return ExecuteReader(commType, commandText, null);
        }
        public abstract DbDataReader ExecuteReader(CommandType commType, string commandText, DbParameter[] par);

        public DbParameter[] CreateParameter(int size)
        {
            ArrayList a = new ArrayList();
            for (int i = 0; i < size;i++)
                 a.Add(CreateParameter());
             return a.ToArray(typeof(DbParameter)) as DbParameter[];
        }
        protected abstract DbParameter CreateParameter();
    }
}