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();
}
