Migrating from Classic ASP to ASP.NET - equivalent objects and classes

Having spent some time familiarising oneself with the objects available in Classic ASP, it can be tricky sometimes to find the .NET framework equivalent. Here's a guide.

Classic ASP .NET Framework
Scripting.FileSystem System.IO
MSXML3.ServerXmlHttp System.Net.HttpWebRequest
CDO System.Net.Mail
Scripting.Dictionary System.Collections
ADODB.Connection[1] System.Data.SqlClient.SqlConnection
System.Data.OleDb.OleDbConnection
System.Data.Odbc.OdbcConnection
ADODB.Command[2] System.Data.SqlClient.SqlCommand
System.Data.OleDb.OleDbCommand
System.Data.Odbc.OdbcCommand
ADODB.RecordSet[3] System.Data.DataSet
System.Data.DataTable
System.Data.DataReader
rs.NextRecordSet[4] DataSet.DataTables(1)
DataReader.NextResult
Command.Execute[5] Command.ExecuteScalar
Command.ExecuteReader
Command.ExecuteNonQuery
Scripting.TextStream System.IO.SteamWriter
Response[6] HttpContext.Current.Response
Request HttpContext.Current.Request
Application HttpContext.Current.Application
Session HttpContext.Current.Session

[1] In ADO.NET, the Connection object is provider specific, unlike the generic ADO Connection object
[2] In ADO.NET, the Command object is provider specific, unlike the generic ADO Command object
[3] There is no real equivalent to a RecordSet object in ADO.NET. The DataSet is a disconnected in-memory container for data, which is held in DataTables. The DataReader is akin to a forward-only, read-only RecordSet.
[4] Methods and collection of the Response, Request, Session, Application etc objects can be referenced in ASP.NET in exactly the same way as in Classic ASP, where the reference is within the web form derived from Page. If the flow of control leaves this area, the static property Current on the HttpContext class can be used. This can be seen where the current page's querystring values are referenced from a static method in this nugget of code for paging articles.
[5] ExecuteScalar returns a one row, one column result. Usually used with aggregates like SELECT Count(ID) AS TheCount. ExecuteReader is used to return a DataReader containing the records to be processed. ExecuteNonQuery is used for INSERT, UPDATE and DELETE operations where no return value is expected.
[6] Multiple RecordSets returned in a DataSet occupy separate DataTables. The DataTables can be iterated over using their ordinal index. The DataReader offers a NextResult method which moves to the, well, next result.

Date Posted:
Last Updated:
Posted by:
Total Views to date: 17871

1 Comment

- syam

Good work. Very usefull information for .net beginner who knows classic ASP like me. Thank you.

Recent Comments

sandeep 8/28/2015 7:03 AM
In response to 7 C# 6.0 Features That Every ASP.NET Developer Should Know About
very good article, i like it........keep writing such quality article in future. thx Mike....

Hassan, MVC Learner 8/28/2015 6:37 AM
In response to Get The Drop On ASP.NET MVC DropDownLists
Great Help, simple, great and patiently explained article !...

Anvesh 8/28/2015 12:39 AM
In response to ASP.NET MVC DropDownLists - Multiple Selection and Enum Support
what if we are taking postback values from FormCollections instead of an array int[] category. How...

Ben 8/27/2015 10:50 PM
In response to Simple File Download Protection with ASP.NET
Is it possible to setup your project to publish files to outside of your root directory? I would to...

Fred 8/26/2015 12:50 AM
In response to WebMatrix Opens Wrong Version Of Visual Studio
I enjoyed many of your tutorials but the problem is none of the tutorials are combined like most be....

Muhammad Ashikuzzaman 8/25/2015 2:48 PM
In response to Managing Checkboxes And Radios In ASP.NET Razor Web Pages
That's a very good tips for razor...

Sergey 8/25/2015 8:32 AM
In response to More Flexible Routing For ASP.NET Web Pages
Hi. How I can set up my site to get urldata from link for default page? site.com/default/1-...

Tony Gray 8/25/2015 6:27 AM
In response to Adding Validation
Hi Mike, Really helpful article and series. Thanks. Small typo in 4th paragraph you have so...

amanda n 8/25/2015 12:38 AM
In response to Solving the Operation Must Use An Updateable Query error
Thank you very much. I'm a uni student and while solving coding problems is usually enjoyable and me...

salman 8/23/2015 9:25 AM
In response to How To Send Email In ASP.NET MVC
thanks ......