.NET Data Access

[Guest]

I am developing a new product and would like to know the best method to use to access data. My goal is to design the interface so it will utilizes the newer versions of the microsoft tools that will be coming in the next few years
1. Should the access be through web services
2. Should I pass XML back and forth
3. What technology to utilize for data access e.g use XML schemas, update grams etc

Maybe someone can point me to an article that covers this subjects and explains the best approach

The application would be a medical billing product that would have local and remote stations

Thank yo

 

[William Ryan [eMVP]]

1) Depends on you apps needs but Web Services are well suited to this task
2) In most cases yes
3) ADO.NET, DataSet.WriteXML(Filename, Diffgram), DataSet.ReadXML(Filename)

I am developing a new product and would like to know the best method to

use to access data. My goal is to design the interface so it will utilizes
the newer versions of the microsoft tools that will be coming in the next
few years.

 

[Guest]

another good idea would be to write a data access later (DAL) and implement data types that derive from each specific interface of the System.Data class (IE, ICommand, IConnection, etc)...i doubt that MS will break implementation from this

jayson