|
public void CheckDatabaseConnection()
{
try
{
using (new MyDbContext())
{
return true;
}
}
catch (Exception ex)
{
return false;
}
}I think that should be it, from the top of my head 
Of course I had to make some assumptions regarding language, framework and database, but they weren't mentioned
|
|
|
|
|
void or bool on your method signature return type?
|
|
|
|
|
Uhhh... Yes, that was the homework!
Spot the error.
You passed the test.
Good work, young padawan.
|
|
|
|
|
|
1) open an editor
2) start typing the code
3) when coding ready, compile it
... 3a) If compiling errors, solve them
... 3b) If no errors, go to next point
4) test the application and search for runtime errors
... 4a) If runtime errors, solve them
... 4b) If no error, go to next point
5) deploy
is the procedure clear enough? 
I'll go get my coat
M.D.V. 
If something has a solution... Why do we have to worry about?. If it has no solution... For what reason do we have to worry about?
Help me to understand what I'm saying, and I'll explain it better to you
Rating helpful answers is nice, but saying thanks can be even nicer.
|
|
|
|
|
it's like real life!!
your clueles boss comes up with vague spec.
You need to discuss with him for some possible solution...
|
|
|
|
|
Here is the code for ADO.NET that opens a SQL database for you...
Note: "csConnectionString" is a class level variable declaration
Friend Sub Execute_OpenConnection(ByRef poSqlConnection As SqlConnection)
Try
poSqlConnection = New SqlConnection(csConnectionString)
poSqlConnection.Open()
Catch loSqlException As SqlException
Throw loSqlException
Catch loException As Exception
Throw loException
End Try
End Sub
Steve Naidamast
Sr. Software Engineer
Black Falcon Software, Inc.
blackfalconsoftware@outlook.com
|
|
|
|
|
If Sigmund stood on a banana, would that be a Freudian slip?
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
|
|
|
|
|
Ahh we need a :boomTish: emoticon
|
|
|
|
|
after that would certainly be a good idea for him to lie down on his couch
Sin tack ear lol
Pressing the any key may be continuate
|
|
|
|
|
No. Sometimes a banana is just a banana.
|
|
|
|
|
When he hit the ground and uttered an obsenity if no one was around to hear it would it still be obscene?
New version: WinHeist Version 2.2.2 Beta I told my psychiatrist that I was hearing voices in my head. He said you don't have a psychiatrist!
|
|
|
|
|
Where's the proof anything was uttered?
I mean it's not as if there would be a dead tree lying about to show for it.
So no, would not be obscene, nor even an utterance.
(Unless the cat was watching, I hear they are bringing them out with IoT pretty soon.)
Sin tack ear lol
Pressing the any key may be continuate
|
|
|
|
|
The utterance produced a vibration which is the definition of sound. If a Marine was there to receive the obsenity, it would not be an obsenity.
So the abswer would be a positive maybe.
New version: WinHeist Version 2.2.2 Beta I told my psychiatrist that I was hearing voices in my head. He said you don't have a psychiatrist!
|
|
|
|
|
The banana motif in your question is obviously a manifestaton of a childhood trauma, caused by something or other.
For £200 an hour, a good analyst should be able to discover the cause within a year or two. 
If you have an important point to make, don't try to be subtle or clever. Use a pile driver. Hit the point once. Then come back and hit it again. Then hit it a third time - a tremendous whack.
--Winston Churchill
|
|
|
|
|
I thought that was what he worn to go out at night. 
Mongo: Mongo only pawn... in game of life.
|
|
|
|
|
Will the Jung kids get that joke?
|
|
|
|
|
I'll not couch my thoughts about this: ID am happy to admit I was psyched about today's ToD, and not for nothing!
| Ravings en masse^ |
|---|
| "The difference between genius and stupidity is that genius has its limits." - Albert Einstein | | "If you are searching for perfection in others, then you seek disappointment. If you are seek perfection in yourself, then you will find failure." - Balboos HaGadol Mar 2010 |
|
|
|
|
|
|
I find the concept apeeling.
/ravi
|
|
|
|
|
I've just decided I'm gonna try my best not to obsessively burn everything I have to DVD anymore.
My internet connection is pretty slow (5mbps DSL is all I can get), so a long time ago, I decided that "if I'm going to take the time to download it, I might as well burn it to disc". At 20 cents per blank DVD-R, why not?
Moving forward...not so much. For years I've been paying $20 for a spindle of 100 blank DVDs, and they're only getting harder and harder to find at that price, thanks I believe to this lovely tax copyright levy on blank media we have here in Canada, that is causing discs to be more and more expensive over time.
Whereas spinning drives are getting larger and cheaper. It's now cheaper, per GB, to buy hard drives than blank DVDs.
How late to this party am I?
|
|
|
|
|
I haven't burnt a CD or DVD in ooooh, 5 or more years.
Everything goes on my NAS: 4 off 4TB HDD in RAID 5, giving me about n12TB of "protected" storage.
And I don't have to hunt through a stack of DVDs going "which bloody one is it on?" 
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
|
|
|
|
|
OriginalGriff wrote: And I don't have to hunt through a stack of DVDs going "which bloody one is it on?"
That's also part of why I'm making the move.
I'm fairly well organized, and I've been using a cataloging app for probably over a decade, which can show me the exact content of a disc without having to insert it (it retrieves all file properties and can present the content pretty much as if I was looking at the file system in Explorer)...but for reasons I won't get into, that data file got corrupt without me realizing it, and I backed it up over my good backup, and the monthly rotating backup before that... 
I do have a NAS...that didn't keep me from burning stuff to disc however.
|
|
|
|
|
For the same reason, I copied all my music CDs to the hard disk.
Over the years, my CD collection grew to a couple thousand albums, and I spent an increasing amount of time searching back and forth for this and that piece of music - especially when I know that I have got another version of the same piece, but I don't remember which artist made it. Nowadays, when I buy a new CD (yes, I still do!) I play it once, ripping it to the hard disk. Thanks to the online CD databases (such as CDDB), accessed by the ripping program, the file name usually reflects the work title, available for ordinary file search.
I am so old fashioned that I want to keep the CD as a backup. Young people don't see why. I even used to burn CD copies of the radio plays etc. that I have recorded. The only reason why I don't do that any more is that my archives are so full of material that I don't do much recording!
|
|
|
|
|
Yeah got a couple of external HDD's. Consider that even dirt cheap 1 TB = 250 DVD's and a lot cheaper.
avoid getting too many though, otherwise same thing .... which one is it on again?, which was the last one?
My suggestion: get 2 - 3 in different colors, more than enough.
Also upgraded desktop internal to SSD (also to cheap to ignore), left the 1G HDD in there for automated backups, and finally a recovery bootable thumb drive - what else is needed?
In fact while ago shrunk the desktop box and pulled out the DVD-RW. (Then threw it away, temporarily put it on the floor, along came of the daughters birds and literally shat on it on what looked like a sensitive moving part - ya can't house train birds.)
Sin tack ear lol
Pressing the any key may be continuate
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
