public static string TemplateEntity(FieldInfo field) { StringBuilder codestring = new StringBuilder(); codestring.Append("\r\npublic ") .Append(FriendlyName(field.DbType)).Append(" ") .Append(field.Name) .Append(" { get; set; } \r\n"); return codestring.ToString(); }
TableInfo GetTableInfo(string ConnectionString, string TableName) { TableInfo table = new TableInfo(); table.Name = TableName; string sql = "SELECT TOP 1 * FROM [" + TableName + "]"; using (SqlDataReader rd = SqlHelper.ExecuteReader(ConnectionString, CommandType.Text, sql)) { for (int i = 0; i < rd.FieldCount; i++) { FieldInfo field = new FieldInfo(); field.Name = rd.GetName(i); field.DbType = rd.GetFieldType(i); table.Fields.Add(field); } } return table; }