Click here to Skip to main content
15,115,667 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.

 
GeneralKicking the Can Down the Road Pin
#realJSOP2-Mar-21 0:57
mva#realJSOP2-Mar-21 0:57 
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 
The connectionstring when "at rest" is not assembled into a string. It merely exists in its component parts.

When you call the "Get" method to retrieve the connection string, it assembles the parts into a connection string, and either base64 encodes it, or 256-bit encrypts it (programmer's choice) and returns that encoded/encrypted string.

When you're ready to access the database, you simply decode/decrypt it when you send it to the SqlConnection object.

(We don't use Entity Framework or any other ORM, so this approach is no problem).

Any using base64/encryption is optional as well, you can have it return a string as plain text as well.
".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


modified 3-Mar-21 8:33am.

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 
GeneralRe: Kicking the Can Down the Road Pin
honey the codewitch2-Mar-21 4:48
mvahoney the codewitch2-Mar-21 4:48 
GeneralRe: Kicking the Can Down the Road Pin
#realJSOP2-Mar-21 6:10
mva#realJSOP2-Mar-21 6:10 
GeneralRe: Kicking the Can Down the Road Pin
honey the codewitch2-Mar-21 6:14
mvahoney the codewitch2-Mar-21 6:14 
GeneralRe: Kicking the Can Down the Road Pin
#realJSOP2-Mar-21 6:29
mva#realJSOP2-Mar-21 6:29 
GeneralRe: Kicking the Can Down the Road Pin
honey the codewitch2-Mar-21 8:24
mvahoney the codewitch2-Mar-21 8:24 
GeneralRe: Kicking the Can Down the Road Pin
NightPen3-Mar-21 7:45
MemberNightPen3-Mar-21 7:45 
GeneralRe: Kicking the Can Down the Road Pin
#realJSOP3-Mar-21 8:01
mva#realJSOP3-Mar-21 8:01 

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.