search

LinuxDoku / migratordotnet

Automatically exported from code.google.com/p/migratordotnet
0 stars 0 forks source link

Default values not working in Sql Server #2

Closed GoogleCodeExporter closed 8 years ago

GoogleCodeExporter commented 8 years ago 
What steps will reproduce the problem?
Add this to a migration:
Database.AddTable("People",
                new Column("Id", typeof(int), ColumnProperties.PrimaryKey, "NEWID()")
)
What is the expected output? What do you see instead?
An error is thrown "Incorrect syntax near '='"

What version of the product are you using? On what operating system?
r24

Please provide any additional information below.
SQLServerColumnPropertiesMapper.cs line 50 has an = where it should have a
space

Original issue reported on code.google.com by mcintyre...@gmail.com on 29 Feb 2008 at 3:08

GoogleCodeExporter commented 8 years ago 
Apply patch for Issue #4 first.
Bonus, UniqueIdentifier for Sql Server ;)

Original comment by lazy...@gmail.com on 12 Mar 2008 at 3:04

Attachments:

GoogleCodeExporter commented 8 years ago 
I have committed the fix for the bug, but not the Guid type.

I will create a new issue.

There should be a way to create triggers in mysql & postgres to forge guid 
behaviour
as well. Oracle im not sure.

Original comment by nick.h...@gmail.com on 21 Apr 2008 at 6:22