Just wondering why will you drop before creating in a unit test?
And, are you sure DROP column is being sent by the Drop() function? i never
seen DROP Columns in my logs...(that doesn't mean a lot, but in every app it
only drop constraints and tables)
Gustavo.
On Mon, Oct 27, 2008 at 11:29 PM, Bil Simser <[EMAIL PROTECTED]> wrote:
>
> I have a unit test that generates our database scripts for us. The
> first thing it does is create the drop script then a creation script.
> Its on the drop script that it's failing.
>
> Here's my test:
>
> [Test]
> public void GenerateSqlScripts()
> {
> var cfg = new Configuration();
> cfg.Configure();
> var export = new SchemaExport(cfg);
> export.SetOutputFile("DMTools_Create_Tables.sql");
> export.SetDelimiter("\r\n");
> export.Drop(true, false);
> }
>
> And here's the beginning of the script its creating:
>
> ALTER TABLE NumberRequest DROP COLUMN SubmissionNumber
>
> if exists (select 1 from sys.objects where object_id =
> OBJECT_ID(N'[FK8CF8CE147E4F923C]') AND parent_object_id =
> OBJECT_ID('SubmissionTypeAttribute'))
> alter table SubmissionTypeAttribute drop constraint
> FK8CF8CE147E4F923C
>
>
> if exists (select 1 from sys.objects where object_id =
> OBJECT_ID(N'[FK18FFC40D9E29DE20]') AND parent_object_id =
> OBJECT_ID('NumberRequestAttributeValues'))
> alter table NumberRequestAttributeValues drop constraint
> FK18FFC40D9E29DE20
>
> Obviously the drop script is failing because it tries to ALTER a table
> called NumbeRequest and it's not there (on a new database). Just
> wondering why all the other tables are wrapped in an "if exists"
> statement to prevent errors (in case the table isn't there) but this
> one isn't? It's not any different from other tables in the solution.
> >
>
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"nhusers" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/nhusers?hl=en
-~----------~----~----~----~------~----~------~--~---
