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