Exemple #1
0
 /// <summary>
 /// 获取指定表名的架构信息
 /// </summary>
 /// <param name="db"></param>
 /// <param name="tableName"></param>
 /// <returns></returns>
 public static DataTable GetSchema(Database db, string tableName)
 {
     DbDataAdapter ap = db.GetDataAdapter();
     DbCommand cmd = db.GetSqlStringCommand(string.Format("SELECT * FROM {0}", tableName));
     cmd.Connection = db.CreateConnection();
     ap.SelectCommand = cmd;
     DataTable t = new DataTable();
     ap.FillSchema(t, SchemaType.Mapped);
     return t;
 }