} // End Constructor 0 public cSQLite(string strConnectionString) { CopySQLite(); this.m_dbtDBtype = DataBaseEngine_t.SQLite; this.m_providerFactory = this.GetFactory(); this.m_dictScriptTemplates = GetSQLtemplates(); //this.m_dblDBversion = 8.0; this.m_ConnectionString = new SQLiteConnectionStringBuilder(strConnectionString); } // End Constructor 1
} // End Sub CopySQLite public override string GetConnectionString(string strDb) { if (string.IsNullOrEmpty(strDb)) { return(this.m_ConnectionString.ConnectionString); } SQLiteConnectionStringBuilder csb = new SQLiteConnectionStringBuilder(this.m_ConnectionString.ConnectionString); csb.DataSource = strDb; string strRetVal = csb.ConnectionString; // csb.Clear (); csb = null; return(strRetVal); } // End Function GetConnectionString
/// <summary> /// Initializes a new instance of the <see cref="InMemorySQLiteDatabase"/> class. /// </summary> public InMemorySQLiteDatabase() { var connectionStringBuilder = new SQLiteConnectionStringBuilder { DataSource = ":memory:", Version = 3, DefaultTimeout = 5, #if MONO JournalMode = SQLiteJournalModeEnum.Off, #else JournalMode = SQLiteJournalModeEnum.Memory, #endif UseUTF16Encoding = true }; ConnectionString = connectionStringBuilder.ToString(); connectionManager = new SQLiteConnectionManager(connectionStringBuilder.ConnectionString); sharedConnection = new SQLiteConnection(connectionStringBuilder.ConnectionString); sharedConnection.Open(); sqlRunner = new AdHocSqlRunner(() => sharedConnection.CreateCommand(), null, () => true); }
/// <summary> /// Initializes a new instance of the <see cref="TemporarySQLiteDatabase"/> class. /// </summary> /// <param name="name">The name.</param> public TemporarySQLiteDatabase(string name) { dataSourcePath = Path.Combine(Environment.CurrentDirectory, name); var connectionStringBuilder = new SQLiteConnectionStringBuilder { DataSource = name, Version = 3, DefaultTimeout = 5, #if MONO JournalMode = SQLiteJournalModeEnum.Off, #else JournalMode = SQLiteJournalModeEnum.Memory, #endif UseUTF16Encoding = true }; sqLiteConnection = new SQLiteConnection(connectionStringBuilder.ConnectionString); sqLiteConnection.Open(); sharedConnection = new SharedConnection(sqLiteConnection); sqlRunner = new AdHocSqlRunner(() => sqLiteConnection.CreateCommand(), null, () => true); }
public static void Setup(bool useLocalFiles) { DataDirectory = new DirectoryInfo(Path.Combine(Environment.GetFolderPath(Environment.SpecialFolder.ApplicationData), "Gablarski")); if (!DataDirectory.Exists) { DataDirectory.Create(); } if (useLocalFiles) { KeyFile = new FileInfo("gablarski.key"); DbFile = new FileInfo("gablarski.db"); } else { KeyFile = new FileInfo(Path.Combine(DataDirectory.FullName, "gablarski.key")); DbFile = new FileInfo(Path.Combine(DataDirectory.FullName, "gablarski.db")); } #if !XAMARIN var builder = new SQLiteConnectionStringBuilder(); builder.DataSource = DbFile.FullName; db = new SQLiteConnection(builder.ToString()); #else KeyFile = new FileInfo(Path.Combine(Environment.GetFolderPath(Environment.SpecialFolder.Personal), KeyFile.Name)); DbFile = new FileInfo(Path.Combine(Environment.GetFolderPath(Environment.SpecialFolder.Personal), DbFile.Name)); if (!DbFile.Exists) { SQLiteConnection.CreateFile(DbFile.FullName); } db = new SQLiteConnection("Data Source=" + DbFile.FullName); #endif db.Open(); CreateDbs(); }
public new static void Tests() { System.Data.Common.DbConnectionStringBuilder dbcsb = new System.Data.Common.DbConnectionStringBuilder(); System.Data.SqlClient.SqlConnectionStringBuilder sqlcsb = new System.Data.SqlClient.SqlConnectionStringBuilder(); sqlcsb.NetworkLibrary = ""; //sqlcsb.TransactionBinding sqlcsb.TypeSystemVersion = ""; sqlcsb.UserInstance = true; Npgsql.NpgsqlConnectionStringBuilder csb = new Npgsql.NpgsqlConnectionStringBuilder(); // csb.Protocol // csb.Compatible //csb.SslMode = Npgsql.SslMode.Require; // csb.UseExtendedTypes System.Data.OracleClient.OracleConnectionStringBuilder ocb = new System.Data.OracleClient.OracleConnectionStringBuilder(); FirebirdSql.Data.FirebirdClient.FbConnectionStringBuilder fbcsb = new FirebirdSql.Data.FirebirdClient.FbConnectionStringBuilder(); fbcsb.ServerType = FirebirdSql.Data.FirebirdClient.FbServerType.Embedded; Mono.Data.Sqlite.SqliteConnectionStringBuilder litecsb = new Mono.Data.Sqlite.SqliteConnectionStringBuilder(); litecsb.BinaryGUID = true; litecsb.DateTimeFormat = Mono.Data.Sqlite.SQLiteDateFormats.ISO8601; litecsb.DefaultIsolationLevel = System.Data.IsolationLevel.ReadCommitted; litecsb.DefaultTimeout = 123; litecsb.FailIfMissing = true; litecsb.JournalMode = Mono.Data.Sqlite.SQLiteJournalModeEnum.Off; litecsb.LegacyFormat = false; litecsb.SyncMode = Mono.Data.Sqlite.SynchronizationModes.Full; litecsb.Uri = ""; litecsb.Version = 123; MySql.Data.MySqlClient.MySqlConnectionStringBuilder mycb = new MySql.Data.MySqlClient.MySqlConnectionStringBuilder(); mycb.AllowBatch = true; mycb.CertificateFile = ""; mycb.CertificatePassword = ""; mycb.CertificateStoreLocation = MySql.Data.MySqlClient.MySqlCertificateStoreLocation.LocalMachine; mycb.CertificateThumbprint = ""; mycb.CharacterSet = ""; mycb.CheckParameters = true; mycb.ConnectionLifeTime = 123; mycb.ConnectionProtocol = MySql.Data.MySqlClient.MySqlConnectionProtocol.Tcp; mycb.ConnectionReset = true; mycb.ConvertZeroDateTime = false; mycb.DefaultCommandTimeout = 123; mycb.FunctionsReturnString = true; mycb.IgnorePrepare = true; mycb.InteractiveSession = false; mycb.Keepalive = 123; mycb.PipeName = ""; System.Data.Odbc.OdbcConnectionStringBuilder odbc = new System.Data.Odbc.OdbcConnectionStringBuilder(); //System.Data.OleDb.OleDbConnectionStringBuilder oledb = new System.Data.OleDb.OleDbConnectionStringBuilder(); } // End Sub
public void Open(string absoluteFilePath) { try { ConnectionStringBuilder connstr = new ConnectionStringBuilder(); connstr.DataSource = absoluteFilePath; conn = new Connection(); conn.ConnectionString = connstr.ToString(); conn.Open(); cmdCommand = new Command( "SELECT [Command] FROM [Command] WHERE [Name]=:name AND [Class]=:class", conn); cmdCommand.Parameters.Add(":name", DbType.Binary); cmdCommand.Parameters.Add(":class", DbType.Binary); textCommand = new Command( "SELECT [Content] FROM [Text] WHERE [Name]=:name AND [Language]=:language AND [Class]=:class", conn); textCommand.Parameters.Add(":name", DbType.Binary); textCommand.Parameters.Add(":language", DbType.Binary); textCommand.Parameters.Add(":class", DbType.Binary); troubleCodeCommand = new Command( "SELECT [Content], [Description] FROM [TroubleCode] WHERE [Code]=:code AND [Language]=:language AND [Class]=:class", conn); troubleCodeCommand.Parameters.Add(":code", DbType.Binary); troubleCodeCommand.Parameters.Add(":language", DbType.Binary); troubleCodeCommand.Parameters.Add(":class", DbType.Binary); liveDataCommand = new Command( "SELECT [ShortName], [Content], [Unit], [DefaultValue], [CommandName], [CommandClass], [Description], [Index] FROM [LiveData] WHERE [Language]=:language AND [Class]=:class", conn); liveDataCommand.Parameters.Add(":language", DbType.Binary); liveDataCommand.Parameters.Add(":class", DbType.Binary); } catch (Exception ex) { Close(); throw new DatabaseException( String.Format("Cannot open vehicle database! file path = \"{0}\", error message: {1}", absoluteFilePath, ex.Message)); } }