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);
}