asp.net

Question

User288063806 posted

Hi,

Can anyone please tell me   what is the main Advantages  if we are using Connection String Builder

Answer 1

User753101303 posted

Hi,

Compared with? It is just intended to easily handle each part of a connection string if needed. For example a Windows app showing a connection string UI would likely use that. Or if you want to easily get the server name from a connection string.

It doesn't make any difference regarding the db connection itself.

Answer 2

User-1838255255 posted

Hi Puspa@007,

According to your description, as far as i know, the advantage of using connnection string in web.config is that you don't need configure database in each page, you only need configure it in the web.config, then call it directly when you use it. You could check the following tutorial about how to configure it and use it:

Connection Strings In Web.config File Using ASP.NET: 

http://www.c-sharpcorner.com/code/3379/connection-strings-in-web-config-file-using-asp-net.aspx 

Best Regards,

Eric Du