Generate ADO.NET DataSet outside .NET Framework

  • Thread starter Thread starter Guinther Pauli
  • Start date Start date
G

Guinther Pauli

Hi All

We have a big application server build using Delphi 7. Then, our idea is to
build a web tier (client) using ASP.NET / Web Forms. My idea: generate
manually a ADO.NET DataSet (XML) in Delphi 7, based in Delphi DataSets. How
Can I do this?

Thanks

Guinther
 
Hi Guinther:

First off, one mechanism for creating strongly typed datasets is a program
called xsd.exe which will be of help. But all you really need to do is use
dotent and create a few datasets, then use
DataSetName.WriteXML("Directory:\Filename.xml");

You have a fair degree of control over how the datasets are created but
you'll want to make sure you create scenarios with Datarelation objects.
From there, you'll have a good feel for how Datasets native method create
XMLFiles and you can create the same in Delphi.

Also, there is a XMLTextreader class and many others that lend themeselves
quite well to reading xml documents. Grab and XML Document from Delphi and
try opening it in ADO.NET, if it's well formed it will probably open using
just DataSet.ReadXML (the inverse of wrtie XML). You can also use the
XMLTextReaders and the rest and this should give you a good feel for things
and make the transition quite easy.

Also note that you can serialze most objects in .NET unless they
specifically prohibit it, so you may want to start playing with this too.


HTH,

Bill
 
Back
Top