<html> <head> <META http-equiv="Content-Type" content="text/html; charset=utf-8"> <title>Filling The Database</title> <link rel="stylesheet" type="text/css" href="../../../style.css"> </head> <body> <div class="CommonContent"> <div class="CommonContentArea"> <h1>Filling The Database</h1><script> //We attach this function to a browser object as a variable so that if multiple of these blocks are //present on the same page, then they will simply over-write eachother with the same function instead //of generating a naming collision. window.WikiCodeFormattingCopyToClipboard = function copyToClipboard(sID){ var sContent = document.getElementById(sID).innerText; if( window.clipboardData && clipboardData.setData ) { clipboardData.setData("Text", sContent); } else { alert("You must enable javascript access to your clipboard for this feature to work. Please referr to your browser documentation or Google search for instructions."); } } </script> <span name="cs_wiki_filter" csw_filters="cs"> <div class="FormattedSourceCode"><div class="fscHeader"><span class="fscFileName">ListDeletingExample.cs: <span class="fscMemberName">FillUpDb</span></span></div><div class="fscCode"><pre ID="ResourcesReferenceObject_LifecycleDelete_BehaviorListDeletingCS.ZipsListDeletingExample.Cs_ListDeletingExample.Cs_FillUpDb_53_64"><div><!-- Code highlighting produced by Actipro CodeHighlighter (freeware) http://www.CodeHighlighter.com/ --><span style="color: #008080;">01</span><img src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/None.gif" align="top"/><span style="color: #0000FF;">private</span><span style="color: #000000;"> </span><span style="color: #0000FF;">static</span><span style="color: #000000;"> </span><span style="color: #0000FF;">void</span><span style="color: #000000;"> FillUpDb(</span><span style="color: #0000FF;">int</span><span style="color: #000000;"> listCount) </span><span style="color: #008080;">02</span><span style="color: #000000;"><img id="ResourcesReferenceObject_LifecycleDelete_BehaviorListDeletingCS.ZipsListDeletingExample.Cs_ListDeletingExample.Cs_FillUpDb_53_64_52_1226_Open_Image" src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/ExpandedBlockStart.gif" align="top" onClick="this.style.display='none'; document.getElementById('ResourcesReferenceObject_LifecycleDelete_BehaviorListDeletingCS.ZipsListDeletingExample.Cs_ListDeletingExample.Cs_FillUpDb_53_64_52_1226_Open_Text').style.display='none'; document.getElementById('ResourcesReferenceObject_LifecycleDelete_BehaviorListDeletingCS.ZipsListDeletingExample.Cs_ListDeletingExample.Cs_FillUpDb_53_64_52_1226_Closed_Image').style.display='inline'; document.getElementById('ResourcesReferenceObject_LifecycleDelete_BehaviorListDeletingCS.ZipsListDeletingExample.Cs_ListDeletingExample.Cs_FillUpDb_53_64_52_1226_Closed_Text').style.display='inline';"/><img id="ResourcesReferenceObject_LifecycleDelete_BehaviorListDeletingCS.ZipsListDeletingExample.Cs_ListDeletingExample.Cs_FillUpDb_53_64_52_1226_Closed_Image" src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/ContractedBlock.gif" align="top" style="display: none;" onClick="this.style.display='none'; document.getElementById('ResourcesReferenceObject_LifecycleDelete_BehaviorListDeletingCS.ZipsListDeletingExample.Cs_ListDeletingExample.Cs_FillUpDb_53_64_52_1226_Closed_Text').style.display='none'; document.getElementById('ResourcesReferenceObject_LifecycleDelete_BehaviorListDeletingCS.ZipsListDeletingExample.Cs_ListDeletingExample.Cs_FillUpDb_53_64_52_1226_Open_Image').style.display='inline'; document.getElementById('ResourcesReferenceObject_LifecycleDelete_BehaviorListDeletingCS.ZipsListDeletingExample.Cs_ListDeletingExample.Cs_FillUpDb_53_64_52_1226_Open_Text').style.display='inline';"/> </span><span id="ResourcesReferenceObject_LifecycleDelete_BehaviorListDeletingCS.ZipsListDeletingExample.Cs_ListDeletingExample.Cs_FillUpDb_53_64_52_1226_Closed_Text" style="border: solid 1px #808080; background-color: #FFFFFF; display: none;">...</span><span id="ResourcesReferenceObject_LifecycleDelete_BehaviorListDeletingCS.ZipsListDeletingExample.Cs_ListDeletingExample.Cs_FillUpDb_53_64_52_1226_Open_Text"><span style="color: #000000;">{ </span><span style="color: #008080;">03</span><span style="color: #000000;"><img src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/InBlock.gif" align="top"/> </span><span style="color: #0000FF;">int</span><span style="color: #000000;"> dataCount </span><span style="color: #000000;">=</span><span style="color: #000000;"> </span><span style="color: #800080;">50</span><span style="color: #000000;">; </span><span style="color: #008080;">04</span><span style="color: #000000;"><img src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/InBlock.gif" align="top"/> Stopwatch sw </span><span style="color: #000000;">=</span><span style="color: #000000;"> </span><span style="color: #0000FF;">new</span><span style="color: #000000;"> Stopwatch(); </span><span style="color: #008080;">05</span><span style="color: #000000;"><img src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/InBlock.gif" align="top"/> File.Delete(Db4oFileName); </span><span style="color: #008080;">06</span><span style="color: #000000;"><img src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/InBlock.gif" align="top"/> IObjectContainer db </span><span style="color: #000000;">=</span><span style="color: #000000;"> Db4oFactory.OpenFile(Db4oFileName); </span><span style="color: #008080;">07</span><span style="color: #000000;"><img src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/InBlock.gif" align="top"/> </span><span style="color: #0000FF;">try</span><span style="color: #000000;"> </span><span style="color: #008080;">08</span><span style="color: #000000;"><img id="ResourcesReferenceObject_LifecycleDelete_BehaviorListDeletingCS.ZipsListDeletingExample.Cs_ListDeletingExample.Cs_FillUpDb_53_64_267_968_Open_Image" src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/ExpandedSubBlockStart.gif" align="top" onClick="this.style.display='none'; document.getElementById('ResourcesReferenceObject_LifecycleDelete_BehaviorListDeletingCS.ZipsListDeletingExample.Cs_ListDeletingExample.Cs_FillUpDb_53_64_267_968_Open_Text').style.display='none'; document.getElementById('ResourcesReferenceObject_LifecycleDelete_BehaviorListDeletingCS.ZipsListDeletingExample.Cs_ListDeletingExample.Cs_FillUpDb_53_64_267_968_Closed_Image').style.display='inline'; document.getElementById('ResourcesReferenceObject_LifecycleDelete_BehaviorListDeletingCS.ZipsListDeletingExample.Cs_ListDeletingExample.Cs_FillUpDb_53_64_267_968_Closed_Text').style.display='inline';"/><img id="ResourcesReferenceObject_LifecycleDelete_BehaviorListDeletingCS.ZipsListDeletingExample.Cs_ListDeletingExample.Cs_FillUpDb_53_64_267_968_Closed_Image" src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/ContractedSubBlock.gif" align="top" style="display: none;" onClick="this.style.display='none'; document.getElementById('ResourcesReferenceObject_LifecycleDelete_BehaviorListDeletingCS.ZipsListDeletingExample.Cs_ListDeletingExample.Cs_FillUpDb_53_64_267_968_Closed_Text').style.display='none'; document.getElementById('ResourcesReferenceObject_LifecycleDelete_BehaviorListDeletingCS.ZipsListDeletingExample.Cs_ListDeletingExample.Cs_FillUpDb_53_64_267_968_Open_Image').style.display='inline'; document.getElementById('ResourcesReferenceObject_LifecycleDelete_BehaviorListDeletingCS.ZipsListDeletingExample.Cs_ListDeletingExample.Cs_FillUpDb_53_64_267_968_Open_Text').style.display='inline';"/> </span><span id="ResourcesReferenceObject_LifecycleDelete_BehaviorListDeletingCS.ZipsListDeletingExample.Cs_ListDeletingExample.Cs_FillUpDb_53_64_267_968_Closed_Text" style="border: solid 1px #808080; background-color: #FFFFFF; display: none;">...</span><span id="ResourcesReferenceObject_LifecycleDelete_BehaviorListDeletingCS.ZipsListDeletingExample.Cs_ListDeletingExample.Cs_FillUpDb_53_64_267_968_Open_Text"><span style="color: #000000;">{ </span><span style="color: #008080;">09</span><span style="color: #000000;"><img src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/InBlock.gif" align="top"/> sw.Start(); </span><span style="color: #008080;">10</span><span style="color: #000000;"><img src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/InBlock.gif" align="top"/> </span><span style="color: #008080;">11</span><span style="color: #000000;"><img src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/InBlock.gif" align="top"/> </span><span style="color: #0000FF;">for</span><span style="color: #000000;"> (</span><span style="color: #0000FF;">int</span><span style="color: #000000;"> i </span><span style="color: #000000;">=</span><span style="color: #000000;"> </span><span style="color: #800080;">0</span><span style="color: #000000;">; i </span><span style="color: #000000;"><</span><span style="color: #000000;"> listCount; i</span><span style="color: #000000;">++</span><span style="color: #000000;">) </span><span style="color: #008080;">12</span><span style="color: #000000;"><img id="ResourcesReferenceObject_LifecycleDelete_BehaviorListDeletingCS.ZipsListDeletingExample.Cs_ListDeletingExample.Cs_FillUpDb_53_64_366_927_Open_Image" src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/ExpandedSubBlockStart.gif" align="top" onClick="this.style.display='none'; document.getElementById('ResourcesReferenceObject_LifecycleDelete_BehaviorListDeletingCS.ZipsListDeletingExample.Cs_ListDeletingExample.Cs_FillUpDb_53_64_366_927_Open_Text').style.display='none'; document.getElementById('ResourcesReferenceObject_LifecycleDelete_BehaviorListDeletingCS.ZipsListDeletingExample.Cs_ListDeletingExample.Cs_FillUpDb_53_64_366_927_Closed_Image').style.display='inline'; document.getElementById('ResourcesReferenceObject_LifecycleDelete_BehaviorListDeletingCS.ZipsListDeletingExample.Cs_ListDeletingExample.Cs_FillUpDb_53_64_366_927_Closed_Text').style.display='inline';"/><img id="ResourcesReferenceObject_LifecycleDelete_BehaviorListDeletingCS.ZipsListDeletingExample.Cs_ListDeletingExample.Cs_FillUpDb_53_64_366_927_Closed_Image" src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/ContractedSubBlock.gif" align="top" style="display: none;" onClick="this.style.display='none'; document.getElementById('ResourcesReferenceObject_LifecycleDelete_BehaviorListDeletingCS.ZipsListDeletingExample.Cs_ListDeletingExample.Cs_FillUpDb_53_64_366_927_Closed_Text').style.display='none'; document.getElementById('ResourcesReferenceObject_LifecycleDelete_BehaviorListDeletingCS.ZipsListDeletingExample.Cs_ListDeletingExample.Cs_FillUpDb_53_64_366_927_Open_Image').style.display='inline'; document.getElementById('ResourcesReferenceObject_LifecycleDelete_BehaviorListDeletingCS.ZipsListDeletingExample.Cs_ListDeletingExample.Cs_FillUpDb_53_64_366_927_Open_Text').style.display='inline';"/> </span><span id="ResourcesReferenceObject_LifecycleDelete_BehaviorListDeletingCS.ZipsListDeletingExample.Cs_ListDeletingExample.Cs_FillUpDb_53_64_366_927_Closed_Text" style="border: solid 1px #808080; background-color: #FFFFFF; display: none;">...</span><span id="ResourcesReferenceObject_LifecycleDelete_BehaviorListDeletingCS.ZipsListDeletingExample.Cs_ListDeletingExample.Cs_FillUpDb_53_64_366_927_Open_Text"><span style="color: #000000;">{ </span><span style="color: #008080;">13</span><span style="color: #000000;"><img src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/InBlock.gif" align="top"/> ListObject lo </span><span style="color: #000000;">=</span><span style="color: #000000;"> </span><span style="color: #0000FF;">new</span><span style="color: #000000;"> ListObject(); </span><span style="color: #008080;">14</span><span style="color: #000000;"><img src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/InBlock.gif" align="top"/> lo.Name </span><span style="color: #000000;">=</span><span style="color: #000000;"> </span><span style="color: #800000;">"</span><span style="color: #800000;">list</span><span style="color: #800000;">"</span><span style="color: #000000;"> </span><span style="color: #000000;">+</span><span style="color: #000000;"> i.ToString(</span><span style="color: #800000;">"</span><span style="color: #800000;">00</span><span style="color: #800000;">"</span><span style="color: #000000;">); </span><span style="color: #008080;">15</span><span style="color: #000000;"><img src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/InBlock.gif" align="top"/> </span><span style="color: #0000FF;">for</span><span style="color: #000000;"> (</span><span style="color: #0000FF;">int</span><span style="color: #000000;"> j </span><span style="color: #000000;">=</span><span style="color: #000000;"> </span><span style="color: #800080;">0</span><span style="color: #000000;">; j </span><span style="color: #000000;"><</span><span style="color: #000000;"> dataCount; j</span><span style="color: #000000;">++</span><span style="color: #000000;">) </span><span style="color: #008080;">16</span><span style="color: #000000;"><img id="ResourcesReferenceObject_LifecycleDelete_BehaviorListDeletingCS.ZipsListDeletingExample.Cs_ListDeletingExample.Cs_FillUpDb_53_64_555_877_Open_Image" src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/ExpandedSubBlockStart.gif" align="top" onClick="this.style.display='none'; document.getElementById('ResourcesReferenceObject_LifecycleDelete_BehaviorListDeletingCS.ZipsListDeletingExample.Cs_ListDeletingExample.Cs_FillUpDb_53_64_555_877_Open_Text').style.display='none'; document.getElementById('ResourcesReferenceObject_LifecycleDelete_BehaviorListDeletingCS.ZipsListDeletingExample.Cs_ListDeletingExample.Cs_FillUpDb_53_64_555_877_Closed_Image').style.display='inline'; document.getElementById('ResourcesReferenceObject_LifecycleDelete_BehaviorListDeletingCS.ZipsListDeletingExample.Cs_ListDeletingExample.Cs_FillUpDb_53_64_555_877_Closed_Text').style.display='inline';"/><img id="ResourcesReferenceObject_LifecycleDelete_BehaviorListDeletingCS.ZipsListDeletingExample.Cs_ListDeletingExample.Cs_FillUpDb_53_64_555_877_Closed_Image" src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/ContractedSubBlock.gif" align="top" style="display: none;" onClick="this.style.display='none'; document.getElementById('ResourcesReferenceObject_LifecycleDelete_BehaviorListDeletingCS.ZipsListDeletingExample.Cs_ListDeletingExample.Cs_FillUpDb_53_64_555_877_Closed_Text').style.display='none'; document.getElementById('ResourcesReferenceObject_LifecycleDelete_BehaviorListDeletingCS.ZipsListDeletingExample.Cs_ListDeletingExample.Cs_FillUpDb_53_64_555_877_Open_Image').style.display='inline'; document.getElementById('ResourcesReferenceObject_LifecycleDelete_BehaviorListDeletingCS.ZipsListDeletingExample.Cs_ListDeletingExample.Cs_FillUpDb_53_64_555_877_Open_Text').style.display='inline';"/> </span><span id="ResourcesReferenceObject_LifecycleDelete_BehaviorListDeletingCS.ZipsListDeletingExample.Cs_ListDeletingExample.Cs_FillUpDb_53_64_555_877_Closed_Text" style="border: solid 1px #808080; background-color: #FFFFFF; display: none;">...</span><span id="ResourcesReferenceObject_LifecycleDelete_BehaviorListDeletingCS.ZipsListDeletingExample.Cs_ListDeletingExample.Cs_FillUpDb_53_64_555_877_Open_Text"><span style="color: #000000;">{ </span><span style="color: #008080;">17</span><span style="color: #000000;"><img src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/InBlock.gif" align="top"/> DataObject dataObject </span><span style="color: #000000;">=</span><span style="color: #000000;"> </span><span style="color: #0000FF;">new</span><span style="color: #000000;"> DataObject(); </span><span style="color: #008080;">18</span><span style="color: #000000;"><img src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/InBlock.gif" align="top"/> dataObject.Name </span><span style="color: #000000;">=</span><span style="color: #000000;"> </span><span style="color: #800000;">"</span><span style="color: #800000;">data</span><span style="color: #800000;">"</span><span style="color: #000000;"> </span><span style="color: #000000;">+</span><span style="color: #000000;"> j.ToString(</span><span style="color: #800000;">"</span><span style="color: #800000;">00000</span><span style="color: #800000;">"</span><span style="color: #000000;">); </span><span style="color: #008080;">19</span><span style="color: #000000;"><img src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/InBlock.gif" align="top"/> dataObject.Data </span><span style="color: #000000;">=</span><span style="color: #000000;"> DateTime.Now.ToString() </span><span style="color: #000000;">+</span><span style="color: #000000;"> </span><span style="color: #800000;">"</span><span style="color: #800000;"> ---- Data Object </span><span style="color: #800000;">"</span><span style="color: #000000;"> </span><span style="color: #000000;">+</span><span style="color: #000000;"> j.ToString(</span><span style="color: #800000;">"</span><span style="color: #800000;">00000</span><span style="color: #800000;">"</span><span style="color: #000000;">); </span><span style="color: #008080;">20</span><span style="color: #000000;"><img src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/InBlock.gif" align="top"/> lo.Data.Add(dataObject); </span><span style="color: #008080;">21</span><span style="color: #000000;"><img src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/ExpandedSubBlockEnd.gif" align="top"/> }</span></span><span style="color: #000000;"> </span><span style="color: #008080;">22</span><span style="color: #000000;"><img src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/InBlock.gif" align="top"/> db.Set(lo); </span><span style="color: #008080;">23</span><span style="color: #000000;"><img src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/ExpandedSubBlockEnd.gif" align="top"/> }</span></span><span style="color: #000000;"> </span><span style="color: #008080;">24</span><span style="color: #000000;"><img src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/InBlock.gif" align="top"/> sw.Stop(); </span><span style="color: #008080;">25</span><span style="color: #000000;"><img src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/ExpandedSubBlockEnd.gif" align="top"/> }</span></span><span style="color: #000000;"> </span><span style="color: #008080;">26</span><span style="color: #000000;"><img src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/InBlock.gif" align="top"/> </span><span style="color: #0000FF;">finally</span><span style="color: #000000;"> </span><span style="color: #008080;">27</span><span style="color: #000000;"><img id="ResourcesReferenceObject_LifecycleDelete_BehaviorListDeletingCS.ZipsListDeletingExample.Cs_ListDeletingExample.Cs_FillUpDb_53_64_1001_1044_Open_Image" src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/ExpandedSubBlockStart.gif" align="top" onClick="this.style.display='none'; document.getElementById('ResourcesReferenceObject_LifecycleDelete_BehaviorListDeletingCS.ZipsListDeletingExample.Cs_ListDeletingExample.Cs_FillUpDb_53_64_1001_1044_Open_Text').style.display='none'; document.getElementById('ResourcesReferenceObject_LifecycleDelete_BehaviorListDeletingCS.ZipsListDeletingExample.Cs_ListDeletingExample.Cs_FillUpDb_53_64_1001_1044_Closed_Image').style.display='inline'; document.getElementById('ResourcesReferenceObject_LifecycleDelete_BehaviorListDeletingCS.ZipsListDeletingExample.Cs_ListDeletingExample.Cs_FillUpDb_53_64_1001_1044_Closed_Text').style.display='inline';"/><img id="ResourcesReferenceObject_LifecycleDelete_BehaviorListDeletingCS.ZipsListDeletingExample.Cs_ListDeletingExample.Cs_FillUpDb_53_64_1001_1044_Closed_Image" src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/ContractedSubBlock.gif" align="top" style="display: none;" onClick="this.style.display='none'; document.getElementById('ResourcesReferenceObject_LifecycleDelete_BehaviorListDeletingCS.ZipsListDeletingExample.Cs_ListDeletingExample.Cs_FillUpDb_53_64_1001_1044_Closed_Text').style.display='none'; document.getElementById('ResourcesReferenceObject_LifecycleDelete_BehaviorListDeletingCS.ZipsListDeletingExample.Cs_ListDeletingExample.Cs_FillUpDb_53_64_1001_1044_Open_Image').style.display='inline'; document.getElementById('ResourcesReferenceObject_LifecycleDelete_BehaviorListDeletingCS.ZipsListDeletingExample.Cs_ListDeletingExample.Cs_FillUpDb_53_64_1001_1044_Open_Text').style.display='inline';"/> </span><span id="ResourcesReferenceObject_LifecycleDelete_BehaviorListDeletingCS.ZipsListDeletingExample.Cs_ListDeletingExample.Cs_FillUpDb_53_64_1001_1044_Closed_Text" style="border: solid 1px #808080; background-color: #FFFFFF; display: none;">...</span><span id="ResourcesReferenceObject_LifecycleDelete_BehaviorListDeletingCS.ZipsListDeletingExample.Cs_ListDeletingExample.Cs_FillUpDb_53_64_1001_1044_Open_Text"><span style="color: #000000;">{ </span><span style="color: #008080;">28</span><span style="color: #000000;"><img src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/InBlock.gif" align="top"/> db.Close(); </span><span style="color: #008080;">29</span><span style="color: #000000;"><img src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/ExpandedSubBlockEnd.gif" align="top"/> }</span></span><span style="color: #000000;"> </span><span style="color: #008080;">30</span><span style="color: #000000;"><img src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/InBlock.gif" align="top"/> Console.WriteLine(</span><span style="color: #800000;">"</span><span style="color: #800000;">Completed {0} lists of {1} objects each.</span><span style="color: #800000;">"</span><span style="color: #000000;">, listCount, dataCount); </span><span style="color: #008080;">31</span><span style="color: #000000;"><img src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/InBlock.gif" align="top"/> Console.WriteLine(</span><span style="color: #800000;">"</span><span style="color: #800000;">Elapsed time: {0}</span><span style="color: #800000;">"</span><span style="color: #000000;">, sw.Elapsed.ToString()); </span><span style="color: #008080;">32</span><span style="color: #000000;"><img src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/ExpandedBlockEnd.gif" align="top"/> }</span></span></div></pre></div></div> </span> <p><span name="cs_wiki_filter" csw_filters="vb"></p> <div class="FormattedSourceCode"><div class="fscHeader"><span class="fscFileName">ListDeletingExample.vb: <span class="fscMemberName">FillUpDb</span></span></div><div class="fscCode"><pre ID="ResourcesReferenceObject_LifecycleDelete_BehaviorListDeletingVB.ZipsListDeletingExample.Vb_ListDeletingExample.Vb_FillUpDb_184_64"><div><!-- Code highlighting produced by Actipro CodeHighlighter (freeware) http://www.CodeHighlighter.com/ --><span style="color: #008080;">01</span><img id="ResourcesReferenceObject_LifecycleDelete_BehaviorListDeletingVB.ZipsListDeletingExample.Vb_ListDeletingExample.Vb_FillUpDb_184_64_15_1408_Open_Image" src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/ExpandedBlockStart.gif" align="top" onClick="this.style.display='none'; document.getElementById('ResourcesReferenceObject_LifecycleDelete_BehaviorListDeletingVB.ZipsListDeletingExample.Vb_ListDeletingExample.Vb_FillUpDb_184_64_15_1408_Open_Text').style.display='none'; document.getElementById('ResourcesReferenceObject_LifecycleDelete_BehaviorListDeletingVB.ZipsListDeletingExample.Vb_ListDeletingExample.Vb_FillUpDb_184_64_15_1408_Closed_Image').style.display='inline'; document.getElementById('ResourcesReferenceObject_LifecycleDelete_BehaviorListDeletingVB.ZipsListDeletingExample.Vb_ListDeletingExample.Vb_FillUpDb_184_64_15_1408_Closed_Text').style.display='inline';"/><img id="ResourcesReferenceObject_LifecycleDelete_BehaviorListDeletingVB.ZipsListDeletingExample.Vb_ListDeletingExample.Vb_FillUpDb_184_64_15_1408_Closed_Image" src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/ContractedBlock.gif" align="top" style="display: none;" onClick="this.style.display='none'; document.getElementById('ResourcesReferenceObject_LifecycleDelete_BehaviorListDeletingVB.ZipsListDeletingExample.Vb_ListDeletingExample.Vb_FillUpDb_184_64_15_1408_Closed_Text').style.display='none'; document.getElementById('ResourcesReferenceObject_LifecycleDelete_BehaviorListDeletingVB.ZipsListDeletingExample.Vb_ListDeletingExample.Vb_FillUpDb_184_64_15_1408_Open_Image').style.display='inline'; document.getElementById('ResourcesReferenceObject_LifecycleDelete_BehaviorListDeletingVB.ZipsListDeletingExample.Vb_ListDeletingExample.Vb_FillUpDb_184_64_15_1408_Open_Text').style.display='inline';"/><span style="color: #0000FF;">Private</span><span style="color: #000000;"> </span><span style="color: #0000FF;">Shared</span><span style="color: #000000;"> </span><span id="ResourcesReferenceObject_LifecycleDelete_BehaviorListDeletingVB.ZipsListDeletingExample.Vb_ListDeletingExample.Vb_FillUpDb_184_64_15_1408_Closed_Text" style="border: solid 1px #808080; background-color: #FFFFFF; display: none;">Sub FillUpDb()</span><span id="ResourcesReferenceObject_LifecycleDelete_BehaviorListDeletingVB.ZipsListDeletingExample.Vb_ListDeletingExample.Vb_FillUpDb_184_64_15_1408_Open_Text"><span style="color: #0000FF;">Sub</span><span style="color: #000000;"> FillUpDb(</span><span style="color: #0000FF;">ByVal</span><span style="color: #000000;"> listCount </span><span style="color: #0000FF;">As</span><span style="color: #000000;"> </span><span style="color: #0000FF;">Integer</span><span style="color: #000000;">) </span><span style="color: #008080;">02</span><span style="color: #000000;"><img src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/InBlock.gif" align="top"/> </span><span style="color: #0000FF;">Dim</span><span style="color: #000000;"> dataCount </span><span style="color: #0000FF;">As</span><span style="color: #000000;"> </span><span style="color: #0000FF;">Integer</span><span style="color: #000000;"> </span><span style="color: #000000;">=</span><span style="color: #000000;"> </span><span style="color: #800080;">50</span><span style="color: #000000;"> </span><span style="color: #008080;">03</span><span style="color: #000000;"><img src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/InBlock.gif" align="top"/> </span><span style="color: #0000FF;">Dim</span><span style="color: #000000;"> sw </span><span style="color: #0000FF;">As</span><span style="color: #000000;"> Stopwatch </span><span style="color: #000000;">=</span><span style="color: #000000;"> </span><span style="color: #0000FF;">New</span><span style="color: #000000;"> Stopwatch </span><span style="color: #008080;">04</span><span style="color: #000000;"><img src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/InBlock.gif" align="top"/> File.Delete(Db4oFileName) </span><span style="color: #008080;">05</span><span style="color: #000000;"><img src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/InBlock.gif" align="top"/> </span><span style="color: #0000FF;">Dim</span><span style="color: #000000;"> db </span><span style="color: #0000FF;">As</span><span style="color: #000000;"> IObjectContainer </span><span style="color: #000000;">=</span><span style="color: #000000;"> Db4oFactory.OpenFile(Db4oFileName) </span><span style="color: #008080;">06</span><span style="color: #000000;"><img src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/InBlock.gif" align="top"/> </span><span style="color: #0000FF;">Try</span><span style="color: #000000;"> </span><span style="color: #008080;">07</span><span style="color: #000000;"><img src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/InBlock.gif" align="top"/> sw.Start() </span><span style="color: #008080;">08</span><span style="color: #000000;"><img src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/InBlock.gif" align="top"/> </span><span style="color: #0000FF;">Dim</span><span style="color: #000000;"> i </span><span style="color: #0000FF;">As</span><span style="color: #000000;"> </span><span style="color: #0000FF;">Integer</span><span style="color: #000000;"> </span><span style="color: #000000;">=</span><span style="color: #000000;"> </span><span style="color: #800080;">0</span><span style="color: #000000;"> </span><span style="color: #008080;">09</span><span style="color: #000000;"><img src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/InBlock.gif" align="top"/> </span><span style="color: #0000FF;">While</span><span style="color: #000000;"> i </span><span style="color: #000000;"><</span><span style="color: #000000;"> listCount </span><span style="color: #008080;">10</span><span style="color: #000000;"><img src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/InBlock.gif" align="top"/> </span><span style="color: #0000FF;">Dim</span><span style="color: #000000;"> lo </span><span style="color: #0000FF;">As</span><span style="color: #000000;"> ListObject </span><span style="color: #000000;">=</span><span style="color: #000000;"> </span><span style="color: #0000FF;">New</span><span style="color: #000000;"> ListObject </span><span style="color: #008080;">11</span><span style="color: #000000;"><img src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/InBlock.gif" align="top"/> lo.Name </span><span style="color: #000000;">=</span><span style="color: #000000;"> </span><span style="color: #800000;">"</span><span style="color: #800000;">list</span><span style="color: #800000;">"</span><span style="color: #000000;"> </span><span style="color: #000000;">+</span><span style="color: #000000;"> i.ToString(</span><span style="color: #800000;">"</span><span style="color: #800000;">00</span><span style="color: #800000;">"</span><span style="color: #000000;">) </span><span style="color: #008080;">12</span><span style="color: #000000;"><img src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/InBlock.gif" align="top"/> </span><span style="color: #0000FF;">Dim</span><span style="color: #000000;"> j </span><span style="color: #0000FF;">As</span><span style="color: #000000;"> </span><span style="color: #0000FF;">Integer</span><span style="color: #000000;"> </span><span style="color: #000000;">=</span><span style="color: #000000;"> </span><span style="color: #800080;">0</span><span style="color: #000000;"> </span><span style="color: #008080;">13</span><span style="color: #000000;"><img src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/InBlock.gif" align="top"/> </span><span style="color: #0000FF;">While</span><span style="color: #000000;"> j </span><span style="color: #000000;"><</span><span style="color: #000000;"> dataCount </span><span style="color: #008080;">14</span><span style="color: #000000;"><img src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/InBlock.gif" align="top"/> </span><span style="color: #0000FF;">Dim</span><span style="color: #000000;"> dataObject </span><span style="color: #0000FF;">As</span><span style="color: #000000;"> DataObject </span><span style="color: #000000;">=</span><span style="color: #000000;"> </span><span style="color: #0000FF;">New</span><span style="color: #000000;"> DataObject </span><span style="color: #008080;">15</span><span style="color: #000000;"><img src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/InBlock.gif" align="top"/> dataObject.Name </span><span style="color: #000000;">=</span><span style="color: #000000;"> </span><span style="color: #800000;">"</span><span style="color: #800000;">data</span><span style="color: #800000;">"</span><span style="color: #000000;"> </span><span style="color: #000000;">+</span><span style="color: #000000;"> j.ToString(</span><span style="color: #800000;">"</span><span style="color: #800000;">00000</span><span style="color: #800000;">"</span><span style="color: #000000;">) </span><span style="color: #008080;">16</span><span style="color: #000000;"><img src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/InBlock.gif" align="top"/> dataObject.Data </span><span style="color: #000000;">=</span><span style="color: #000000;"> DateTime.Now.ToString </span><span style="color: #000000;">+</span><span style="color: #000000;"> </span><span style="color: #800000;">"</span><span style="color: #800000;"> ---- Data Object </span><span style="color: #800000;">"</span><span style="color: #000000;"> </span><span style="color: #000000;">+</span><span style="color: #000000;"> j.ToString(</span><span style="color: #800000;">"</span><span style="color: #800000;">00000</span><span style="color: #800000;">"</span><span style="color: #000000;">) </span><span style="color: #008080;">17</span><span style="color: #000000;"><img src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/InBlock.gif" align="top"/> lo.Data.Add(dataObject) </span><span style="color: #008080;">18</span><span style="color: #000000;"><img src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/InBlock.gif" align="top"/> System.Math.Min(System.Threading.Interlocked.Increment(j), j </span><span style="color: #000000;">-</span><span style="color: #000000;"> </span><span style="color: #800080;">1</span><span style="color: #000000;">) </span><span style="color: #008080;">19</span><span style="color: #000000;"><img src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/InBlock.gif" align="top"/> </span><span style="color: #0000FF;">End</span><span style="color: #000000;"> </span><span style="color: #0000FF;">While</span><span style="color: #000000;"> </span><span style="color: #008080;">20</span><span style="color: #000000;"><img src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/InBlock.gif" align="top"/> db.Set(lo) </span><span style="color: #008080;">21</span><span style="color: #000000;"><img src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/InBlock.gif" align="top"/> System.Math.Min(System.Threading.Interlocked.Increment(i), i </span><span style="color: #000000;">-</span><span style="color: #000000;"> </span><span style="color: #800080;">1</span><span style="color: #000000;">) </span><span style="color: #008080;">22</span><span style="color: #000000;"><img src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/InBlock.gif" align="top"/> </span><span style="color: #0000FF;">End</span><span style="color: #000000;"> </span><span style="color: #0000FF;">While</span><span style="color: #000000;"> </span><span style="color: #008080;">23</span><span style="color: #000000;"><img src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/InBlock.gif" align="top"/> sw.Stop() </span><span style="color: #008080;">24</span><span style="color: #000000;"><img src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/InBlock.gif" align="top"/> </span><span style="color: #0000FF;">Finally</span><span style="color: #000000;"> </span><span style="color: #008080;">25</span><span style="color: #000000;"><img src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/InBlock.gif" align="top"/> db.Close() </span><span style="color: #008080;">26</span><span style="color: #000000;"><img src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/InBlock.gif" align="top"/> </span><span style="color: #0000FF;">End</span><span style="color: #000000;"> </span><span style="color: #0000FF;">Try</span><span style="color: #000000;"> </span><span style="color: #008080;">27</span><span style="color: #000000;"><img src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/InBlock.gif" align="top"/> Console.WriteLine(</span><span style="color: #800000;">"</span><span style="color: #800000;">Completed {0} lists of {1} objects each.</span><span style="color: #800000;">"</span><span style="color: #000000;">, listCount, dataCount) </span><span style="color: #008080;">28</span><span style="color: #000000;"><img src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/InBlock.gif" align="top"/> Console.WriteLine(</span><span style="color: #800000;">"</span><span style="color: #800000;">Elapsed time: {0}</span><span style="color: #800000;">"</span><span style="color: #000000;">, sw.Elapsed.ToString) </span><span style="color: #008080;">29</span><span style="color: #000000;"><img src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/ExpandedBlockEnd.gif" align="top"/> </span><span style="color: #0000FF;">End Sub</span></span></div></pre></div></div> <p></span><br> </p></div> </div> <div id="footer"> This revision (2) was last Modified 2007-02-25T17:40:23 by Tetyana. </div> </body> </html>