ADO Object Library 2.0, 2.5 compatibility issues

Question

1.00/5 (2 votes)

See more:

I currently do most of my programming in VB.NET and C# making use of ADO.NET for data access. However ADO.NET is terribly slow compared to ADO (for VB6). I know I can use ADO in my VB.NET projects. Before I commit to using this in large project does anyone know of any compatibility issues with .NET framework, Windows 7, Windows 8 etc.

Posted 5-Nov-14 4:48am

codejet

Add a Solution

Comments

Maciej Los 5-Nov-14 10:54am

Why do you claim that ADO.NET is terribly slowest than ADO? I do not experienced that.
What kind of compatibility issues?

PIEBALDconsult 5-Nov-14 10:56am

"ADO.NET is terribly slow compared to ADO (for VB6)"
You're probably doing it wrong.

codejet 5-Nov-14 11:01am

Its working so I dont think I am doing it wrong maybe I am just doing it bad.

Richard Deeming 5-Nov-14 11:18am

If your ADO.NET code is working, but is slower than the equivalent ADO code, then you must be doing something wrong.

Update your question with an example, and we'll probably be able to tell you what the problem is.

codejet 5-Nov-14 10:58am

I have experienced it. My first my major project was converting VB6 code to VB.NET code. So I did away with ADO and replaced it with ADO.NET there is a huge difference in speed.

DamithSL 5-Nov-14 11:03am

can you provide sample code you do with ado.net?

Maciej Los 5-Nov-14 16:24pm

Your first project was "converted". It's not the same as created, written from the beginning to the end.

codejet 7-Nov-14 1:02am

Thank you. ( I am not being sarcastic)

Maciej Los 7-Nov-14 1:41am

Sorry... if you feel i was sarcastic. It wasn't my intention.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Maciej Los · Answer 1 · 2014-11-05T05:03:00

Solution 1

Please read my comment. In my opinion your question is too vague.

I know ADO is still supported by MS and can be used with VB6, VBA and even VB.NET projects, BUT... it's (very) old technology and does not supports many features avaliable in ADO.NET.
Comparison of ADO.NET and ADO[^]
Comparison of ADO and ADO.NET[^]

Posted 5-Nov-14 5:03am

Maciej Los

Comments

Manas Bhardwaj 5-Nov-14 14:37pm

+5

Maciej Los 5-Nov-14 14:48pm

Thank you, Manas ;)

Sergey Alexandrovich Kryukov 5-Nov-14 16:19pm

5ed.
—SA

Maciej Los 5-Nov-14 16:21pm

Thank you, Sergey ;)