如何在 Power BI 中基于多个列应用 RLS
2025/12/22 0:03:41
本文来自于我关于.NET 内存系列文章。欢迎阅读、点评与交流~
1、.NET 中常见的内存泄漏场景及解决方案
2、.NET 文件操作中常见的内存泄漏场景梳理
在.NET文件操作中,常见的内存泄漏场景主要涉及未正确释放非托管资源和不当的对象管理:
// ❌ 未释放FileStreamvarstream=newFileStream("test.txt",FileMode.Open);// 使用后忘记关闭// ❌ 忘记释放StreamReader/Writervarreader=newStreamReader(stream);// 忘记reader.Dispose()或reader.Close()// ✅ 使用using语句(推荐)using(varstream=newFileStream("test.txt",FileMode.Open))using(varreader=newStreamReader(stream)){// 操作文件}// ✅ 手动释放FileStreamstream=null;try{stream=newFileStream("test.txt",FileMode.Open);// 操作}finally{stream?.Dispose();}publicclassFileMonitor{privateFileSystemWatcher_watcher;publicvoidStartWatching(){_watcher=newFileSystemWatcher();_watcher.Changed+=OnFileChanged;// 订阅事件}// ❌ 忘记取消订阅和Dispose// 解决方法:实现IDisposable}publicstaticclassFileCache{privatestaticList<FileStream>_openFiles=new();publicstaticvoidCacheFile(stringpath){varfs=newFileStream(path,FileMode.Open);_openFiles.Add(fs);// ❌ 静态集合持有引用}}publicasyncTaskReadFileAsync(){varstream=newFileStream("large.txt",FileMode.Open);// ❌ 如果在await之前发生异常,stream不会被释放varbuffer=newbyte[1024];awaitstream.ReadAsync(buffer,0,buffer.Length);// stream可能不会被释放}publicasyncTaskReadFileAsync(){usingvarstream=newFileStream("large.txt",FileMode.Open);varbuffer=newbyte[1024];awaitstream.ReadAsync(buffer,0,buffer.Length);}publicvoidProcessDirectory(stringpath){foreach(varfileinDirectory.GetFiles(path)){usingvarstream=File.OpenRead(file);// 处理文件}foreach(vardirinDirectory.GetDirectories(path)){ProcessDirectory(dir);// 递归调用// ❌ 如果层次很深,可能积累大量未及时释放的资源}}// ❌ 一次性读取大文件到内存varcontent=File.ReadAllText("huge_file.txt");// 可能占用大量内存// ✅ 流式处理大文件usingvarstream=newFileStream("huge_file.txt",FileMode.Open);usingvarreader=newStreamReader(stream);while(!reader.EndOfStream){varline=reader.ReadLine();// 逐行处理}// 使用Office Interop等COM组件varexcel=newMicrosoft.Office.Interop.Excel.Application();varworkbook=excel.Workbooks.Open("data.xlsx");// ❌ 忘记释放COM对象// 必须手动释放Marshal.ReleaseComObject(workbook);Marshal.ReleaseComObject(excel);publicclassFileProcessor{privateDictionary<string,byte[]>_fileCache=new();publicbyte[]GetFileData(stringpath){if(!_fileCache.ContainsKey(path)){// ❌ 缓存文件内容,可能无限增长_fileCache[path]=File.ReadAllBytes(path);}return_fileCache[path];}}using语句处理实现了IDisposable的对象IDisposable模式// 监控句柄泄漏varhandleCount=Process.GetCurrentProcess().HandleCount;// 使用性能计数器监控usingvarpc=newPerformanceCounter("Process","Handle Count",Process.GetCurrentProcess().ProcessName);publicclassSafeFileProcessor:IDisposable{privatebool_disposed=false;privateFileStream_stream;publicvoidProcessFile(stringpath){_stream=newFileStream(path,FileMode.Open);// 操作文件}protectedvirtualvoidDispose(booldisposing){if(!_disposed){if(disposing){_stream?.Dispose();}_disposed=true;}}publicvoidDispose(){Dispose(true);GC.SuppressFinalize(this);}~SafeFileProcessor(){Dispose(false);}}这些问题的核心在于理解.NET的垃圾回收机制和非托管资源管理,确保及时释放不再使用的资源。