Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post Apr 06, 2009 06:36 PM by Tulsim83
Apr 02, 2009 06:35 PM|LINK
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.
Apr 02, 2009 08:13 PM|LINK
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.
Apr 03, 2009 07:06 PM|LINK
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.
Apr 04, 2009 10:21 PM|LINK
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.
Apr 06, 2009 06:36 PM|LINK
Thanks. Your feedback has been very helpful.