public void should_create_table() { var tableName = "Temp" + Guid.NewGuid().ToString("N"); Gribble.TableSchema.Create(Database.Connection, profiler: Profiler).CreateTable(tableName, new Column("Id", typeof(Guid), key: Column.KeyType.PrimaryKey, isAutoGenerated: true), new Column("Name", typeof(string), isNullable: true, length: 500), new Column("Active", typeof(bool), isNullable: false, defaultValue: true), new Column("Score", typeof(decimal), isNullable: false, precision: 5, scale: 1), new Column("ScoreA", isNullable: false, computation: "Score * 55"), new Column("ScoreB", isNullable: false, computation: "Score * 55", computationPersisted: true), new Column("Created", typeof(DateTime), isNullable: false, isAutoGenerated: true)); Database.ExecuteScalar <int>("SELECT COUNT(*) FROM sys.tables WHERE name='{0}'", tableName).ShouldEqual(1); }