ArcGIS Engine 删除数据方法（转）

 ArcEngine,C#数据删除几种方法和性能比较
一、  几种删除方法代码
1.  查询结果中删除

1. private void Delete1(IFeatureClass PFeatureclass)
   
2. 
   
3. {
   
4. 
   
5. IQueryFilter pQueryFilter = new QueryFilterClass();
   
6. 
   
7. pQueryFilter.WhereClause = "objectID<=" + DeleteNum;
   
8. 
   
9. IFeatureCursor pFeatureCursor = PFeatureclass.Search(pQueryFilter, false); IFeature pFeature = pFeatureCursor.NextFeature();
   
10. 
    
11. while (pFeature != null)
    
12. 
    
13. {
    
14. 
    
15. pFeature.Delete();
    
16. 
    
17. pFeature = pFeatureCursor.NextFeature();
    
18. 
    
19. }
    
20. 
    
21. System.Runtime.InteropServices.Marshal.ReleaseComObject(pQueryFilter);
    
22. 
    
23. }

复制代码

2.  更新游标删除

1. private void Delete2(IFeatureClass PFeatureclass)
   
2. 
   
3. {
   
4. 
   
5. IQueryFilter pQueryFilter = new QueryFilterClass();
   
6. 
   
7. pQueryFilter.WhereClause = "objectID<=" + DeleteNum;
   
8. 
   
9. IFeatureCursor pFeatureCursor = PFeatureclass.Update(pQueryFilter, false);
   
10. 
    
11. IFeature pFeature = pFeatureCursor.NextFeature();
    
12. 
    
13. while (pFeature != null)
    
14. 
    
15. {
    
16. 
    
17. pFeatureCursor.DeleteFeature();
    
18. 
    
19. pFeature = pFeatureCursor.NextFeature();
    
20. 
    
21. }
    
22. 
    
23. System.Runtime.InteropServices.Marshal.ReleaseComObject(pQueryFilter);
    
24. 
    
25. 
    
26. 
    
27. }

复制代码

3.  使用DeleteSearchedRows删除

1. private void Delete4(IFeatureClass PFeatureclass)
   
2. 
   
3. {
   
4. 
   
5. IQueryFilter pQueryFilter = new QueryFilterClass();
   
6. 
   
7. pQueryFilter.WhereClause = "objectID<=" + DeleteNum;
   
8. 
   
9. ITable pTable = PFeatureclass as ITable;
   
10. 
    
11. pTable.DeleteSearchedRows(pQueryFilter);
    
12. 
    
13. System.Runtime.InteropServices.Marshal.ReleaseComObject(pQueryFilter);
    
14. 
    
15. }

复制代码

4.  ExecuteSQL删除

1. private void Delete4(IFeatureClass PFeatureclass)
   
2. 
   
3. {
   
4. 
   
5. IDataset pDataset = PFeatureclass as IDataset;
   
6. 
   
7. pDataset.Workspace.ExecuteSQL("delete from " + PFeatureclass.AliasName + " where objectid<=" + DeleteNum);
   
8. 
   
9. }

复制代码

二、  测试性能和比较
1、       相同的数据条件，删除2000条记录
2、       测试代码

1. IFeatureLayer pFeatureLayer = axMapControl1.Map.get_Layer(0) as IFeatureLayer;
   
2. 
   
3. IFeatureClass PFeatureClass = pFeatureLayer.FeatureClass;
   
4. 
   
5. System.Diagnostics.Stopwatch MyWatch = new System.Diagnostics.Stopwatch();
   
6. 
   
7. MyWatch.Start();
   
8. 
   
9. Delete1(PFeatureClass)
   
10. 
    
11. //Delete2(PFeatureClass);
    
12. 
    
13. //Delete3(PFeatureClass);
    
14. 
    
15. //Delete4(PFeatureClass);
    
16. 
    
17. //Delete5(PFeatureClass);
    
18. 
    
19. MyWatch.Stop();
    
20. 
    
21. MessageBox.Show("删除时间:" + MyWatch.ElapsedMilliseconds.ToString() + "毫秒");

复制代码

3、测试情况
    测试方法
    第一次时间（单位ms）
    第一次时间（单位ms）