Click here to Skip to main content
15,113,873 members

Welcome to the Lounge

   

For discussing anything related to a software developer's life but is not for programming questions. Got a programming question?

The Lounge is rated Safe For Work. If you're about to post something inappropriate for a shared office environment, then don't post it. No ads, no abuse, and no programming questions. Trolling, (political, climate, religious or whatever) will result in your account being removed.

 
GeneralRe: Is this right place? Pin
Rage2-Mar-21 5:17
professionalRage2-Mar-21 5:17 
GeneralRe: Is this right place? Pin
Dan Neely2-Mar-21 3:45
MemberDan Neely2-Mar-21 3:45 
GeneralRe: Is this right place? Pin
glennPattonInThePub32-Mar-21 4:22
professionalglennPattonInThePub32-Mar-21 4:22 
GeneralRe: Is this right place? Pin
honey the codewitch2-Mar-21 4:40
mvahoney the codewitch2-Mar-21 4:40 
GeneralRe: Is this right place? Pin
Rick York2-Mar-21 6:51
mveRick York2-Mar-21 6:51 
GeneralRe: Is this right place? Pin
trønderen2-Mar-21 7:40
Membertrønderen2-Mar-21 7:40 
GeneralRe: Is this right place? Pin
enhzflep4-Mar-21 5:20
Memberenhzflep4-Mar-21 5:20 
GeneralKicking the Can Down the Road Pin
#realJSOP2-Mar-21 0:57
mva#realJSOP2-Mar-21 0:57 
We keep our (encrypted) connection strings in (web)config files, and that requires us to create a unique deployment package for each of the eight environments and 12 web apps, seven windows services, and an assortment of in-house tools we have to support.

After a meeting about the "problem" on Friday afternoon, I came up with a way to build all of the connection strings on the fly - in code - which will relieve us of the need to create unique deployment packages. Now, we can create a single package and when it passes testing/validation in one environment, we can simply deploy it to the next environment, eventually ending up in production.

I developed the actual code for the solution, a proof-of-concept app, and a 6-page document explaining what I did. The code has almost as many lines of comments as there are lines of actual code.

The beauty of this solution is that:
- it can be used in our web apps AND our desktop apps/windows services
- multiple connection strings can be specified for each app/tool/service
- the connection strings don't actually exist as connection strings in memory until they're requested
- once requested, the connection strings are built and either Base64 encoded or 256-bit encrypted (dev's choice)
- it completely eliminates the need to maintain connection stings in config files.

Now comes the hard part - convincing management to let us implement it. Honestly? That shouldn't be the hard part.
".45 ACP - because shooting twice is just silly" - JSOP, 2010
-----
You can never have too much ammo - unless you're swimming, or on fire. - JSOP, 2010
-----
When you pry the gun from my cold dead hands, be careful - the barrel will be very hot. - JSOP, 2013

GeneralRe: Kicking the Can Down the Road Pin
Kornfeld Eliyahu Peter2-Mar-21 1:01
professionalKornfeld Eliyahu Peter2-Mar-21 1:01 
GeneralRe: Kicking the Can Down the Road Pin
pkfox2-Mar-21 1:19
professionalpkfox2-Mar-21 1:19 
GeneralRe: Kicking the Can Down the Road Pin
#realJSOP2-Mar-21 2:38
mva#realJSOP2-Mar-21 2:38 
GeneralRe: Kicking the Can Down the Road Pin
pkfox2-Mar-21 3:40
professionalpkfox2-Mar-21 3:40 
GeneralRe: Kicking the Can Down the Road Pin
#realJSOP2-Mar-21 4:07
mva#realJSOP2-Mar-21 4:07 
GeneralRe: Kicking the Can Down the Road Pin
pkfox3-Mar-21 3:04
professionalpkfox3-Mar-21 3:04 
GeneralRe: Kicking the Can Down the Road Pin
#realJSOP3-Mar-21 3:20
mva#realJSOP3-Mar-21 3:20 
GeneralRe: Kicking the Can Down the Road Pin
pkfox4-Mar-21 11:10
professionalpkfox4-Mar-21 11:10 
GeneralRe: Kicking the Can Down the Road Pin
#realJSOP4-Mar-21 7:35
mva#realJSOP4-Mar-21 7:35 
GeneralRe: Kicking the Can Down the Road Pin
pkfox5-Mar-21 3:02
professionalpkfox5-Mar-21 3:02 
GeneralRe: Kicking the Can Down the Road Pin
#realJSOP5-Mar-21 3:37
mva#realJSOP5-Mar-21 3:37 
GeneralRe: Kicking the Can Down the Road Pin
#realJSOP2-Mar-21 7:15
mva#realJSOP2-Mar-21 7:15 
GeneralRe: Kicking the Can Down the Road Pin
pkfox3-Mar-21 3:05
professionalpkfox3-Mar-21 3:05 
GeneralRe: Kicking the Can Down the Road Pin
#realJSOP3-Mar-21 3:29
mva#realJSOP3-Mar-21 3:29 
GeneralRe: Kicking the Can Down the Road Pin
Jacquers2-Mar-21 1:38
MemberJacquers2-Mar-21 1:38 
GeneralRe: Kicking the Can Down the Road Pin
Maximilien2-Mar-21 3:06
MemberMaximilien2-Mar-21 3:06 
GeneralRe: Kicking the Can Down the Road Pin
raddevus2-Mar-21 3:43
mvaraddevus2-Mar-21 3:43 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.