public void DatabaseTriggersTest() { FbConnectionStringBuilder csb = BuildConnectionStringBuilder(FbServerType, Compression); csb.Pooling = false; int rows; csb.NoDatabaseTriggers = false; using (var conn = new FbConnection(csb.ToString())) { conn.Open(); rows = LogRowsCount(conn); TestContext.WriteLine(rows); } csb.NoDatabaseTriggers = true; using (var conn = new FbConnection(csb.ToString())) { conn.Open(); Assert.AreEqual(rows, LogRowsCount(conn)); } csb.NoDatabaseTriggers = false; using (var conn = new FbConnection(csb.ToString())) { conn.Open(); Assert.AreEqual(rows + 1, LogRowsCount(conn)); } }
public connectToDBFirebird() { FbCommand cmd = null; FbConnectionStringBuilder fbConnectBild = new FbConnectionStringBuilder(); //fbConnectBild.DataSource = IDataSource; //local //fbConnectBild.Port = int.Parse(Port); //"3050"; //fbConnectBild.Database = Database; //"kharkov"; //fbConnectBild.UserID = FBUser; //"rpt"; //fbConnectBild.Password = FBPass; //"rpt"; //fbConnectBild.Charset = Charset; //"NONE"; //fbConnectBild.IsolationLevel = IsolationLevel.ReadCommitted; fbConnectBild.Pooling = false; FbConnection fbConnect = new FbConnection(fbConnectBild.ToString()); FbTransaction fbTransact; Loger.SetLog("440 " + fbConnectBild.ToString()); try { fbConnect.Open(); FbTransactionOptions option = new FbTransactionOptions(); option.TransactionBehavior = FbTransactionBehavior.NoWait | FbTransactionBehavior.ReadCommitted | FbTransactionBehavior.RecVersion; fbTransact = fbConnect.BeginTransaction(option); } catch (FbException err) { Loger.SetLog("449 " + err.Message); //MessageBox.Show("Неудачное подключение,проверьте параметр в файле настроек \r\n" + err.Message); //Clipboard.SetText("Неудачное подключение \r\n" + err.Message + "\r\nСтрока подключения : " + fbConnectBild.ToString()); return; } //string query = String.Format(@"update outcomeinvoice set printflag = 1 where id = {0}", DocId); //Loger.SetLog("456 " + query); try { //cmd = new FbCommand(query, fbConnect, fbTransact); Loger.SetLog("461 cmd = new FbCommand(query, fbConnect, fbTransact);"); cmd.ExecuteNonQuery(); Loger.SetLog("463 cmd.ExecuteNonQuery();"); cmd.Dispose(); Loger.SetLog("465 cmd.Dispose();"); fbTransact.CommitRetaining(); Loger.SetLog("467 fbTransact.CommitRetaining();"); fbConnect.Close(); Loger.SetLog("469 fbConnect.Close();"); } catch (FbException err) { //string message = String.Format("Не удалось установить признак печати чека \r\nЗапрос : {0} \r\nОшибка : {1}", query, err.Message); //MessageBox.Show(message); //Clipboard.SetText(message); cmd.Dispose(); fbConnect.Close(); return; } }
public DeliveryReports(User user) { InitializeComponent(); var config = ConfigurationManager.OpenExeConfiguration(ConfigurationUserLevel.None); var connectionStringsSection = (ConnectionStringsSection)config.GetSection("connectionStrings"); string appPath = Application.StartupPath; string dbPath = appPath + "\\db\\MUS_DB.FDB"; FbConnectionStringBuilder cs = new FbConnectionStringBuilder(); cs.DataSource = "localhost"; cs.Database = dbPath; cs.UserID = user.Login; cs.Password = user.Password; cs.Charset = "WIN1251"; cs.Pooling = false; cs.Role = user.Role; var cn = new FbConnection(cs.ToString()); var cmd = new FbCommand(); cmd.CommandType = CommandType.Text; cmd.CommandText = @"select m_delivery.""DATE"" as del_date, m_delivery.provider as prov_name, m_delivery.""COUNT"" as inst_count, m_delivery.release_date as rel_date, m_instrument.name as inst_name, m_instrument.price as inst_price, m_manufacturer.name as man_name, m_mark.name as mark_name from m_manufacturer inner join m_mark on (m_manufacturer.id = m_mark.man_id) inner join m_instrument on (m_mark.id = m_instrument.mark_id) inner join m_delivery on (m_instrument.id = m_delivery.instrument_id)"; cmd.Connection = cn; DataTable dt = GetTable(cmd); String file = File.ReadAllText("reports\\delivery_report.rdl"); File.WriteAllText("reports\\delivery_report_tmp.rdl", file); string filepath = System.IO.Path.Combine(System.IO.Directory.GetCurrentDirectory(), "reports\\delivery_report_tmp.rdl"); Uri url = new Uri(filepath); this.rdlViewer1.SourceFile = url; this.rdlViewer1.Report.DataSets["Data"].SetData(dt); this.rdlViewer1.Report.DataSets["Data"].SetSource(cmd.CommandText); this.rdlViewer1.Parameters += string.Format("ConnectionString={0}", cs.ToString()); this.rdlViewer1.Rebuild(); }
protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder) { var connectionBuilder = new FbConnectionStringBuilder("database=localhost:EFCore.fdb;user=sysdba;password=masterkey"); FbConnection.ClearPool(new FbConnection(connectionBuilder.ToString())); connectionBuilder.Pooling = true; connectionBuilder.MaxPoolSize = 200; optionsBuilder.UseFirebird(connectionBuilder.ToString()); }
public plgFBConnect() { LastSQL = String.Empty; //-- инициализация необходимых переменных csb = new FbConnectionStringBuilder(); //-- настройка соединения с сервером и БД //csb.Host = DM.Host; //-- Хост, на котором развернута БД csb.Database = DM.Database; //-- база данных csb.UserID = DM.User; //-- пользователь csb.IsolationLevel = IsolationLevel.ReadCommitted; csb.Port = DM.Port; csb.Dialect = 3; csb.ConnectionTimeout = DM.Timeout; //-- время задается в секундах, по умолчанию - 20 секунд, а потом генерируется ошибка csb.Password = DM.Password; //-- тип сервера (Embedded - переносной (portable) csb.ServerType = FbServerType.Embedded; //-- csb.ServerType = FbServerType.Default; //-- инициализация строки подключения к базе данных ConnectString = csb.ToString(); try { db = new FbConnection(ConnectString); } catch (Exception ex) { ServiceWins.ShowError(ex); Dispose(); } }
public void CryptKeyValueSetter() { var b = new FbConnectionStringBuilder(); b.CryptKey = Encoding.ASCII.GetBytes("test"); Assert.AreEqual("crypt key=\"dGVzdA==\"", b.ToString()); }
public void ConnectionPoolingMinPoolSizeTest() { FbConnectionStringBuilder csb = BuildConnectionStringBuilder(FbServerType, Compression); csb.Pooling = true; csb.ConnectionLifeTime = 5; csb.MinPoolSize = 3; string cs = csb.ToString(); int active = GetActiveConnections(); var connections = new List <FbConnection>(); try { for (int i = 0; i < csb.MinPoolSize * 2; i++) { var connection = new FbConnection(cs); connections.Add(connection); Assert.DoesNotThrow(() => connection.Open()); } } finally { connections.ForEach(x => x.Dispose()); } Thread.Sleep(TimeSpan.FromSeconds(csb.ConnectionLifeTime * 2)); Assert.AreEqual(active + csb.MinPoolSize, GetActiveConnections()); }
public static string GetConnFBstring() { FbConnectionStringBuilder csb = new FbConnectionStringBuilder(); // Указываем тип используемого сервера csb.ServerType = FbServerType.Embedded; // Путь до файла с базой данных csb.Database = @"D:\users\baa\DB\mac201301010\BUD152.FDB"; // Настройка параметров "общения" клиента с сервером csb.Charset = "WIN1251"; csb.Dialect = 3; // Путь до библиотеки-сервера Firebird // Если библиотека находится в тойже папке // что и exe фаил - указывать путь не надо csb.ClientLibrary = @"C:\Program Files\Firebird\Firebird_2_5\bin\gds32.dll"; // Настройки аутентификации csb.UserID = "SYSDBA"; csb.Password = "******"; return(csb.ToString()); }
/// <summary> /// Build a connection string /// </summary> /// <param name="dbpath"></param> /// <param name="source"></param> /// <param name="user"></param> /// <param name="pass"></param> /// <returns></returns> protected string GetConnectionString(string dbpath, string source, string user, string pass) { FbConnectionStringBuilder cs = new FbConnectionStringBuilder(); // If Not fbDBServerType = FbServerType.Embedded Then //cs.DataSource = source; cs.Password = pass; cs.UserID = user; //cs.Port = 3050; // End If cs.Pooling = true; cs.Database = dbpath; cs.Charset = "UTF8"; cs.ConnectionLifeTime = 30; cs.ServerType = fbDBServerType; cs.ClientLibrary = "fbclient.dll"; fbDBDataSet.Locale = CultureInfo.InvariantCulture; string connstr = cs.ToString(); if (cs != null) { cs = null; } return(connstr); }
public void SimpleSelectTest() { FbConnectionStringBuilder csb = BuildConnectionStringBuilder(this.FbServerType); csb.Enlist = true; using (TransactionScope scope = new TransactionScope()) { using (FbConnection c = new FbConnection(csb.ToString())) { c.Open(); using (FbCommand command = new FbCommand("select * from TEST where (0=1)", c)) { using (FbDataReader r = command.ExecuteReader()) { while (r.Read()) { } } } } scope.Complete(); } }
private void button1_Click(object sender, EventArgs e) { FbConnectionStringBuilder cs = new FbConnectionStringBuilder(); FbConnection fbConn = new FbConnection(); cs.DataSource = "localhost"; // имя компьютера, на котором находится база данных cs.UserID = "SYSDBA"; // имя пользователя, который может производить манипуляции с базой cs.Password = "******"; // паоль пользователя, который может производить манипуляции с базой cs.Database = "E:\\WindowsFormsApp1\\WindowsFormsApp1\\bd\\DRIVED.fdb"; // путь к файлу базы данных // cs.Port = 3050; // порт подключения к базе cs.Charset = "win1251"; // кодировка символов string ConnString = cs.ToString(); fbConn.ConnectionString = ConnString; fbConn.Open(); DataTable dt = new DataTable(); FbDataAdapter da = new FbDataAdapter(); FbCommand cmd = new FbCommand("select Name,Surname,LastName,pasport_num,pasport_serial_num,place_num,price from new_table where Flight_id ='" + textBox1.Text + "';", fbConn); cmd.CommandType = CommandType.Text; FbDataReader dr = cmd.ExecuteReader(); dt.Load(dr); dataGridView2.DataSource = dt; fbConn.Close(); }
public void ConnectionPoolingMinPoolSizeTest() { FbConnectionStringBuilder csb = BuildConnectionStringBuilder(); csb.Pooling = true; csb.ConnectionLifeTime = 5; csb.MinPoolSize = 3; string cs = csb.ToString(); int active = ActiveConnections(); var connections = new List <FbConnection>(); try { for (int i = 0; i < csb.MinPoolSize * 2; i++) { var connection = new FbConnection(cs); Assert.DoesNotThrow(() => connection.Open()); connections.Add(connection); } } finally { connections.ForEach(x => x.Dispose()); } System.Threading.Thread.Sleep(csb.ConnectionLifeTime * 2 * 1000); Assert.AreEqual(active + csb.MinPoolSize, ActiveConnections()); FbConnection.ClearAllPools(); }
public void ConnectionPoolingTest() { // Using ActiveUsers as proxy for number of connections FbConnectionStringBuilder csb = BuildConnectionStringBuilder(); csb.Pooling = true; csb.ConnectionLifeTime = 5; string cs = csb.ToString(); FbConnection myConnection1 = new FbConnection(cs); FbConnection myConnection2 = new FbConnection(cs); int active = ActiveConnections(); // Open two connections. Console.WriteLine("Open two connections."); myConnection1.Open(); myConnection2.Open(); // Now there are two connections in the pool that matches the connection string. // Return the both connections to the pool. Console.WriteLine("Return both of the connections to the pool."); myConnection1.Close(); myConnection2.Close(); Assert.AreEqual(active + 2, ActiveConnections()); // Clear pools FbConnection.ClearAllPools(); }
private void cb_choose_war_EditValueChanged(object sender, EditValueChangedEventArgs e) { FbConnectionStringBuilder fb_con = new FbConnectionStringBuilder(); fb_con.Charset = "UTF8"; fb_con.UserID = "SYSDBA"; fb_con.Password = "******"; fb_con.Database = "C:\\Users\\ARTEM\\Documents\\Visual Studio 2013\\Projects\\GreatestApplicatioInMyLife\\DB\\MAINDB.fdb"; fb_con.ServerType = 0; fb = new FbConnection(fb_con.ToString()); fb.Open(); cb_choose_user.Clear(); cb_choose_user.Items.Clear(); FbCommand sqlforcomb = new FbCommand("select NAME_RES from GET_RES_FOR_AUT WHERE NAME_WAR ='" + cb_choose_war.Text + "'", fb); FbDataReader readercomb = sqlforcomb.ExecuteReader(); if (readercomb.HasRows) // если есть данные { DataSet newset1 = new DataSet("newset1"); DataTable dtcomb = new DataTable(); while (readercomb.Read()) { try { string resultvalue = readercomb.GetString(0); cb_choose_user.Items.Add(resultvalue); } catch { } } } }
public void WireCryptSetter() { var b = new FbConnectionStringBuilder(); b.WireCrypt = FbWireCrypt.Disabled; Assert.AreEqual("wire crypt=Disabled", b.ToString()); }
public FirebirdClient(string ipAddress, string baseName, string user, string pass, bool isGui = false) { Logging.ToLog("FirebirdClient - Создание подключения к базе: " + ipAddress + ":" + baseName); FbConnectionStringBuilder cs = new FbConnectionStringBuilder(); try { cs.DataSource = ipAddress; cs.Database = baseName; cs.UserID = user; cs.Password = pass; cs.Charset = "NONE"; cs.Pooling = false; connection = new FbConnection(cs.ToString()); } catch (Exception e) { Logging.ToLog("FirebirdClient - " + e.Message + Environment.NewLine + e.StackTrace); if (isGui) { throw; } } }
public FirebirdDatabase() { DbType = DatabaseType.Firebird; ProviderName = DatabaseType.Firebird.GetProviderName(); DBFileName = DBName + ".fdb"; FQDBFile = Path.Combine(DBPath, DBFileName); // ConnectionString Builder FbConnectionStringBuilder csb = new FbConnectionStringBuilder(); csb.Database = FQDBFile; csb.DataSource = "localhost"; csb.Dialect = 3; csb.Charset = "UTF8"; csb.Pooling = false; csb.Role = FbRole; csb.UserID = FbUserName; csb.Password = FbUserPass; ConnectionString = csb.ToString(); RecreateDataBase(); EnsureSharedConnectionConfigured(); }
public void ConnectionPoolingTimeOutTest() { // Using ActiveUsers as proxy for number of connections FbConnectionStringBuilder csb = BuildConnectionStringBuilder(); csb.Pooling = true; csb.ConnectionLifeTime = 5; string cs = csb.ToString(); int active = ActiveConnections(); using (FbConnection myConnection1 = new FbConnection(cs), myConnection2 = new FbConnection(cs)) { myConnection1.Open(); myConnection2.Open(); Assert.AreEqual(active + 2, ActiveConnections()); myConnection1.Close(); myConnection2.Close(); } System.Threading.Thread.Sleep(csb.ConnectionLifeTime * 2 * 1000); Assert.AreEqual(active, ActiveConnections()); FbConnection.ClearAllPools(); }
public FireBird(string Ps_Path) { try { FbConnectionStringBuilder fb = new FbConnectionStringBuilder(); //네트워크 접속 //fb.ConnectionString = @"Server=192.100.0.4;" //+ @"Database=" + Ps_Path + ";" //+ "User=SYSDBA;Password=masterkey;"; fb.UserID = "SYSDBA"; fb.Password = "******"; fb.Database = Ps_Path; fb.ServerType = FbServerType.Default; Conn = new FbConnection(fb.ToString()); Conn.Open(); } catch (FbException) { throw; } }
public Form1() { InitializeComponent(); FbConnectionStringBuilder cs = new FbConnectionStringBuilder(); FbConnection fbConn = new FbConnection(); cs.DataSource = "localhost"; // имя компьютера, на котором находится база данных cs.UserID = "SYSDBA"; // имя пользователя, который может производить манипуляции с базой cs.Password = "******"; // паоль пользователя, который может производить манипуляции с базой cs.Database = "E:\\WindowsFormsApp1\\WindowsFormsApp1\\bd\\DRIVED.fdb"; // путь к файлу базы данных // cs.Port = 3050; // порт подключения к базе cs.Charset = "win1251"; // кодировка символов string ConnString = cs.ToString(); fbConn.ConnectionString = ConnString; fbConn.Open(); DataTable dt = new DataTable(); FbDataAdapter da = new FbDataAdapter(); FbCommand cmd = new FbCommand("select * from new_table", fbConn); cmd.CommandType = CommandType.Text; FbDataReader dr = cmd.ExecuteReader(); dt.Load(dr); dataGridView1.DataSource = dt; fbConn.Close(); }
// This method gets called by the runtime. Use this method to add services to the container. public void ConfigureServices(IServiceCollection services) { var binDirectory = AppDomain.CurrentDomain.GetData("BinDirectory").ToString(); var dataDirectory = AppDomain.CurrentDomain.GetData("DataDirectory").ToString(); var fbserverDirectory = "fbs-x64"; #if x86 fbserverDirectory = "fbs-x86"; #endif var connection = new FbConnectionStringBuilder(Configuration.GetConnectionString("DefaultConnection")); connection.ClientLibrary = Path.Combine(Path.Combine(binDirectory, fbserverDirectory), Path.GetFileName(connection.ClientLibrary)); connection.Database = Path.Combine(dataDirectory, Path.GetFileName(connection.Database)); var connectionstring = connection.ToString(); if (!File.Exists(connection.Database)) { FbConnection.CreateDatabase(connectionstring, pageSize: 4096 * 4); } services.AddDbContext <ApplicationDbContext>(options => { options.UseFirebird(connectionstring); }); services.AddDatabaseDeveloperPageExceptionFilter(); services.AddDefaultIdentity <IdentityUser>(options => options.SignIn.RequireConfirmedAccount = true) .AddEntityFrameworkStores <ApplicationDbContext>(); services.AddControllersWithViews(); }
/// <inheritdoc/> protected override string BuildConnectionString(UrlInfo connectionUrl) { SqlHelper.ValidateConnectionUrl(connectionUrl); ArgumentValidator.EnsureArgumentNotNullOrEmpty(connectionUrl.Resource, "connectionUrl.Resource"); ArgumentValidator.EnsureArgumentNotNullOrEmpty(connectionUrl.Host, "connectionUrl.Host"); var builder = new FbConnectionStringBuilder(); // host, port, database if (!string.IsNullOrEmpty(connectionUrl.Host)) { var port = connectionUrl.Port != 0 ? connectionUrl.Port : DefaultPort; builder.Database = connectionUrl.Resource; builder.DataSource = connectionUrl.Host; builder.Dialect = 3; builder.Pooling = false; builder.Port = port; builder.ReturnRecordsAffected = true; } // user, password if (!string.IsNullOrEmpty(connectionUrl.User)) { builder.UserID = connectionUrl.User; builder.Password = connectionUrl.Password; } // custom options foreach (var parameter in connectionUrl.Params) { builder.Add(parameter.Key, parameter.Value); } return(builder.ToString()); }
private void StartBtn_Click(object sender, RoutedEventArgs e) { connString = new FbConnectionStringBuilder(); connString.Database = pathBox.Text; connString.DataSource = "localhost"; connString.UserID = usernameBox.Text; connString.Password = passwordBox.Password; connection = new FbConnection(connString.ToString()); connection.Open(); if (connection.State.ToString() == "Open") { outputBox.Text = "Successfully opened database"; } else { outputBox.Text = "Something went wrong... " + connection.State.ToString(); } consoleGrid.Visibility = Visibility.Visible; databaseGrid.Visibility = Visibility.Collapsed; customerGrid.Visibility = Visibility.Collapsed; deviceGrid.Visibility = Visibility.Collapsed; deviceKindGrid.Visibility = Visibility.Collapsed; deviceTypeGrid.Visibility = Visibility.Collapsed; mainToolbar.IsEnabled = true; }
public void InsertTest() { FbConnectionStringBuilder csb = BuildConnectionStringBuilder(this.FbServerType); csb.Enlist = true; using (TransactionScope scope = new TransactionScope()) { using (FbConnection c = new FbConnection(csb.ToString())) { c.Open(); string sql = "insert into TEST (int_field, date_field) values (1002, @date)"; using (FbCommand command = new FbCommand(sql, c)) { command.Parameters.Add("@date", FbDbType.Date).Value = DateTime.Now.ToString(); int ra = command.ExecuteNonQuery(); Assert.AreEqual(ra, 1); } } scope.Complete(); } }
private void Restore() { var DB = txtPath.Text; if (DB.EndsWith(".gbk")) { var conexao = new FbConnectionStringBuilder(); conexao.DataSource = "localhost"; conexao.Database = DB; conexao.UserID = "SYSDBA"; conexao.Password = "******"; var restore = new FbRestore(); restore.ConnectionString = conexao.ToString(); var fileInfo = new FileInfo(DB); pathDest = $"{fileInfo.DirectoryName}\\{DB.Substring(0, DB.Length - 3)}eco"; restore.BackupFiles.Add(new FbBackupFile(pathDest)); restore.Verbose = true; restore.ServiceOutput += ServiceOutput; restore.Execute(); } else { Console.WriteLine("ERRO:Arquivo de Backup não encontrado!"); } }
public string Resultado() { FbConnectionStringBuilder cs = new FbConnectionStringBuilder(); cs.DataSource = "localhost"; cs.Database = "C:\\Users\\Wellington\\Documents\\KAMBESS.fdb"; cs.UserID = "SYSDBA"; cs.Password = "******"; cs.Charset = "NONE"; cs.Pooling = false; FbConnection fb = new FbConnection(cs.ToString()); string saida = ""; try { fb.Open(); FbCommand leitura = new FbCommand("Select OPE_NOM From OPERACAO WHERE OPE_COD = 40", fb); FbDataReader leitor = leitura.ExecuteReader(); while (leitor.Read()) { saida = Convert.ToString(leitor[0]); } } catch (Exception e) { saida = Convert.ToString(e); } return(saida); }
public MainWindow(Int32 accountType) { InitializeComponent(); WindowStartupLocation = WindowStartupLocation.CenterScreen; FbConnectionStringBuilder csb = new FbConnectionStringBuilder(); csb.DataSource = (string)Application.Current.Properties["dataSource"]; csb.Port = 3050; csb.Database = (string)Application.Current.Properties["dataBase"]; csb.UserID = (string)Application.Current.Properties["userID"]; csb.Password = (string)Application.Current.Properties["password"]; csb.ServerType = FbServerType.Default; connection = new FbConnection(csb.ToString()); connection.Open(); refreshBookList(); CurrentDG = Books; if (accountType == 1) { WorkersTI.IsEnabled = false; RolesTI.IsEnabled = false; CategoriesTI.IsEnabled = false; } }
public void ConnectionPoolingMaxPoolSizeTest() { FbConnection.ClearAllPools(); FbConnectionStringBuilder csb = BuildConnectionStringBuilder(FbServerType, Compression); csb.Pooling = true; csb.ConnectionLifeTime = 120; csb.MaxPoolSize = 10; string cs = csb.ToString(); var connections = new List <FbConnection>(); try { for (int i = 0; i <= csb.MaxPoolSize; i++) { var connection = new FbConnection(cs); connections.Add(connection); if (i == csb.MaxPoolSize) { Assert.Throws <InvalidOperationException>(() => connection.Open()); } else { Assert.DoesNotThrow(() => connection.Open()); } } } finally { connections.ForEach(x => x.Dispose()); } }
//метод подключения к базе данных public void OpenDBConnection(string source, string db, string user, string pass, string codepage) { try { FbConnectionStringBuilder cs = new FbConnectionStringBuilder(); cs.DataSource = source; cs.Database = db; cs.UserID = user; cs.Password = pass; cs.Dialect = 3; cs.Charset = codepage; string dbsource = cs.ToString(); if (GetConnectionState()) //если уже было подключение, закрываем его { dbConnect.Close(); } dbConnect = new FbConnection(dbsource); dbConnect.Open(); } catch (Exception ex) { dbConnect = null; //тут надо что то придумать } }
public FirebirdClient(string ipAddress, string baseName, string user, string pass) { Logging.ToLog("FirebirdClient - Создание клиента Firebird"); if (string.IsNullOrEmpty(ipAddress) || string.IsNullOrEmpty(baseName) || string.IsNullOrEmpty(user)) { connection = new FbConnection(); } else { FbConnectionStringBuilder cs = new FbConnectionStringBuilder { DataSource = ipAddress, Database = baseName, UserID = user, Password = pass, Charset = "UTF8", Pooling = false }; string connectionString = cs.ToString(); connection = new FbConnection(connectionString); } IsConnectionOpened(); }
public string BuildConnectionString(bool pooling) { FbConnectionStringBuilder cs = new FbConnectionStringBuilder(); cs.UserID = ConfigurationSettings.AppSettings["User"]; cs.Password = ConfigurationSettings.AppSettings["Password"]; cs.Database = ConfigurationSettings.AppSettings["Database"]; cs.DataSource = ConfigurationSettings.AppSettings["DataSource"]; cs.Port = Int32.Parse(ConfigurationSettings.AppSettings["Port"]); cs.Charset = ConfigurationSettings.AppSettings["Charset"]; cs.Pooling = pooling; cs.ServerType = Int32.Parse(ConfigurationSettings.AppSettings["ServerType"]); return cs.ToString(); }
public string BuildServicesConnectionString(bool includeDatabase) { FbConnectionStringBuilder cs = new FbConnectionStringBuilder(); cs.UserID = ConfigurationSettings.AppSettings["User"]; cs.Password = ConfigurationSettings.AppSettings["Password"]; if (includeDatabase) { cs.Database = ConfigurationSettings.AppSettings["Database"]; } cs.ServerType = Convert.ToInt32(ConfigurationSettings.AppSettings["ServerType"]); return cs.ToString(); }