C# (CSharp) System.Data.SqlServerCe.SqlCeEngine.Dispose Examples

Example #1

File: Program.cs Project: ukrbublik/BridgeNote

 public static bool CreateDatabase(string path)
 {
     System.Data.SqlServerCe.SqlCeEngine dbEngine = new System.Data.SqlServerCe.SqlCeEngine("Data Source='" + path + "'");
     try
     {
         dbEngine.CreateDatabase();
         return true;
     }
     catch (System.Data.SqlServerCe.SqlCeException e)
     {
         // error #25114 - База уже есть
         MessageBox.Show(e.Message, "db error #" + e.NativeError, MessageBoxButtons.OK, MessageBoxIcon.Exclamation, MessageBoxDefaultButton.Button1);
         return false;
     }
     finally
     {
         dbEngine.Dispose();
     }
 }

Example #2

 static public bool CreateDatabase(string path)
 {
     System.Data.SqlServerCe.SqlCeEngine dbEngine = new System.Data.SqlServerCe.SqlCeEngine("Data Source='" + path + "'");
     try
     {
         dbEngine.CreateDatabase();
         return(true);
     }
     catch (System.Data.SqlServerCe.SqlCeException e)
     {
         // error #25114 - База уже есть
         MessageBox.Show(e.Message, "db error #" + e.NativeError, MessageBoxButtons.OK, MessageBoxIcon.Exclamation, MessageBoxDefaultButton.Button1);
         return(false);
     }
     finally
     {
         dbEngine.Dispose();
     }
 }