Is there a built-in way to get table schema in ADO.NET?

Question

I want to get the table schema in order. This question and its answer is my question and what I want to do. However, he feels (to me) quite hacks, and, being two years old, I hoped that the answer was outdated. Is there really no way to get the table schema in its own order? (e.g. ADOX OpenSchema(adSchemaTables...) )?

Subjective question: is this not a huge gaping hole in ADO.NET at all ??

Answer 1

 exec sp_help '<tablename>' 

or

 select * from INFORMATION_SCHEMA.COLUMNS where TABLE_NAME = '<tablename>' order by ORDINAL_POSITION 

Answer 2

You can use GetSchema in the Connection object.