Tables.CanRemove

[C Glenn]

I'm doing this:

if ((this.Tables.Contains(dt.TableName)) & (this.Tables.CanRemove(dt)))
{
this.Tables.Remove(dt);
}

and my table is not being removed. Which is fine, I guess. The things
is, I don't know why.

I have confirmed that it is the second portion of the boolean that's
saying no to my request (and, yes, the first portion is returning true).

So what are the possible reasons for CanRemove returning false? By what
criteria does its algorithm evaluate the question?

[Nicholas Paldino [.NET/C# MVP]]

C Glenn,

It's possible that there are constraints on a column which depend on a
column in the table you are trying to remove. You would have to remove
these constraints first, and then you could remove the table.

Hope this helps.
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard.caspershouse.com

"C Glenn" <no****@domain.com> wrote in message
news:%2****************@TK2MSFTNGP10.phx.gbl...

I'm doing this:

if ((this.Tables.Contains(dt.TableName)) & (this.Tables.CanRemove(dt)))
{
this.Tables.Remove(dt);
}

and my table is not being removed. Which is fine, I guess. The things
is, I don't know why.

I have confirmed that it is the second portion of the boolean that's
saying no to my request (and, yes, the first portion is returning true).

So what are the possible reasons for CanRemove returning false? By what
criteria does its algorithm evaluate the question?

[Adam Clauss]

Just to make sure - you did actually use '&&' and not '&' in your code
right?

if ((this.Tables.Contains(dt.TableName)) & (this.Tables.CanRemove(dt)))
{
this.Tables.Remove(dt);
}
--
Adam Clauss

"C Glenn" <no****@domain.com> wrote in message
news:%2****************@TK2MSFTNGP10.phx.gbl... I'm doing this:

if ((this.Tables.Contains(dt.TableName)) & (this.Tables.CanRemove(dt)))
{
this.Tables.Remove(dt);
}

and my table is not being removed. Which is fine, I guess. The things
is, I don't know why.

I have confirmed that it is the second portion of the boolean that's
saying no to my request (and, yes, the first portion is returning true).

So what are the possible reasons for CanRemove returning false? By what
criteria does its algorithm evaluate the question?

[C Glenn]

No! I used '&'. Thanks for the tip. I looked up '&&' and will use it
in situations like this in future.

Adam Clauss wrote:

Just to make sure - you did actually use '&&' and not '&' in your code
right?

if ((this.Tables.Contains(dt.TableName)) & (this.Tables.CanRemove(dt)))
{
this.Tables.Remove(dt);
}

[C Glenn]

Absolutely no constraints of any kind.
Nicholas Paldino [.NET/C# MVP] wrote:

C Glenn,

It's possible that there are constraints on a column which depend on a
column in the table you are trying to remove. You would have to remove
these constraints first, and then you could remove the table.

Hope this helps.