public void VerifyAddColumnCreatesColumn() { Cursor cursor = this.OpenCursor(); var columndef = new JET_COLUMNDEF { coltyp = JET_coltyp.Binary }; JET_COLUMNID columnid; cursor.AddColumn("newcolumn", columndef, null, out columnid); cursor.PrepareUpdate(JET_prep.Insert); cursor.SetColumn(columnid, Any.Bytes, SetColumnGrbit.None); }
public void VerifyAddColumnWithDefaultValueCreatesColumnWithDefaultValue() { byte[] defaultValue = Any.Bytes; Cursor cursor = this.OpenCursor(); var columndef = new JET_COLUMNDEF { coltyp = JET_coltyp.Binary }; JET_COLUMNID columnid; cursor.AddColumn("column_with_default", columndef, defaultValue, out columnid); cursor.MoveFirst(); CollectionAssert.AreEqual(defaultValue, cursor.RetrieveColumn(columnid, RetrieveColumnGrbit.None)); }
public void TestRetrieveAsDateTime() { Cursor cursor = this.OpenCursor(); var columndef = new JET_COLUMNDEF { coltyp = JET_coltyp.DateTime }; JET_COLUMNID columnid; cursor.AddColumn("test", columndef, null, out columnid); var expected = Any.DateTime; cursor.PrepareUpdate(JET_prep.Insert); cursor.SetColumn(columnid, BitConverter.GetBytes(expected.ToOADate()), SetColumnGrbit.None); cursor.GotoBookmark(cursor.Update()); var actual = cursor.RetrieveColumnAsDateTime(columnid, RetrieveColumnGrbit.None); Assert.AreEqual(expected, actual); }
public void TestRetrieveAsByte() { Cursor cursor = this.OpenCursor(); var columndef = new JET_COLUMNDEF { coltyp = JET_coltyp.UnsignedByte }; JET_COLUMNID columnid; cursor.AddColumn("test", columndef, null, out columnid); var expected = Any.Byte; cursor.PrepareUpdate(JET_prep.Insert); cursor.SetColumn(columnid, new[] { expected }, SetColumnGrbit.None); cursor.GotoBookmark(cursor.Update()); var actual = cursor.RetrieveColumnAsByte(columnid, RetrieveColumnGrbit.None); Assert.AreEqual(expected, actual); }
public void TestRetrieveAsGuid() { Cursor cursor = this.OpenCursor(); // Use binary because not all version of Esent support guid columns var columndef = new JET_COLUMNDEF { coltyp = JET_coltyp.Binary }; JET_COLUMNID columnid; cursor.AddColumn("test", columndef, null, out columnid); var expected = Guid.NewGuid(); cursor.PrepareUpdate(JET_prep.Insert); cursor.SetColumn(columnid, expected.ToByteArray(), SetColumnGrbit.None); cursor.GotoBookmark(cursor.Update()); var actual = cursor.RetrieveColumnAsGuid(columnid, RetrieveColumnGrbit.None); Assert.AreEqual(expected, actual); }