public static CreateTempTableWithAllColumns ( JET_SESID sesid, TempTableGrbit grbit, JET_TABLEID &tableid ) : JET_COLUMNID>.Dictionary |
||
sesid | JET_SESID | The session to use. |
grbit | TempTableGrbit | Temporary table options. |
tableid | JET_TABLEID | Returns the temporary table. |
리턴 | JET_COLUMNID>.Dictionary |
public void Setup() { this.instance = new Instance(Guid.NewGuid().ToString(), "RetrieveColumnsPerfTest"); this.instance.Parameters.NoInformationEvent = true; this.instance.Parameters.Recovery = false; this.instance.Init(); this.session = new Session(this.instance); // turn off logging so initialization is faster this.columnidDict = SetupHelper.CreateTempTableWithAllColumns(this.session, TempTableGrbit.ForceMaterialization, out this.tableid); // Insert a record and position the tableid on it using (var transaction = new Transaction(this.session)) using (var update = new Update(this.session, this.tableid, JET_prep.Insert)) { Api.SetColumn(this.session, this.tableid, this.columnidDict["boolean"], this.expectedBool); Api.SetColumn(this.session, this.tableid, this.columnidDict["int32"], this.expectedInt32); Api.SetColumn(this.session, this.tableid, this.columnidDict["int64"], this.expectedInt64); Api.SetColumn(this.session, this.tableid, this.columnidDict["guid"], this.expectedGuid); Api.SetColumn(this.session, this.tableid, this.columnidDict["unicode"], this.expectedString, Encoding.Unicode); update.Save(); transaction.Commit(CommitTransactionGrbit.None); } Api.TryMoveFirst(this.session, this.tableid); Thread.CurrentThread.Priority = ThreadPriority.Highest; Thread.BeginThreadAffinity(); }
public void Setup() { this.instance = new Instance(Guid.NewGuid().ToString(), "TempTableFixture"); this.instance.Parameters.Recovery = false; this.instance.Parameters.PageTempDBMin = SystemParameters.PageTempDBSmallest; this.instance.Parameters.NoInformationEvent = true; this.instance.Init(); this.session = new Session(this.instance); this.columnDict = SetupHelper.CreateTempTableWithAllColumns(this.session, TempTableGrbit.None, out this.tableid); }
public void Setup() { this.directory = SetupHelper.CreateRandomDirectory(); this.instance = SetupHelper.CreateNewInstance(this.directory); // turn off logging so initialization is faster Api.JetSetSystemParameter(this.instance, JET_SESID.Nil, JET_param.Recovery, 0, "off"); Api.JetSetSystemParameter(this.instance, JET_SESID.Nil, JET_param.PageTempDBMin, SystemParameters.PageTempDBSmallest, null); Api.JetInit(ref this.instance); Api.JetBeginSession(this.instance, out this.sesid, string.Empty, string.Empty); this.columnidDict = SetupHelper.CreateTempTableWithAllColumns(this.sesid, TempTableGrbit.None, out this.tableid); }