Ejemplo n.º 1
0
        public void Init()
        {
            SqlConnectionStringBuilder csb = new SqlConnectionStringBuilder();
            csb.InitialCatalog = "TestDB";
            csb.Password = "******";
            csb.UserID = "sa";
            csb.DataSource = "localhost";

            _db = new NovaDb(csb.ToString());

            if (_db.TableExists(_testTable))
            {
                _db.Drop(_testTable).Execute();
            }

            _db.Create(_testTable)
                    .Column("id", "int IDENTITY(1,1)")
                    .Column("col1", "integer", false)
                    .Column("col2", "nvarchar(255)", false)
                    .Execute();

            _sut = _db.Table(_testTable, "id");
        }
Ejemplo n.º 2
0
        public void Init()
        {
            SqlConnectionStringBuilder csb = new SqlConnectionStringBuilder();

            csb.InitialCatalog = "TestDB";
            csb.Password       = "******";
            csb.UserID         = "sa";
            csb.DataSource     = "localhost";

            _sut = new NovaDb(csb.ToString());

            if (_sut.TableExists(_testTable))
            {
                _sut.Drop(_testTable).Execute();
            }

            _sut.Create(_testTable)
            .Column("id", "int IDENTITY(1,1)")
            .Column("col1", "integer", false)
            .Column("col2", "nvarchar(255)", false)
            .Execute();

            _table = _sut.Table(_testTable, "id");
        }