private void bTEST_Click(object sender, EventArgs e)
{
try
{
using (FirebirdSql.Data.FirebirdClient.FbConnection fbc = new FirebirdSql.Data.FirebirdClient.FbConnection((new clDBInfo(tbDBName.Text, cbServer.Text, tbDBPath.Text, tbUser.Text, tbPassword.Text)).GetFbConnStr()))
{
fbc.Open();
FbServerProperties fbsp = new FbServerProperties();
fbsp.ConnectionString = (new clDBInfo(tbDBName.Text, cbServer.Text, tbDBPath.Text, tbUser.Text, tbPassword.Text)).GetFbConnStr();
string msg = "";
foreach (string s in fbsp.DatabasesInfo.Databases)
{
msg = msg + "\n" + s;
}
MessageBox.Show(string.Format("к серверу {0} успешно установлено соединение.\nВсего соединений к серверу БД: {1}\n {2}", cbServer.Text, fbsp.DatabasesInfo.ConnectionCount, msg));
fbc.Close();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
FbTraceVersion DetectVersion()
{
var serverProperties = new FbServerProperties(ConnectionString);
var serverVersion = FbServerProperties.ParseServerVersion(serverProperties.GetServerVersion());
if (serverVersion < new Version(3, 0, 0, 0))
{
return(FbTraceVersion.Version1);
}
else
{
return(FbTraceVersion.Version2);
}
}
async Task <FbTraceVersion> DetectVersionAsync(CancellationToken cancellationToken = default)
{
var serverProperties = new FbServerProperties(ConnectionString);
var serverVersion = FbServerProperties.ParseServerVersion(await serverProperties.GetServerVersionAsync(cancellationToken).ConfigureAwait(false));
if (serverVersion < new Version(3, 0, 0, 0))
{
return(FbTraceVersion.Version1);
}
else
{
return(FbTraceVersion.Version2);
}
}
public void ServerPropertiesTest()
{
FbServerProperties serverProp = new FbServerProperties();
serverProp.ConnectionString = this.BuildServicesConnectionString(false);
FbServerConfig serverConfig = serverProp.GetServerConfig();
FbDatabasesInfo databasesInfo = serverProp.GetDatabasesInfo();
Console.WriteLine(serverProp.GetMessageFile());
Console.WriteLine(serverProp.GetLockManager());
Console.WriteLine(serverProp.GetRootDirectory());
Console.WriteLine(serverProp.GetImplementation());
Console.WriteLine(serverProp.GetServerVersion());
Console.WriteLine(serverProp.GetVersion());
}
public void ServerPropertiesTest()
{
FbServerProperties serverProp = new FbServerProperties();
serverProp.ConnectionString = this.BuildServicesConnectionString(false);
FbServerConfig serverConfig = serverProp.ServerConfig;
FbDatabasesInfo databasesInfo = serverProp.DatabasesInfo;
Console.WriteLine(serverProp.MessageFile);
Console.WriteLine(serverProp.LockManager);
Console.WriteLine(serverProp.RootDirectory);
Console.WriteLine(serverProp.Implementation);
Console.WriteLine(serverProp.ServerVersion);
Console.WriteLine(serverProp.Version);
}
protected override string GetDbProviderManifestToken(DbConnection connection)
{
try
{
var serverVersion = default(Version);
if (connection.State == ConnectionState.Open)
{
serverVersion = FbServerProperties.ParseServerVersion(connection.ServerVersion);
}
else
{
var serverProperties = new FbServerProperties() { ConnectionString = connection.ConnectionString };
serverVersion = FbServerProperties.ParseServerVersion(serverProperties.GetServerVersion());
}
return serverVersion.ToString(2);
}
catch (Exception ex)
{
throw new InvalidOperationException("Could not retrieve storage version.", ex);
}
}
protected override string GetDbProviderManifestToken(DbConnection connection)
{
if (connection == null)
throw new ArgumentException("connection");
FbConnection fbConnection = CheckAndCastToFbConnection(connection);
if (string.IsNullOrEmpty(fbConnection.ConnectionString))
{
throw new ArgumentException("Could not determine storage version; a valid storage connection is required.");
}
try
{
FbServerProperties serverProperties = new FbServerProperties() { ConnectionString = fbConnection.ConnectionString };
Version serverVersion = serverProperties.GetServerVersion().ParseServerVersion();
return serverVersion.ToString(2);
}
catch (FbException ex)
{
throw new InvalidOperationException("Could not retrieve storage version.", ex);
}
}
public Version GetServerVersion()
{
var server = new FbServerProperties();
server.ConnectionString = BuildServicesConnectionString(_fbServerType);
return FbServerProperties.ParseServerVersion(server.GetServerVersion());
}
