Results 1 to 8 of 8

Thread: [2008] ADO vs .NET Classes - Which Should I Use

  1. Aug 25th, 2008, 07:24 AM #1
    epixelman
    epixelman is offline

    Thread Starter
    Fanatic Member
    Join Date
    Oct 2003
    Posts
    1,005

    [2008] ADO vs .NET Classes - Which Should I Use

    Hi,
    I have a VB6 application that I need to convert to .NET 2008. It uses a control from ComponentOne that the subscription ran out on. I hate subscriptions (just a rant - when I buy a license I expect to use the control forever) - But I am not paying what they are asking every year.

    Anyways...

    1) Should I use ADO.NET or use the classes built in .NET.
    2) If I don't use ADO.NET, should I use the controls or not. The database itself can be in any location, so I don't want to hook up the db in the IDE of 2008.

    Reply With Quote Reply With Quote
  2. Aug 25th, 2008, 07:51 AM #2
    kmoorman
    kmoorman is offline
    Lively Member
    Join Date
    Jul 2008
    Posts
    107

    Re: [2008] ADO vs .NET Classes - Which Should I Use

    epixelman,

    ADO.Net are the built-in .Net classes for working with databases.

    Kerry Moorman
    Reply With Quote Reply With Quote
  3. Aug 25th, 2008, 07:55 AM #3
    epixelman
    epixelman is offline

    Thread Starter
    Fanatic Member
    Join Date
    Oct 2003
    Posts
    1,005

    Re: [2008] ADO vs .NET Classes - Which Should I Use

    I thought so. I read on this forum that there was a difference.

    Reply With Quote Reply With Quote
  4. Aug 25th, 2008, 09:05 AM #4
    asnider
    asnider is offline
    Lively Member
    Join Date
    Jul 2008
    Posts
    89

    Re: [2008] ADO vs .NET Classes - Which Should I Use

    what is the difference?
    Adam Snider
    Construction Accounting Software
    Reply With Quote Reply With Quote
  5. Aug 25th, 2008, 09:23 AM #5
    techgnome
    techgnome is online now
    Smooth Moperator techgnome's Avatar
    Join Date
    May 2002
    Posts
    33,804

    Re: [2008] ADO vs .NET Classes - Which Should I Use

    What differences? ADO.NET are classes built into .NET......Not sure what you've heard, but it might be misinformation.

    -tg
    * I don't respond to private (PM) requests for help. It's not conducive to the general learning of others.*
    * I also don't respond to friend requests. Save a few bits and don't bother. I'll just end up rejecting anyways.*
    * How to get EFFECTIVE help: The Hitchhiker's Guide to Getting Help at VBF - Removing eels from your hovercraft *
    * How to Use Parameters * Create Disconnected ADO Recordset Clones * Set your VB6 ActiveX Compatibility * Get rid of those pesky VB Line Numbers * I swear I saved my data, where'd it run off to??? *
    Reply With Quote Reply With Quote
  6. Aug 25th, 2008, 10:04 AM #6
    Jenner
    Jenner is offline
    PowerPoster Jenner's Avatar
    Join Date
    Jan 2008
    Location
    Mentor, OH
    Posts
    3,712

    Re: [2008] ADO vs .NET Classes - Which Should I Use

    Yes, you should use ADO.NET. It's built into .NET and they're VERY easy and powerful to use.

    If you're using Oracle or Microsoft SQL Server, there is a dedicated provider built into .NET for you to use. Everything else can use one of the generic ADO.NET providers such as ODBC or OLEDB.

    Many database companies have downloadable (freeware) dedicated .NET providers for their database. MySQL and Pervasive I know for a fact have one and are very good. When installed, you can use that instead of OLEDB or ODBC. Dedicated providers are typically faster due to their optimization, have support for custom features the database system uses, and provide a better "meshing" between .NET and the database such as with parameters.
    My CodeBank Submissions: TETRIS using VB.NET2010 and XNA4.0, Strong Encryption Class, Hardware ID Information Class, Generic .NET Data Provider Class, Lambda Function Example, Lat/Long to UTM Conversion Class, Audio Class using BASS.DLL

    Remember to RATE the people who helped you and mark your forum RESOLVED when you're done!

    "Two things are infinite: the universe and human stupidity; and I'm not sure about the universe. "
    - Albert Einstein
    Reply With Quote Reply With Quote
  7. Aug 25th, 2008, 06:21 PM #7
    jmcilhinney
    jmcilhinney is online now
    .NUT jmcilhinney's Avatar
    Join Date
    May 2005
    Location
    Sydney, Australia
    Posts
    108,502

    Re: [2008] ADO vs .NET Classes - Which Should I Use

    ADO was the data access technology of choice in VB6. ADO.NET is the data access technology of choice in VB.NET. You can use the functionality of the IDE to do much of the heavy lifting associated with ADO.NET, but it's still ADO.NET. Whether or not you choose to use data-binding, you're still using ADO.NET to interact with the data source. In .NET 3.5 you also have the option of LINQ to SQL if you're using a SQL Server database. Even then though, LINQ to SQL still uses ADO.NET under the hood.
    Why is my data not saved to my database? | MSDN Data Walkthroughs
    VBForums Database Development FAQ
    My CodeBank Submissions: VB (Sorting AlphaNumeric Strings Logically NEW, Binding a Data Reader in Windows Forms NEW) | C# (Sorting AlphaNumeric Strings Logically NEW, Binding a Data Reader in Windows Forms NEW)
    My Blog: Data Among Multiple Forms (3 parts)
    Beginner Tutorials: VB | C# | SQL
    Reply With Quote Reply With Quote
  8. Aug 25th, 2008, 07:00 PM #8
    szlamany
    szlamany is offline
    MS SQL Powerposter szlamany's Avatar
    Join Date
    Mar 2004
    Location
    CT
    Posts
    18,152

    Re: [2008] ADO vs .NET Classes - Which Should I Use

    Here is a good link

    http://www.devarticles.com/c/a/ADO.N...and-ADO.NET/1/

    sql native client...

    *** Read the sticky in the DB forum about how to get your question answered quickly!! ***

    Please remember to rate posts! Rate any post you find helpful - even in old threads! Use the link to the left - "Rate this Post".

    Some Informative Links:     [ SQL Rules to Live By ] [ Reserved SQL keywords ] [ When to use INDEX HINTS! ] [ Passing Multi-item Parameters to STORED PROCEDURES ]
    [ Solution to non-domain Windows Authentication ] [ Crazy things we do to shrink log files ] [ SQL 2005 Features ] [ Loading Pictures from DB ]

    MS MVP 2006, 2007, 2008
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width