SQL Server用DAOモジュール(C# .NET 4.0)

KntLibraryDao

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

namespace KntLibrary.DAO
{
	public sealed class ExecuteCommand
	{
		public ExecuteCommand() { }

		public static DataTable SelectCommand(string sql)
		{
			using (var connection = new SqlServerConnection())
			{
				var command = new SqlCommand();

				command.Connection = connection._InnerConnection;
				command.CommandText = sql;

				var adapt = new SqlDataAdapter();
				var table = new DataTable();

				adapt.SelectCommand = command;

				connection.Open();
				adapt.Fill(table);

				return table;
			}
		}

		public static DataTable SelectCommand(string sql, List<SqlParameter> parameters)
		{
			using (var connection = new SqlServerConnection())
			{
				var command = new SqlCommand();

				command.Connection = connection._InnerConnection;
				command.CommandText = sql;
				command.Parameters.AddRange(parameters.ToArray());

				var adapt = new SqlDataAdapter();
				var table = new DataTable();

				adapt.SelectCommand = command;

				connection.Open();
				adapt.Fill(table);

				return table;
			}
		}

		public static int EntryCommand(string sql)
		{
			using (var connection = new SqlServerConnection())
			{
				var command = new SqlCommand();

				command.Connection = connection._InnerConnection;
				command.CommandText = sql;

				connection.Open();

				int count = command.ExecuteNonQuery();

				return count;
			}
		}

		public static int EntryCommand(List<string> sqlList)
		{
			int count = 0;

			foreach (string s in sqlList)
			{
				count += EntryCommand(s);
			}

			return count;
		}

		public static int EntryCommand(string sql, List<SqlParameter> parameters)
		{
			using (var connection = new SqlServerConnection())
			{
				var command = new SqlCommand();

				command.Connection = connection._InnerConnection;
				command.CommandText = sql;
				command.Parameters.AddRange(parameters.ToArray());

				connection.Open();

				int count = command.ExecuteNonQuery();

				return count;
			}
		}

		public static int CallProcedure(string procedureName, List<SqlParameter> parameters)
		{
			using (var connection = new SqlServerConnection())
			{
				var command = new SqlCommand();

				command.Connection = connection._InnerConnection;
				command.CommandType = CommandType.StoredProcedure;
				command.CommandText = procedureName;
				command.Parameters.AddRange(parameters.ToArray());

				connection.Open();

				int count = command.ExecuteNonQuery();

				return count;
			}
		}
		
		public static int ScalorCommand(string sql)
		{
			using (var connection = new SqlServerConnection())
			{
				var command = new SqlCommand();

				command.Connection = connection._InnerConnection;
				command.CommandText = sql;

				connection.Open();

				int count = (int)command.ExecuteScalar();

				return count;
			}
		}

		public static int ScalorCommand(string sql, List<SqlParameter> parameters)
		{
			using (var connection = new SqlServerConnection())
			{
				var command = new SqlCommand();

				command.Connection = connection._InnerConnection;
				command.CommandText = sql;
				command.Parameters.AddRange(parameters.ToArray());

				connection.Open();

				int count = (int)command.ExecuteScalar();

				return count;
			}
		}
	}
}