Sunday, 15 June 2014

c# - Windows authentication in app.config? -



c# - Windows authentication in app.config? -

in web.config, utilize windows domain authentication, aware following:

<add name="mssql" connectionstring="server=devserver;database=dbname;integrated security=sspi;" providername="system.data.sqlclient"/> . . . <system.web> <identity impersonate="true" username="domain\username" password="password" /> </system.web>

i wish know how accomplish same in windows application app.config file?

i using same connection string above, enables app connect through logged-in user.

but, wish connect through specific user.

in web.config, add together identity tag within system.web; equivalent of same in app.config?

please note need utilize connection string since app huge , connection string used connect db in numerous place.

i assumed using sql server.

use in app.config:

<configuration> <appsettings> <add key="connectionstring" value="????????????"/> </appsettings> </configuration>

???????????? replace below

with sql login

"data source=.\sqlexpress;initial catalog=mydatabasename;connect timeout=50;persist security info=true;user id=myusername;password=mypassword

with window login

"data source=.\sqlexpress;initial catalog=mydatabasename;connect timeout=50;persist security info=true

and when passing connection string sql connection utilize

configurationsettings.appsettings["connectionstring"]

or

configurationsettings.appsettings[0]

c# database-connection console-application

No comments:

Post a Comment