public void TestInt64ValueAsObject()
{
var instance = new Int64ColumnValue {
Value = 99
};
Assert.AreEqual(99L, instance.ValueAsObject);
}
public void TestInt64Length()
{
var value = new Int64ColumnValue();
foreach (long i in new[] { long.MinValue, long.MinValue + 1, -1, 0, 1, Any.Int64, 65521, long.MaxValue - 1, long.MaxValue })
{
TestLengthForStruct(value, i, 8);
}
}
public void TestInt64ValueAsObject()
{
var value = new Int64ColumnValue();
foreach (int i in new[] { long.MinValue, long.MinValue + 1, -1, 0, 1, Any.Int64, 65521, long.MaxValue - 1, long.MaxValue })
{
TestValueAsObjectForStruct(value, i);
}
}
/// <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);
}
}
public InsertView(MediaFilesTable table)
{
_table = table;
_c = new ColumnValue[2];
_c[0] = new Int64ColumnValue()
{
Columnid = _table.ColumnDictionary[MediaFilesTable.Column.SequenceNumber],
SetGrbit = SetColumnGrbit.None
};
_c[1] = new BytesColumnValue()
{
Columnid = _table.ColumnDictionary[MediaFilesTable.Column.MediaData],
SetGrbit = SetColumnGrbit.None
};
}
/// <summary>
/// Insert multiple records with the <see cref="Api.SetColumns"/> API.
/// </summary>
/// <param name="numRecords">The number of records to insert.</param>
public void InsertRecordsWithSetColumns(int numRecords)
{
var keyColumn = new Int64ColumnValue {
Columnid = this.columnidKey
};
var dataColumn = new BytesColumnValue {
Columnid = this.columnidData, Value = this.data
};
var columns = new ColumnValue[] { keyColumn, dataColumn };
for (int i = 0; i < numRecords; ++i)
{
Api.JetBeginTransaction(this.session);
Api.JetPrepareUpdate(this.session, this.table, JET_prep.Insert);
keyColumn.Value = this.GetNextKey();
Api.SetColumns(this.session, this.table, columns);
Api.JetUpdate(this.session, this.table);
Api.JetCommitTransaction(this.session, CommitTransactionGrbit.LazyFlush);
}
}
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
};
}
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 TestInt64ValueAsObject()
{
var instance = new Int64ColumnValue { Value = 99 };
Assert.AreEqual(99L, instance.ValueAsObject);
}
/// <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);
}
}
