XML versus OLE?

[S.Sigal]

Hello:
I'm having a little trouble diving into the data side of NET -- mainly because I
find it so time consuming to create a new database, table, etc...and entering
test data (especially Guids!) for every little test scenario I want to
experiment with...

Whereas I could do this much faster if I could first experiment with some kind
of XML file that I put together, then once the sql is figured out, take the time
to create a real DB table, etc.
In other words, is there a way to interact with XML files through an
OleProvider/OdbcProvider, so that I can do database programming but "with
training wheels"?

Thank you so much for any and all suggestions,
Sky

 

[Miha Markic [MVP C#]]

Hi,

Hello:
I'm having a little trouble diving into the data side of NET -- mainly
because I
find it so time consuming to create a new database, table, etc...and
entering
test data (especially Guids!) for every little test scenario I want to
experiment with...

You might use Northwind test database...

Whereas I could do this much faster if I could first experiment with some
kind
of XML file that I put together, then once the sql is figured out, take
the time
to create a real DB table, etc.
In other words, is there a way to interact with XML files through an
OleProvider/OdbcProvider, so that I can do database programming but "with
training wheels"?

Check out XmlDataDocument.

 

[S.Sigal]

Miha -- thanks for the pointer to the XmlDataDocument -- the article at
http://www.awprofessional.com/articles/article.asp?p=29901&seqNum=5
helped.

It appears -- at first glance -- that working this way would allow for faster
testing
of db design than setting up real tables...? We'll see...

Again, thanks!
Sky