ado.net

  • Thread starter Thread starter WStoreyII
  • Start date Start date
W

WStoreyII

Hello,

is ado.net a seperate language or does it just represent dot.nets data
capability.

when planning a dataapplication with a lot of data is best to link to a
outside source ie access, sql. Or is best to generate your own sources
using ado.net and xml?

WStoreyII

Thanks Again
 
ADO.NET is used to talk about the data access classes in .NET. It is not a
separate technology or language - just a section of the .NET framework.

You use ADO.NET to retrieve data from sources such as access, sql server,
etc, so I'm not sure what your second question is asking.
 
Marina, i guess that in the second question i am asking what would the best
data source to be ? I am making a project that will basically be a interface
to all of my data
finance accounts dvd ect? I am new to programming and don't know much and
am wondering which would be better

structures?
xml?
Access?

Cant afford sql so thats out anyways

but xml seems logical to me because it can be used on anything even the
above sources if neccasary

WStoreyII
 
MSDE (which *is* SQL Server) is free.
So I am not sure why you can't afford it.

MSDE has a 2GB limit for database size.
It also "slows down" if there are more han 5 concurrent processes running.
You could probably support a few hundred users with MSDE simultaneously
since each request is in milli-seconds and most time is spent looking at the
screen.

If you outgrow MSDE then you can upgrade to SQL Server.
 
Hi WS

Ms Access, SQL server, MSDE (a mini SQL server) are Microsoft databases.

SQL server and MSDE function as a service on your network.
MS Access is a file to connect to, however can be used when connected to in
the same way as any other database.

To get and store the information in those databases you can use the classes
as provided in ADO.NET or the classic ADO.

One of the techniques from ADO.NET is to store that data in so-called
Datasets. Those datasets you can process in your programs and that
possessing is often called ADO.NET. However, it is not different from
processing an Array or a Control. The structure of a Dataset is the same as
the structure from an XML file; however, it uses only the "element" tags
because it has the format of SQL compatible databases. XML is much more
extended as a database, by instance complex elements are not in a SQL type
database.

A dataset can be stored in a String by using different dotNet techniques,
the easiest one are the dataset.xmlwrite and dataset.xmlread. With that a
dataset becomes also very simple a dataset on disk in the XML format.
(Readable as a txt file).

I hope this helps?

Cor
 
Back
Top