Click to See Complete Forum and Search --> : Vectors vs ADO.NET


IAmChris
August 8th, 2003, 10:35 AM
This may sound like a stupid question, but I'm VERY new to C++ and .NET and so figure I'm allowed to ask them, for now...

It seems that ADO.NET datasets (with relationships between the tables) can be used (sort of) like arrays of objects or vectors. When would you use vectors and when would you just use datasets? If I was using vectors then would I still use datasets to select/update/insert the data into the DB? If I did then I'd have 2 copies of the same data. It seems like overkill to have all my objects in memory and the dataset sitting in memory as well.

If I have a class with a dataset in it with all the data I need and then have static methods that manipulate the data, would this be considered good practice?

I'd really appreciate it if anyone could clear me up on this subject as (and I'm sure you can all tell) I'm very confused over this whole thing.

Thanks