Checking for table existence

[Guru]

Cool down, dear, I'm at the office.

Real meaning: No.

 

[ML]

ML

 

[Cor Ligthert[MVP]]

Herfried,

I find the IsDate a better sample.

Although I find that the Try should be tried to be avoided is it most
common in by instance sitations as the ISDate. To create all possibilities
in code about that, would cost more then the simple catch for an error (as
it is done behind the scene).

Cor

 

[Guru]

Cool down, dear, I'm at the office.

Real meaning: No.

 

[J.B. Moreno]

Please, reread what have you written before. How can one "test within a very
good degree of likelihood whether or not the command will
execute properly " without knowing the connection state?

Not to defend a self-admitted troll, but...by having known common
failures.


If a particular condition always causes a failure, and that condition
is the cause of X% of failures, you can avoid making an attempt that is
doomed to failure by first testing the condition.

If X is the vast majority of failures, then your confidence in the
success of an attempt can reasonably be tied to whether or not the
condition exist.

So, empirical data can tell you where to put your effort.

(On the other hand, I think your basic point was that exceptions
shouldn't be used when there is a more straightforward way of returning
the same information is valid).

 

[Miha Markic]

So, empirical data can tell you where to put your effort.

Sure, empirical data helps - but that's it. But you still don't know whether
connection will hold or not as you can't predict future from past.

(On the other hand, I think your basic point was that exceptions
shouldn't be used when there is a more straightforward way of returning
the same information is valid).

Yep, that was my point.

 

[Miha Markic]

So, empirical data can tell you where to put your effort.

And don't forget that doing ping is also a performance issue - you would
need two roundtrips to the server instead of one.

 

[Guru]

And don't forget that doing ping is also a performance issue - you would
need two roundtrips to the server instead of one.

LMAO - you will write any old crap just to try and avoid losing face.

 

[SurturZ]

If a tree falls in a forest and nobody hears it, does it mak a sound?

If a man says something in a forest, is he still wrong?

 

[Guru]

If a man says something in a forest, is he still wrong?

if a bare-footed girl with clogs on is stood sitting on the grass, can she
get up without moving to go around a straight bend to see an already dead
dog die?

 

[RobinS]

I'm going to take mercy on you. I think this is what you are looking for:

private bool TableExists(string connString, string tableName)
{
SqlConnection cn = New SqlConnection(connString);
cn.Open();
DataTable dt = cn.GetSchema("Tables");
foreach (DataRow rw in dt.Rows)
{
if (rw("TABLE_NAME")).ToUpper() == tableName)
return true;
}
return false;
}

RobinS.

 

[John]

Hi Robin

Many thanks, I'll use this one.

Thanks again.

Regards