分享T4代码生成及源码（sqlite版），欢迎新手参考、修改（无版权）
代码生成器多少还是要打开关闭， 蛮麻烦的，
近来都直接用T4生成， 方便，快捷，
发出来，有需要的人可以参考，无版权
有心人可以帮忙弄个access版本， 和sql版本
<#@ template debug="false" hostspecific="true" language="C#" #><#@ output extension=".cs" encoding="utf-8"#><#@ assembly name="System.Configuration" #><#@ assembly name="System.Core.DLL" #><#@ assembly name="System.Data.DLL" #><#@ assembly name="System.Web.DLL" #><#@ assembly name="System." #><#@ assembly name="E:\Work\TianvCms\Htdocs\Bin\System.Data.SQLite.Dll" #><#@ import namespace="System"#><#@ import namespace="System.Collections.Generic"#><#@ import namespace="System.Data"#><#@ import namespace="System.Data.Common"#><#@ import namespace="System.Linq"#><#@ import namespace="System.Text"#><#@ import namespace="System.Data.SQLite"#><# StringBuilder sb = new StringBuilder(); using (DbConnection conn = new SQLiteConnection()) { conn.ConnectionString = @"Data Source=E:\Work\TianvCms\Htdocs\App_Data\cms.s3db;"; if (conn.State != ConnectionState.Open) conn.Open(); DataTable dt = conn.GetSchema("Columns"); List<Column> columns = new List<Column>(); foreach (DataRow dr in dt.Rows) { Column column = getColumn(dr); columns.Add(column); } List<Table> tables = new List<Table>(); foreach (string name in columns.Select(t => t.table).Distinct().OrderBy(t=>t)) { Table table = getTable(name, columns); tables.Add(table); } sb.Append(@"using System;using Tianv.Data;"); foreach (Table table in tables) { if (string.Equals(table.name, "sqlite_sequence", StringComparison.OrdinalIgnoreCase)) continue; else if (table.name.StartsWith("_")) continue; StringBuilder inters = new StringBuilder(); if (table.interfaces != null) { foreach (string temp in table.interfaces) { inters.Append(","); inters.Append(temp); } } sb.Append(@"public partial class " + table.name + @" : DbItem<" + table.name + @">"); sb.Append(inters); sb.Append(@"{"); StringBuilder sb2 = new StringBuilder(); sb2.Append(@"");// sb2.Append(@"//// public static readonly string _ = """ + table.name + @""";"); foreach (Column column in table.columns) { if (string.Equals(column.name, "id", StringComparison.OrdinalIgnoreCase)) { continue; } string t = @" public {1} {0} { get; set; }"; sb.Append(t.Replace("{0}", column.name) .Replace("{1}", getType(column.type)));// string t2 = @"// public static readonly string {0}_ = ""{0}"";";// sb2.Append(t2.Replace("{0}", column.name)); } //sb.Append(sb2); sb.Append(@"}"); } }#><#=sb.ToString()#><#+ public enum DataType { BOOL, INT, LONG, DATETIME, DECIMAL, STRING, TEXT, UNKNOW } public class Column { public string table { get; set; } public bool key { get; set; } public string name { get; set; } public int position { get; set; } public bool nullable { get; set; } public DataType type { get; set; } public int length { get; set; } public bool autoincrement { get; set; } public bool unique { get; set; } } public class Table { public string name { get; set; } public List<Column> columns { get; set; } public List<string> interfaces { get; set; } } public DataType getDataType(DataRow dr) { string type = (string)dr["DATA_TYPE"]; switch (type.ToLower()) { case "bit": return DataType.BOOL; case "int": return DataType.INT; case "integer": return DataType.LONG; case "datetime": return DataType.DATETIME; case "decimal": return DataType.DECIMAL; case "nvarchar": return DataType.STRING; case "ntext": return DataType.TEXT; default: return DataType.UNKNOW; } } public string getType( DataType type ) { switch( type ) { case DataType.BOOL: return "bool"; case DataType.INT: return "int"; case DataType.LONG: return "int"; case DataType.DATETIME: return "DateTime"; case DataType.DECIMAL: return "decimal"; case DataType.STRING: case DataType.TEXT: return "string"; default: return "object"; } } private Column getColumn(DataRow dr) { return new Column() { table = (string)dr["TABLE_NAME"], key = (bool)dr["PRIMARY_KEY"], name = (string)dr["COLUMN_NAME"], position = Convert.ToInt32(dr["ORDINAL_POSITION"]), nullable = (bool)dr["IS_NULLABLE"], type = getDataType(dr), length = Convert.ToInt32(dr["CHARACTER_MAXIMUM_LENGTH"]), autoincrement = (bool)dr["AUTOINCREMENT"], unique = (bool)dr["UNIQUE"] }; } private Table getTable(string name, List<Column> columns) { Table table = new Table() { name = name, columns = columns.Where(t => t.table == name).ToList() }; List<string> cs = table.columns .Select(t => t.name) .ToList(); Dictionary<string, string[]> inters = getInterfaces(); foreach (string key in inters.Keys) { bool isInh = true; foreach (string temp in inters[key]) { if (!cs.Contains(temp)) { isInh = false; break; } } if (isInh) { if (table.interfaces == null) table.interfaces = new List<string>(); table.interfaces.Add(key); } } return table; } private Dictionary<string, string[]> Interfaces; public Dictionary<string, string[]> getInterfaces() { if (Interfaces == null) { Interfaces = new Dictionary<string, string[]>(); Interfaces.Add("ITree", new string[] { "Sort", "ParentId", "Depth" }); Interfaces.Add("ITitle", new string[] { "Title" }); Interfaces.Add("ISort", new string[] { "Sort" }); Interfaces.Add("IStyle", new string[] { "Code_RequireJs", "Code_Js", "Code_RequireCss", "Code_Css" }); Interfaces.Add("IEnable", new string[] { "Enable" }); Interfaces.Add("ITime", new string[] { "Time_Create", "Time_Update" }); Interfaces.Add("ISeo", new string[] { "Seo_File", "Seo_Title", "Seo_Description", "Seo_Keywords" }); Interfaces.Add("IItem", new string[] { "TopicId", "Title", "Sort" });//, "Enable", "Time_Enable" } return Interfaces; } #>TAG:
