C# dbml 反转为表结构

表结构丢失，但是dbml代码还在，可以通过反射将结构找回。但是注释及索引等信息丢失，需自己添加

using System;
using System.Collections.Generic;
using System.Data.Linq.Mapping;
using System.Linq;
using System.Reflection;
using System.Text;

namespace TestSets
{
    public class TestForConvertDbmlToTable : TestBase
    {
        protected override string Title { get { return "测试 dbml反向生成数据库表格！"; } }

        public override void OnRunTest()
        {
            Console.WriteLine(ReverseDataTable.GenerateSqlScript(@"D:\Job\GDXX\WorkSpace\GDM\GDM.Linq\bin\Debug\GDM.Linq.dll"));
        }
    }

    public class ReverseDataTable
    {
        public static string GenerateSqlScript(string assemblyFullName)
        {
            var list = (from p in Assembly.LoadFile(assemblyFullName).GetTypes()
                        let attrs = p.GetCustomAttributes(true)
                        where attrs.Any(attr => attr is System.Data.Linq.Mapping.TableAttribute)
                        select p).ToList()
                        .Select(p => GenerateSqlCommondForCreateTable(p));
            return string.Join(Environment.NewLine, list);
        }

        private static string GenerateSqlCommondForCreateTable(Type classType)
        {
            var infoList = (from p in classType.GetProperties()
                           let attr = p.GetCustomAttributes(true).OfType<ColumnAttribute>().FirstOrDefault()
                           where attr != null
                           select new
                           {
                               p.Name,
                               attr,
                           }).ToList();
            // 存在属性CanBeNull=true，但是实际DbType为Not Null
            // var fieldsInfo = infoList.Select(p => string.Format(" [{0}] {1} {2} ", p.Name, p.attr.DbType, p.attr.CanBeNull ? "NULL" : ""));
            var fieldsInfo = infoList.Select(p => string.Format(" [{0}] {1} {2} ", p.Name, p.attr.DbType, !p.attr.DbType.ToUpper().Contains("NOT NULL") ? "NULL" : ""));

            var keyNames = infoList.Where(p => p.attr.IsPrimaryKey).Select(p => string.Format("[{0}] ASC ", p.Name)).ToList();
            var keyCommondStr = string.Format("CONSTRAINT [PK_{0}] PRIMARY KEY CLUSTERED ({1})", classType.Name, string.Join(", ", keyNames))
                                + "WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]";

            return string.Format("CREATE TABLE {0} ({1} {2})", classType.Name, string.Join(", ", fieldsInfo), keyCommondStr);
        }
    }

}