In 2.0 we have used to store connection strings in app settings, app settings are useful to store constants,smtp mail settings,username and passwords of the third party api's.appsettings doesn't contain provider name.
From 3.5 on wards we are using connection strings in connection string settings.This block is useful to define connections.in this section we can give provider name also.
Moved bylitdevTuesday, March 27, 2012 8:19 AM (From:Small Basic)
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.