c# - COM object has a handle to a file that needs to be deleted before GC -


i have .net application using bunch of com objects (esri arcgis) convert data in file 1 format , export file in format.

i've tried looking arcgis solution problem unsuccessful after day or of research, haven't included tag on question, it's unimportant com objects are.

okay, problem when there exception during export process. catch exception, present message user, , delete export file.

the problem file.delete call throws exception because com object associated data export still has handle file, com object has no "close" method, , gc has not reclaimed memory yet.

here code:

            try {                 ...             }             catch(exception)             {                 if (directory.exists(outputfolder) && file.exists(pgdbpath))                 {                     // release references com object holding handle .mdb file.                     int refs;                     var targetworkspacename = getworkspacename(pgdbpath, "esridatasourcesgdb.accessworkspacefactory");                      // com object w/ handle file @ 'pgdbpath'                     var targetworkspace = getworkspace(targetworkspacename);                                         {                         refs = system.runtime.interopservices.marshal.releasecomobject(targetworkspace);                     } while (refs > 0);                      // need use gc clean unmanaged memory pointed released references.                     gc.collect();                     gc.waitforpendingfinalizers();                     gc.collect();                     gc.waitforpendingfinalizers();                      // throw file access exception without gc.                     file.delete(pgdbpath);                              }                  throw;             }

i'm relatively new working com objects in .net, there no other way release reference , clean memory associated object other forcing garbage collection? hate it. thanks.


Comments

Post a Comment

Popular posts from this blog

javascript - Create a stacked percentage column -

i have collection of data : var data = [ {"p301a":"10","p301b":"7","p301c":"7","p301d":"3","p301e":"8","p301f":"8","p301g":"8","p301h":"8","p301i":"8","p301j":"8","p301k":"8","p301l":"8","p301m":"8","p301n":"8","p301o":"8","age":"31-40 years","profesion":"2","position":"2"}, {"p301a":"5","p301b":"4","p301c":"4","p301d":"4","p301e":"4","p301f":"4","p301g":"4","p301h":"4","p301i":"4","p301j":"4","p301k":"4...
Read more

Optimising Firebase database by automatically overwriting data -

in firebase app have following structure: posts latest all users can write posts > latest . want limit entries 20 posts save space in database. , posts beyond 20 unnecessary never shown on homepage. how can limit posts 20, when user writes posts > latest posts @ end drop off (be deleted) automatically? this sample should you. you need : const max_log_count = 20; exports.removeold = functions.database.ref('/posts/latest/{postid}').oncreate(event => { const parentref = event.data.ref.parent; return parentref.once('value').then(snapshot => { if (snapshot.numchildren() >= max_log_count) { let childcount = 0; const updates = {}; snapshot.foreach(function(child) { if (++childcount <= snapshot.numchildren() - max_log_count) { updates[child.key] = null; } }); // update parent. removes children. ...
Read more

javascript - Angular UI-Grid customTemplate directive causing rows to load slowly/? -

Image
each grid cell can have more 1 customtemplate loaded. have directive holds watcher on model_col_field listen cell updates on scroll when dom rows updated , recompile celltemplate . without watcher , $compile rows repeat on scroll, showing same set of rows. is there more angular way of approaching or way improve performance? relevant controller code: create gridoptions.data & gridoptions.columndefs : var customtemp = '<div ng-repeat="opt in grid.appscope.colvalueoptionsmodel" ng-init="tempstring=model_col_field.clazz+opt.key;"><comparison-directive dbo="model_col_field" attobj="opt" fff="grid.appscope.getattributetemplate(tempstring)" /></div>'; $scope.gridoptions.columndefs = [ { name:'yindex',pinnedleft:true,celltemplate: customtemp, displayname:'index'}, { name:'col1',celltemplate: customtemp}, { name:'col2',celltemplate: c...
Read more