Azure connection string best practices -

-

i have application migrating azure. use web.config transformation manage changing database connecting string dev/staging/prod environments. how best manage these multiple connection strings in azure?

in cases doesn't matter if developer can see production credentials, can use built-in visual studio 10 config transformations. if you're looking for, follow these steps:

1.navigate azure project folder in file explorer
2. make copy of serviceconfiguration.cscfg
3. rename copy serviceconfiguration.base.cscfg
4. each build configuration (e.g. dev, staging, production), create serviceconfiguration.<build config name>.cscfg file. in these files, can use normal config transformation syntax
5. open .ccproj file in text editor
6. find following node, 

<itemgroup>     <servicedefinition include="servicedefinition.csdef" />     <serviceconfiguration include="serviceconfiguration.cscfg" /> </itemgroup>

and replace (you have edit block match build configs):

<itemgroup>     <servicedefinition include="servicedefinition.csdef" />     <serviceconfiguration include="serviceconfiguration.cscfg" />     <none include="serviceconfiguration.base.cscfg">         <dependentupon>serviceconfiguration.cscfg</dependentupon>     </none>     <none include="serviceconfiguration.dev.cscfg">         <dependentupon>serviceconfiguration.cscfg</dependentupon>     </none>     <none include="serviceconfiguration.staging.cscfg">         <dependentupon>serviceconfiguration.cscfg</dependentupon>     </none>     <none include="serviceconfiguration.production.cscfg">         <dependentupon>serviceconfiguration.cscfg</dependentupon>     </none> </itemgroup>

7.add following @ end of .ccproj file, above </project>:

<import project="$(msbuildextensionspath)\microsoft\visualstudio\v10.0\web\microsoft.web.publishing.targets" /> <target name="beforebuild">     <transformxml source="serviceconfiguration.base.cscfg" transform="serviceconfiguration.$(configuration).cscfg" destination="serviceconfiguration.cscfg" /> </target>

8.if you're using ci server doesn't have visual studio 10 installed, you'll have copy c:\program files\msbuild\microsoft\visualstudio\v10.0\web folder , contents development machine server.

update: @solarsteve noted, might have add namespace serviceconfiguration.*.cscfg files. here's example of serviceconfiguration.base.cscfg:

<sc:serviceconfiguration servicename="myservicename" osfamily="1" osversion="*" xmlns:sc="http://schemas.microsoft.com/servicehosting/2008/10/serviceconfiguration" xmlns:xdt="http://schemas.microsoft.com/xml-document-transform">   <sc:role name="myrolename">     <sc:instances count="1" />     <sc:configurationsettings>       <sc:setting name="dataconnectionstring" value="xxx" />     </sc:configurationsettings>   </sc:role> </sc:serviceconfiguration>

Comments

Post a Comment

Popular posts from this blog

android - Spacing between the stars of a rating bar? -

-
ho can set spacing beween stars? thats ratingbar: ratingbar = (ratingbar) inflater.inflate(r.layout.ratingbar, null); ratingbar.setlayoutparams(new layoutparams(layoutparams.wrap_content, layoutparams.wrap_content)); the layout: <?xml version="1.0" encoding="utf-8"?> <ratingbar xmlns:android="http://schemas.android.com/apk/res/android" style="@style/mystyle" android:layout_alignparentright="true" android:layout_height="19dp" android:layout_width="wrap_content" android:numstars="5"> </ratingbar> the style: <style name="mystyle" parent="@android:style/widget.ratingbar"> <item name="android:progressdrawable">@drawable/android_r2_ratingstar_yellow</item> <item name="android:indeterminatedrawable">@drawable/android_r2_ratingstar_grey</item> </style> thanks, cheers you have
Read more

aspxgridview - Devexpress grid - header filter does not work if column is initially hidden -

-
i'm using devexpress grid , i'm trying 'country' column display header filter properly: <dx:gridviewdatacolumn caption="country" fieldname="countryname" showincustomizationform="true" visible="false"> <settings allowheaderfilter="true"/> </dx:gridviewdatacolumn> if 'country' column set visible='true', header filter displayed should(it shows value option list). however, want 'country' column hidden, available in customization window(like in code above). in case, when column dragged outside customization window , grid , header filter clicked, javascript error encountered: element null element.addeventlistener(eventname, func, true); is known bug? there workarounds? set aspxgridview.settings.showheaderfilterbutton property true resolve problem. the following markup works fine me (i using dxperience 10.1.7): <asp:accessdatasource id="accessda
Read more

c# - How to execute a particular part of code asynchronously in a class -

-
i creating speech recognition engine that's going respond user commands.i have created button enable , disable speech recognition per user convenience.i have used dispose() of speech engine disable speech recoginition.here code private void button1_click(object sender, routedeventargs e) { engineon = !engineon; if (engineon) { speechengine = speech.createspeechengine(); //speech class creates , returns new speech engine. speechengine.audiolevelupdated += new eventhandler<audiolevelupdatedeventargs>(speechengine_audiolevelupdated); // use system's default microphone speechengine.setinputtodefaultaudiodevice(); speechengine.loadgrammar(new dictationgrammar()); // start listening speechengine.recognizeasync(recognizemode.multiple); } else { speechclass.myengine.dispose(); } } but disposal of speech obj
Read more