Default Values with embeddedComments

Mar 18, 2011 at 9:11 PM
Edited Mar 18, 2011 at 9:59 PM

Using VS2008 and SS2005 I generated a DB with tables using Default values for various columns. The generated

code parsed the default script rather than accept the default 'token', such as dbo.NumericValue for a 0 value.

The Default Value DDL included embedded comments which were also parsed into the generated default value

setting. I chose to manually edit all invalid Table Columns with invalid default values.

Is this normal nHydrate 2008?
------------------------------------------------------------------------

Please disregard this post - I left the 'include header comments on' and comments are inter-mixed with|
actual SQL DDL in the Default Value setting. This is fixed in SS2005.

Thanks

Coordinator
Mar 19, 2011 at 1:32 AM

I am glad you worked this out because I do not follow what is wrong. What is "include header comments on". What is a default token? Is there anything wrong?

Mar 21, 2011 at 4:58 PM

Sorry for the confusion.

I have a SS2005 DB with table column Default Values set using scripts like "Create Default [dbo].[EmptyNumeric]" for int types. The Importer
is bring over the script rather than the value of the default - a zero.

What am I doing wrong?