asp.net 创建procedure/function/trigger

 

创建一个console程式进行简单的测试：

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Reflection;
using ConsoleTest.context_att;
using System.Runtime.Remoting.Messaging;
using ConsoleTest.aspect;
using System.Data;
using System.Data.SqlClient;
using System.Text.RegularExpressions;

namespace ConsoleTest.dynamic
{
    class MainTest
    {
        public static void Main(string[] args)
        {

            string connStr = "data source=localhost;initial catalog=test; uid=sa;password=zxcvbnm123;";
            string sqName = "create procedure xx(@name varchar(255),@age varchar(255)) as declare @god int begin set @god=1 end";
            using (SqlConnection conn = new SqlConnection(connStr))
            {
                conn.Open();
                using (SqlCommand comm = new SqlCommand())
                {
                    comm.Connection = conn;
                    comm.CommandText = sqName;
                    comm.ExecuteNonQuery();
                    Console.Read();
                }
            }
        }
    }
}
直接运行一下，然后到数据库中查看就能看到相应存储过程，函数与存储过程是一样方法。