My query regarding sql database file connection with web application. In C#.net-asp.net , if I develop a web application then i need to connect sql database, there are two method to connect it .
1. attach database to sql server. Give id, password and server ip in connection string in webconfig file.
2. put the sql database file in App_Data folder, and in connection string give the path of sql database file.
Which one is better and why?
Difference Between both method?
(is performance of web application is effected or not in 2nd method)?