private void InitColumns()
{
// IDictionary<string, JET_COLUMNID> columnids = Api.GetColumnDictionary(_jetSession, _jetCursor);
_colIdHeaderId = Api.GetTableColumnid(_jetSession, _jetCursor, _colNameHeaderId);
_colIdEntityCount = Api.GetTableColumnid(_jetSession, _jetCursor, _colNameEntityCount);
_colIdFileVersion = Api.GetTableColumnid(_jetSession, _jetCursor, _colNameFileVersion);
_colIdHeaderData = Api.GetTableColumnid(_jetSession, _jetCursor, _colNameHeaderData);
_colValHeaderId = new Int32ColumnValue { Columnid = _colIdHeaderId };
_colValEntityCount = new Int64ColumnValue { Columnid = _colIdEntityCount };
_colValFileVersion = new StringColumnValue { Columnid = _colIdFileVersion };
_colValHeaderData = new BytesColumnValue { Columnid = _colIdHeaderData };
}
public void TestStringValueAsObject()
{
var instance = new StringColumnValue { Value = "hello" };
Assert.AreEqual("hello", instance.ValueAsObject);
}
public void TestStringColumnValueToString()
{
var instance = new StringColumnValue { Value = "foo" };
Assert.AreEqual("foo", instance.ToString());
}
/// <summary>
/// Retrieve columns using the basic RetrieveColumns API.
/// </summary>
private void RetrieveWithRetrieveColumns()
{
var boolColumn = new BoolColumnValue { Columnid = this.columnidDict["boolean"] };
var int32Column = new Int32ColumnValue { Columnid = this.columnidDict["int32"] };
var int64Column = new Int64ColumnValue { Columnid = this.columnidDict["int64"] };
var guidColumn = new GuidColumnValue { Columnid = this.columnidDict["guid"] };
var stringColumn = new StringColumnValue { Columnid = this.columnidDict["unicode"] };
var retrievecolumns = new ColumnValue[]
{
boolColumn,
int32Column,
int64Column,
guidColumn,
stringColumn,
};
for (int i = 0; i < NumRetrieves; ++i)
{
Api.JetBeginTransaction(this.session);
Api.RetrieveColumns(this.session, this.tableid, retrievecolumns);
bool actualBool = (bool)boolColumn.Value;
int actualInt32 = (int)int32Column.Value;
long actualInt64 = (long)int64Column.Value;
Guid actualGuid = (Guid)guidColumn.Value;
string actualString = stringColumn.Value;
Assert.AreEqual(this.expectedBool, actualBool);
Assert.AreEqual(this.expectedInt32, actualInt32);
Assert.AreEqual(this.expectedInt64, actualInt64);
Assert.AreEqual(this.expectedGuid, actualGuid);
Assert.AreEqual(this.expectedString, actualString);
Api.JetCommitTransaction(this.session, CommitTransactionGrbit.None);
}
}
