Save info in XML file or SQL?

This project allows you to use either SQL data sources or XML data sources.

I'm new to web development and am confused when it's appropriate to use SQL vs. XML.

Thanks.

Tulsi.

Re: Save info in XML file or SQL?

On web ALWAYS use Sql Server. Thinks about 10000 users create a xml file within your website folder?

Not only that your website must not have access to server files.

Re: Save info in XML file or SQL?

This makes lots of sense.

Is there any case where using xml files is justified? Reason I ask is that the Small Business Application demos the Provider Model where it supports using either SQL or XML files. I'm wondering why they did this. Any ideas on this?

Also, is the Small Business Application commonly used as a template for building applications in the real-world? Is it a good example to follow?

Thanks again for your feedback.

Tulsi.

Re: Save info in XML file or SQL?

In Asp.net you don't save anything with XML except your configurations of your website. Which is called web.config.

It could be possible to use xml to store some data but it's just used in very special scenarios.

I am sorry but I don't know the small business samples so I can't give you an advice in this topic.

But believe me you have just advantages if you use sql instead of xml.

Think also about calling datas from your xml files? You can't do as different kind of data selections as in sql.

In Sql you can make select, update, insert, delete. Specific select statements which are selecting just a few columns. So you are a lot more flexible with that.

Re: Save info in XML file or SQL?

Thanks. Your feedback has been very helpful.

tulsi