如何使用C#代码建立数据库和表

Question

想在C#里写个通用类，用于建立数据库和表的，这样就可以不用每次在SQL里去操作了.请问有什么办法能够实现么？

Answer 1

数据库操作类看看DBHelper

Answer 2

查到了可以通过ExcuteNonQuerry来创建闷

Answer 3

using System;
using System.Data;
using System.Configuration;
using System.Web;using System.Data.SqlClient;namespace Utility
{
    /// <summary>
    /// SQLHelper 的摘要说明
    /// </summary>
    public class SQLHelper
    {
        private static SqlConnection connection;
        //public SQLHelper()
        //{
        //    //TODO: 在此处添加构造函数逻辑
        //}
        //数据连接
        //创建连接属性处理连接
        public static SqlConnection Connection
        {
            get
            {
                string ConString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;                if (connection == null)
                {
                    connection = new SqlConnection(ConString);
                    connection.Open();
                }
                else if (connection.State == System.Data.ConnectionState.Closed)
                {
                    connection.Open();
                }
                else if (connection.State == System.Data.ConnectionState.Broken)
                {
                    connection.Close();
                    connection.Open();
                }                return connection;
            }
                   
        }        //执行并返回相应行数        public static int ExecuteCommand(string SafeSql)
        {
            SqlCommand cmd = new SqlCommand(SafeSql,Connection);
            int Result = cmd.ExecuteNonQuery();
            return Result;
        }
        public static int ExecuteCommand(string SafeSql,params SqlParameter[] values)
        {
            SqlCommand cmd = new SqlCommand(SafeSql, Connection);
            cmd.Parameters.AddRange(values);
            int Result = cmd.ExecuteNonQuery();
            return Result;
        }
        //public static int E_ExecuteCommand(string SafeSql, params SqlParameter[] values)
        //{
        //    SqlCommand cmd = new SqlCommand(SafeSql, Connection);
        //    cmd.CommandType = CommandType.StoredProcedure;
        //    cmd.Parameters.AddRange(values);
        //    int Result = cmd.ExecuteNonQuery();
        //    return Result;
        //}        //执行查询并返回查询得到的第一行和第一列的对象        public static object GetScalar(string SafeSql)
        {
            SqlCommand cmd = new SqlCommand(SafeSql, Connection);
            return cmd.ExecuteScalar(); 
        }
        public static object GetScalar(string SafeSql,params SqlParameter[] values)
        {
            SqlCommand cmd = new SqlCommand(SafeSql, Connection);
            cmd.Parameters.AddRange(values);
            return cmd.ExecuteScalar();
        }        //用过sql语句返回DataReader        public static SqlDataReader GetReader(string safeSql)
        {
            SqlCommand cmd = new SqlCommand(safeSql,Connection);
            SqlDataReader reader = cmd.ExecuteReader();
            return reader;
        }        public static SqlDataReader GetReader(string safeSql,params SqlParameter[] values)
        {
            SqlCommand cmd = new SqlCommand(safeSql, Connection);
            cmd.Parameters.AddRange(values);
            SqlDataReader reader = cmd.ExecuteReader();
            return reader;
        }        //通过SQL返回DATATABLE
        public static DataTable GetTable(string safeSql)
        {
            SqlCommand cmd = new SqlCommand(safeSql,Connection);
            DataSet ds = new DataSet();
            SqlDataAdapter da = new SqlDataAdapter(cmd);
            da.Fill(ds);            return ds.Tables[0];        }        public static DataTable GetTable(string safeSql,params SqlParameter[] values)
        {
            SqlCommand cmd = new SqlCommand(safeSql, Connection);
            cmd.Parameters.AddRange(values);
            DataSet ds = new DataSet();
            SqlDataAdapter da = new SqlDataAdapter(cmd);
            da.Fill(ds);            return ds.Tables[0];        }    }
}
这个是偶自己用的一个操作数据库的类 可以实现增删改查