How to create table with UNIQUEIDENTIFIER as primary key

[Michael Powell]

Hello,

I am using SQL Server 2012, and I want to create a table with Guid as the primary key.

Mostly, table creation itself seems to work, but how might I instruct the fluent bits to do things like provide "newid()" for Default Value or Binding, potentially Row GUID Column (if necessary), and things such as this.

Thank you...

Best regards,

Michael Powell

[Tom Marien]

Hi Michael

How about this

Create.Table(TableName).InSchema(SchemaName)

                .WithColumn("Id").AsGuid().PrimaryKey().WithDefault(SystemMethods.NewGuid);

Hope it helps

Kr