I am finally starting to convert my VB6 project into .Net... I use ADO in the
VB6 project and thought I would do the same in the .Net project. However I
was told that this is really a COM object? Is that true and if so what would
you do? I could rewrite all of the hundreds of database access code, and if
that is the right thing to do, I should probably go that route.

Ah yes, the ADO used in VB6 is COM-based. One of the real advantages of
migrating to managed code and the .NET Framework is to take advantage of
managed classes and data access providers like ADO.NET. No, I don't suggest
trying to migrate your ADO classic code. While you can call COM classes from
a managed application you have to traverse the COM interop layer that has
any number of issues that will make the process less than efficient (to say
the least). And no, you can't just take your ADO classic code and somehow
morph it to ADO.NET--they just aren't the same or even similar enough to do
this.

I wrote a book on for VB6 developers migrating to ADO.NET. Look for ADO and
ADO.NET Examples and Best Practices for VB Developers.

hth


--
__________________________________________________________________________
William R. Vaughn
President and Founder Beta V Corporation
Author, Mentor, Dad, Grandpa
Microsoft MVP
http://betav.com http://betav.com/blog/billva
(425) 556-9205 (Pacific time)
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
____________________________________________________________________________________________


"Mark Worsnop" <Mark (E-Mail Removed)> wrote in message
news:F4BA5D1B-E15B-44C0-BCB4-(E-Mail Removed)...
>I am finally starting to convert my VB6 project into .Net... I use ADO in
>the
> VB6 project and thought I would do the same in the .Net project. However
> I
> was told that this is really a COM object? Is that true and if so what
> would
> you do? I could rewrite all of the hundreds of database access code, and
> if
> that is the right thing to do, I should probably go that route.
>

THANK YOU for a great book! I purchased it when I got your post and have not
stopped reading. While this time around I am reading only, next time I will
get the code going too. I will recommend this to everyone!

Thanks. Why not post this review on Amazon?

--
__________________________________________________________________________
William R. Vaughn
President and Founder Beta V Corporation
Author, Mentor, Dad, Grandpa
Microsoft MVP
(425) 556-9205 (Pacific time)
Hitchhiker’s Guide to Visual Studio and SQL Server (7th Edition)
____________________________________________________________________________________________



"Mark Worsnop" <(E-Mail Removed)> wrote in message
news:4CABDE51-D87F-48D8-B18B-(E-Mail Removed)...
> THANK YOU for a great book! I purchased it when I got your post and have
> not
> stopped reading. While this time around I am reading only, next time I
> will
> get the code going too. I will recommend this to everyone!
>

Happy to help!!

Bill:
Did you see my other question on OLEDB?
What do you think?