The data tier should not directly interact with the database for any CRUD operation. Instead, it should get data in XML format (XDO) and do CRUD operation on these objects. These XDO should perform the change into the database.

We need to work on XML like Dataset in ADO.Net .Can we do it?

• Do you have yet a specific schema you want to use as XDO?
• If the answer is yes, how do you plan to track changes, etc.?
• Do you want this for GUI (XLSTs maybe) or to wire the XDOs using WCF, webservices, etc.?
• Did you know about DTO templates? (http://llblgen.com/TinyForum/Messages.aspx?ThreadID=13256)

This reading of the manual section should be helpful as well: XML Support (serialization, de-serialization)