I've tried to do my homework on this...

I'm migrating a site from **classic asp** to **asp.net 4.0**

Before I rework all the code, I wanted to get clarification that the way *i think* my database code should be updated is fairly correct. (I'm using **SQLClient** objects)

First, when old code would use forward only recordsets or access single record/value, I'm fairly sure i'd use **SqlCommand** and **SqlDataReader**. That is pretty straightforward.

Now, when my old code navigates a recordset (movePrevious, find, etc.)... I believe the way to go is with **SqlDataAdapter** and **DataTable** to retrieve the data and **DataView** to filter/find/navigate the data.

I'n looking to do a quick migration... i don't want to get too bogged down in the new entity framework... so - just trying to stick with similar objects/logic.

I know this is one of those questions that doesn't really have a right/wrong answer... and I think that is part of my problem in finding an answer - there are so many.

Thanks,

bill g