} // End Constructor
public cFireBird(string strConnectionString)
{
this.m_dbtDBtype = DataBaseEngine_t.FireBird;
this.m_dblDBversion = 2.5;
this.m_providerFactory = this.GetFactory();
//this.m_DatabaseConfiguration = new DataBase.Tools.cDataBaseConfiguration();
this.m_ConnectionString = new FirebirdSql.Data.FirebirdClient.FbConnectionStringBuilder(strConnectionString);
this.m_SqlConnection = new FirebirdSql.Data.FirebirdClient.FbConnection(strConnectionString);
}
internal static string GetConnectionStringFromProperties(DataBase db, string host_, string Database_, string User_, string Password_)
{
DbConnectionStringBuilder b = null;
DataBaseAttuale = db;
if (DataBaseAttuale == DataBase.FireBird) //User=SYSDBA;Password=masterkey;Database=GAM;DataSource=localhost;
{
b = new FirebirdSql.Data.FirebirdClient.FbConnectionStringBuilder()
{
UserID = User_,
Password = Password_,
Database = Database_,
DataSource = host_
}
}
;
return(b.ConnectionString);
}
public FirebirdUniversalConnectionStringBuilder()
{
this.m_ConnectionStringBuilder = new FirebirdSql.Data.FirebirdClient.FbConnectionStringBuilder();
}
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
/// <summary>
/// Configura a string de conexão de acordo com o banco de dados definido no arquivo de configuração RegLog.config.
/// </summary>
private static void ConfigConnection()
{
var path = Path.GetDirectoryName(Assembly.GetAssembly(typeof(LogModel)).Location);
var xmlConfig = new XmlTextReader(path + "\\RegLog.config");
while (xmlConfig.Read())
{
if (xmlConfig.NodeType != XmlNodeType.Element) continue;
var elementos = new string[] {"host","port", "database", "databasename", "connectiontimeout","connectionlifetime", "user", "password"};
if (!elementos.Contains(xmlConfig.Name)) continue;
_host = xmlConfig.Name.ToLower().Equals("host") ? xmlConfig.ReadString() : _host;
_port = xmlConfig.Name.ToLower().Equals("port") && !string.IsNullOrWhiteSpace(xmlConfig.ReadString()) ? Convert.ToInt32(xmlConfig.ReadString()) : _port;
_database = xmlConfig.Name.ToLower().Equals("database") ? Convert.ToInt32(xmlConfig.ReadString()) : _database;
_dbName = xmlConfig.Name.ToLower().Equals("databasename") ? xmlConfig.ReadString() : _dbName;
_timeOut = xmlConfig.Name.ToLower().Equals("connectiontimeout") ? Convert.ToInt32(xmlConfig.ReadString()) : _timeOut;
_lifeTime = xmlConfig.Name.ToLower().Equals("connectionlifetime") ? Convert.ToInt32(xmlConfig.ReadString()) : _lifeTime;
_user = xmlConfig.Name.ToLower().Equals("user") ? xmlConfig.ReadString() : _user;
_password = xmlConfig.Name.ToLower().Equals("password") ? xmlConfig.ReadString() : _password;
}
switch (_database)
{
case 0: //SQLITE
var sqlite = new SQLiteConnection(Path.Combine(_host, _dbName));
_connection = sqlite.ConnectionString;
break;
case 1: //MSSQL
case 11:
var mssql = new System.Data.SqlClient.SqlConnectionStringBuilder
{
ConnectTimeout = _timeOut,
DataSource = _host,
Enlist = true,
InitialCatalog = _dbName,
UserID = _user,
Password = _password,
IntegratedSecurity = false,
LoadBalanceTimeout = _lifeTime,
};
_connection = mssql.ConnectionString;
break;
case 19: //MSSQL CE
var sqlce = new SqlCeConnectionStringBuilder
{
DataSource = Path.Combine(_host, _dbName),
Enlist = true,
Password = _password,
FileAccessRetryTimeout = _timeOut,
};
_connection = sqlce.ConnectionString;
break;
case 2: //MYSQL
var mysql = new MySql.Data.MySqlClient.MySqlConnectionStringBuilder
{
Database = _dbName,
Server = _host,
Password = _password,
UserID = _user,
ConnectionLifeTime = (uint)_lifeTime,
ConnectionTimeout = (uint)_timeOut,
IntegratedSecurity = false,
AutoEnlist = true
};
if(_port > 0)
mysql.Port = (uint)_port;
_connection = mysql.ConnectionString;
break;
case 3: //POSTGRESQL
var pgsql = new Npgsql.NpgsqlConnectionStringBuilder
{
Database = _dbName,
Host = _host,
Password = _password,
UserName = _user,
ConnectionLifeTime = _lifeTime,
Timeout = _timeOut,
IntegratedSecurity = false,
Enlist = true
};
if (_port > 0)
pgsql.Port = _port;
_connection = pgsql.ConnectionString;
break;
case 4: //DB2
//var db2 =
// DB2Configuration.Standard.ConnectionString(
// c => c.Database(_dbName).Server(_host).Username(_user).Password(_password));
break;
case 5: //FIREBIRD
var firebird = new FirebirdSql.Data.FirebirdClient.FbConnectionStringBuilder
{
Database = _dbName,
Password = _password,
ConnectionLifeTime = _lifeTime,
Enlist = true,
UserID = _user,
DataSource = _host,
ConnectionTimeout = _timeOut
};
if (_port > 0)
firebird.Port = _port;
_connection = firebird.ConnectionString;
break;
case 6: //ORACLE 9
case 61: //ORACLE 10
var oracle = new Oracle.DataAccess.Client.OracleConnectionStringBuilder
{
Password = _password,
ConnectionLifeTime = _lifeTime,
Enlist = "true",
UserID = _user,
DataSource = _dbName,
ConnectionTimeout = _timeOut
};
oracle["Server"] = _host;
_connection = oracle.ConnectionString;
break;
default:
_connection = "";
break;
}
}
