Saksida Bojan wrote:Is Xml Good for large databases?
What do you mean by that? Keeping all data in XML format? If yes, it is a bad idea.
Saksida Bojan wrote:Shoud i use XmlDocument or XmlReader and XmlWriter?
I am not sure that these 3 classes can be compared as each of them serves different purpose.
XmlDocument is an in-memory DOM representation of the XML and other two are used for reading and writing. If you want to persist the XML in memory and need to manipulate it(querying with XPath etc..), choose
XmlDocument can also make the data editing and writing easy. If you have a custom data structure that has to be created/persisted to XML, prefer
Saksida Bojan wrote:If i chose XmlReader and XmlWriter how would i manage to quickly delete data?
XmlDocument in such case and call its
Save() method for writing to XML file.
Saksida Bojan wrote:Is it good to connect to remote server(MySQL) using .NET Connector?
No - if it is a stand-alone application. Wrap the database access behind a web service/WCF.
Saksida Bojan wrote:I Also thinking of creating server app that will be on server betwen mysql and Client.
Is TCP good protocol or shoud i consider UDP. Currently i am reading about TCP and i am thinking if i should send XML data through TCP.
This is exactly what a WCF or web service layer does. WCF uses TCP communication and web services uses SOAP messages.