public List <dynamic> GetColumns(Util.SqlHelper sqlHelper, string dataBaseName, string tableName) { return(sqlHelper.ExecuteDynamic(string.Format("select column_name as name,data_type as type,character_maximum_length length,is_nullable as isnullable from information_schema.columns where table_name='{0}'", tableName))); }
public List <dynamic> GetTables(Util.SqlHelper sqlHelper, string dataBaseName) { return (sqlHelper.ExecuteDynamic( "select tablename as name from pg_tables where tablename not like 'pg_%' and tablename not like 'sql_%' order by tablename")); }