把数据源丛xml换到了SqlServer

升级过程用BE自带的导入导出工具。

升级过程中碰到的问题：

1.Slug没有能顺利导入

2.Tag没有导入

3.原来的评分丢失

解决办法，1，2同个自己写了代码，执行SQL语句来完成；3就不去考虑了。

1using System;
2using System.Collections.Generic;
3using System.Web;
4using System.Web.UI;
5using System.Web.UI.WebControls;
6using BlogEngine.Core;
7using BlogEngine.Core.Web.Controls;
8
9public partial class Convert_Default : System.Web.UI.Page
10...{
11    protected void Page_Load(object sender, EventArgs e)
12    ...{
13        BindPosts();
14    }
15    private void BindPosts()
16    ...{
17        Posts = Post.Posts.ConvertAll(new Converter<Post, IPublishable>(delegate(Post p) ...{ return p as IPublishable; }));
18
19        List<IPublishable> visiblePosts = Posts.FindAll(delegate(IPublishable p) ...{ return p.IsVisible; });
20        
21        //update slag
22        foreach (Post post in visiblePosts)
23        ...{
24            string tt ="UPDATE [be_Posts] SET [Slug]='" + post.Slug + "' where [title]='" + post.Title + "'";
25            Response.Write(tt + "<br/>");
26        }
27        //update tag
28        Response.Write("<br/><br/>");
29        foreach (Post post in visiblePosts)
30        ...{
31            foreach (string t in post.Tags)
32            ...{
33                string tt = "set @postID=(select top 1 postid from be_Posts where title='" + post.Title + "')"+"<br/>";
34
35                tt += "INSERT INTO [be_PostTag]([PostID],[Tag])VALUES(@postID,'"+t+"')";
36                Response.Write(tt + "<br/>");
37            }
38            
39        }
40
41    }
42    Properties#region Properties
43
44    private List<IPublishable> _Posts;
45    /**//// <summary>
46    /// The list of posts to display.
47    /// </summary>
48    public List<IPublishable> Posts
49    ...{
50        get ...{ return _Posts; }
51        set ...{ _Posts = value; }
52    }
53
54    #endregion
55}
56