WithDefaultValue NEWID()

[fluentmigrator]

WithDefaultValue NEWID()

[jtreuting]

It encloses it in apostrophes because it is treating it as a string. FM doesn't know about specific built-in functions. We would need to make this generic enough to go across different databases.

We should be able to make a generic way of setting the default value to newid() or getdate() for sql server and their equivalents in other DBs.

My first thought is to make an Enum for system methods that could be passed into the WithDefaultValue() method.

public enum SystemMethods
{
NewGuid,
CurrentDateTime
}

then you would do .WithDefualtValue(SystemMethods.NewGuid) and for Sql Server it would use NEWID() while Oracle would use SYS_GUID() (I think, I'm not much of a Oracle guy).

That is my initial thought, I'll think about it more.

Any thoughts or suggestions?

[jtreuting]

I did an initial implementation using this methodology. I think it works pretty well actually. I created a new branch with the code that anyone can review and let me know what they think.

http://github.com/jtreuting/fluentmigrator/tree/sysmethods-default

[jtreuting]

This has been incorporated into the main branch