public override void Connect_To_Database(StorageConfig config) { myConfig = config as SQLiteConfig; if (myConfig == null) { throw new Exception("Database Config is NULL"); } try { string connString = string.Format("Data Source={0};Pooling=true;FailIfMissing=false", myConfig.DatabaseFile); myDBConn = new FbConnection(connString); myDBConn.Open(); if (myDBConn.State != System.Data.ConnectionState.Open) { throw new Exception(); } } catch (FbException ex) { throw ex; } catch (Exception ex) { throw ex; } }
public override void Connect_To_Database(StorageConfig config) { myConfig = config as SQLiteConfig; if (myConfig == null) { throw new Exception("Database Config is NULL"); } if (!FileNameLockObjects.ContainsKey(myConfig.DatabaseFile)) { FileNameLockObjects.Add(myConfig.DatabaseFile, new object()); } try { myDBConn = new SQLiteConnection(ConnectionString); myDBConn.Open(); if (myDBConn.State != System.Data.ConnectionState.Open) { throw new Exception("Unable to Open Database. Storage:" + config.Name); } } catch (SQLiteException ex) { throw ex; } catch (Exception ex) { throw ex; } }
public void TestWithObject() { SQLiteConfig config = new SQLiteConfig(); config.dataSource = @"test.db"; bool isConnect = SQLiteLib.connect(config); Assert.AreEqual(true, isConnect); }
public static void SetConfig(SQLiteConfig config, params object[] args) { int n = UnsafeNativeMethods.sqlite3_config((int)config, args); if (n > 0) { throw new SqliteException(n, null); } }
public void TestWithJsonFile() { SQLiteConfig config = new SQLiteConfig(); config.dataSource = @"test.db"; SQLiteConfigJson.save(config, true); bool isConnect = SQLiteLib.connect(); Assert.AreEqual(true, isConnect); }
/// <summary> /// Constructor of MongoConnecter /// </summary> /// <param name="configuration">Contain all of config for connecter</param> private SQLiteConnecter(IConfigurationSection configuration) { Config = new SQLiteConfig(); configuration.Bind(Config); string currentPath = Environment.CurrentDirectory; string projectDirectory = Directory.GetParent(currentPath).FullName; string connectString = string.Format("Data Source={0}; Version = 3;", projectDirectory + Config.Connect); connection = new SQLiteConnection(); connection.ConnectionString = connectString; }
private void cmdAddSQLiteStorage_Click(object sender, RoutedEventArgs e) { string val = "Storage_" + (grdStorages.Items.Count + 1); if (DotNetSiemensPLCToolBoxLibrary.General.InputBox.Show("Storage-Name", "Name of the Storage", ref val) == DialogResult.OK) { foreach (var tmp in ProtokollerConfiguration.ActualConfigInstance.Storages) { if (tmp.Name.ToLower().Trim() == val.ToLower().Trim()) { MessageBox.Show("A Storage with this Name already Exists!", "Error", MessageBoxButton.OK, MessageBoxImage.Error); return; } } SQLiteConfig storage = new SQLiteConfig() { Name = val }; ProtokollerConfiguration.ActualConfigInstance.Storages.Add(storage); } }
// http://www.sqlite.org/c3ref/config.html public static void SetConfig (SQLiteConfig config) { int n = UnsafeNativeMethods.sqlite3_config (config); if (n > 0) throw new SqliteException (n, null); }
internal static extern int sqlite3_config (SQLiteConfig config);
internal static extern int sqlite3_config(SQLiteConfig config);
public static void SetConfig(SQLiteConfig config, params object[] args) { int n = UnsafeNativeMethods.sqlite3_config((int)config, args); if (n > 0) throw new SqliteException(n, null); }