C#实现sdf数据库的创建与表结构设置

/// <summary>
      /// 创建sdf数据库
      /// </summary>
      /// <param name="path"></param>
     /// <param name="al">创建数据表语句集合；
     /// 如："Create Table TAKESTOCKDT(FLOWID int IDENTITY(1,1) PRIMARY KEY,BOOKID nvarchar(20),BOOKNAME nvarchar(145),PRICE numeric(12,4),PUBLISHER nvarchar(32),STOREQTY integer,QTY integer)"</param>
        private void BuildSdf(string path, ArrayList al)
        {
            if (System.IO.File.Exists(path))
            {
                System.IO.File.Delete(path);
            }
            //创建数据库
            SqlCeEngine CeEng = new SqlCeEngine("Data Source="+path);
            CeEng.CreateDatabase();

            //提取当前程序的版本号
            AssemblyName name = new AssemblyName();
            name.Version = new Version("0.0.0");
            Assembly a = Assembly.GetExecutingAssembly();
            name = a.GetName();

            //创建数据表
            SqlCeConnection CeConn = new SqlCeConnection("Data Source=" + path);
            try
            {
                SqlCeCommand CeCmd = CeConn.CreateCommand();
                CeConn.Open();
                //CeCmd.CommandText = "Create Table SETTING(WSLOCATION nvarchar(50),TIMEOUT integer,MAJOR integer,MINOR integer,BUILD integer)";
                //CeCmd.ExecuteNonQuery();