Jason,
I find this to be a pain point when trying to convert non-managed
data-manipulating apps to .NET. There isn't really a good story for
migration. Because you don't want to be stuck with the data model of ADO,
you don't want to use COM interop with the ADO COM libraries, but at the
same time, you want to protect the initial investment.
A proper design can help mitigate this somewhat, but it's still going to
be painful, because the core data container is changing. The best way I can
think of to get around this would be to develop your .NET code the way you
want it to be, without thought to the existing code. Then, I would write a
layer that would convert the data exposed by the .NET code in a manner that
can be consumed by your existing ASP application. The difficult part here
is that DataSets do not convert easily to Recordsets in ADO. It depends on
how complex your data is.
Using ADO in C# is easy. I believe the primary interop assemblies for
ADO are already included with the .NET framework. When you go to add a
reference, you should see it in the .NET section. If not, the list on the
COM tab will definitely contain the Microsoft ActiveX Data Objects.
Hope this helps.
--
- Nicholas Paldino [.NET/C# MVP]
-
mv*@spam.guard.caspershouse.com
"jason" <ia****@yahoo.com> wrote in message
news:11*********************@z14g2000cwz.googlegro ups.com...
the enterprise is going to eventually convert the existing ASP Classic
website to ASP.NET
until that time, development has already begun for a C# library of
business objects. for the most part, the ASP Classic can make use of
the C# business objects without problem, because they were compiled and
registered through COM Interop.
however i have just reached a point of uncertainty: sets of data.
obviously C# has no problem using the ADO.NET objects to retrieve sets
of data, but so far the libraries can't seem to pass an SqlDataReader
object to ASP Classic, because those objects aren't COM friendly.
likewise, i haven't had much luck figuring out if/how C# can use ADO
Classic objects.
so that leaves me wondering how a C# class using COM Interop to be
instantiated in ASP Classic can pass an object with a set of data to
the ASP code.
thanks in advance for any help,
jason