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