Beispiel #1
0
 public ColumnWriterTests()
 {
     _sb       = new StringBuilder();
     _col      = new ColumnDefinition();
     _col.Name = "User Id";
     _col.Type = DbType.Boolean;
     _cw       = new SqlServerColumnWriter(_sb);
 }
Beispiel #2
0
        public void column_not_null_with_default_no_options()
        {
            var w = new SqlServerColumnWriter(_sb);

            _col.IsNullable   = false;
            _col.DefaultValue = "0";
            w.Write(_col);
            Assert.Equal("[User Id] bit NOT NULL DEFAULT 0", _sb.ToString());
        }
Beispiel #3
0
        public void column_with_identity_and_options()
        {
            var w = new SqlServerColumnWriter(_sb);

            _col.IsIdentity = true;
            _col.IsNullable = true;
            _col.Options.Add(SqlServerOptions.ColumnIs.Sparse());
            w.Write(_col);
            Assert.Equal("[User Id] bit SPARSE NULL IDENTITY(1,1)", _sb.ToString());
        }