i want oracle restrictions have in sql server //https://msdn.microsoft.com/en-us/library/ms136366(v=vs.110).aspx/ below method taking time in retrieving data
public override ienumerable<icolumninformation> gettablecolumnlist(itableinformation table) { var result = new list<icolumninformation>(); // if table flagged excluded bail empty list if (table.exclude) { return result; } var strb = new oracleclient.oracleconnectionstringbuilder(this.connectionstring); datatable columns; using (var connection = new oracleclient.oracleconnection(connectionstring)) { // connect database retrieve schema information. connection.open(); columns = connection.getschema("columns"); if (columns != null && columns.rows.count > 0) { columns.asenumerable().tolist() .foreach(t => result.add(new columninformation( t.field<string>("column_name"), t.isnull("length") ? 0 : t.field<int>("length"), null, t.field<string>("owner"), false, table))); } } return result; } public columninformation(string name, int length, type type, string databasetype, bool exclude = false, itableinformation parent = null) { this.name = name; this.length = length; this.type = type; this.dbtype = databasetype; this.exclude = exclude; this.parent = parent; }
where :columninformation class has constructor.
i have following questions getting columns details table in oracle:
- do have schema restrictions in oracle sql server?
- that linq giving me error of type specfications.
- data table getting data in more 5 minutes.
. help!!
Comments
Post a Comment