private static void ParseNamedParameters(ConnectionStringItem item, ConnectionParameters result)
{
if (int.TryParse(item.PropertyValue?.Trim(), out var intValue))
{
result.NamedParameters = intValue != 0;
}
else if (bool.TryParse(item.PropertyValue?.Trim(), out var boolValue))
{
result.NamedParameters = boolValue;
}
}
private static void ParseEnableServerPacketSize(ConnectionStringItem item, ConnectionParameters result)
{
if (int.TryParse(item.PropertyValue?.Trim(), out var intValue))
{
result.EnableServerPacketSize = intValue != 0;
}
else if (bool.TryParse(item.PropertyValue?.Trim(), out var boolValue))
{
result.EnableServerPacketSize = boolValue;
}
}
private static void ParseServer(ConnectionStringItem item, ConnectionParameters result)
{
if (string.IsNullOrWhiteSpace(item.PropertyValue))
{
return;
}
var parts = item.PropertyValue.Split(',', ':');
result.Server = parts[0];
if (parts.Length > 1)
{
result.Port = Convert.ToInt32(parts[1]);
}
}
private static void ParseEncryptPassword(ConnectionStringItem item, ConnectionParameters result)
{
if (bool.TryParse(item.PropertyValue, out var parsedBool))
{
result.EncryptPassword = parsedBool;
}
else if (int.TryParse(item.PropertyValue, out var parsedInt))
{
result.EncryptPassword = parsedInt != 0;
}
else
{
result.EncryptPassword = Convert.ToBoolean(item.PropertyValue);
}
}
private static void ParseUseAseDecimal(ConnectionStringItem item, ConnectionParameters result)
{
if (bool.TryParse(item.PropertyValue, out var parsedBool))
{
result.UseAseDecimal = parsedBool;
}
else if (int.TryParse(item.PropertyValue, out var parsedInt))
{
result.UseAseDecimal = parsedInt != 0;
}
else
{
result.UseAseDecimal = Convert.ToBoolean(item.PropertyValue);
}
}
private static void ParseLoginTimeout(ConnectionStringItem item, ConnectionParameters result)
{
result.LoginTimeout = Convert.ToInt32(item.PropertyValue);
}
private static void ParsePingServer(ConnectionStringItem item, ConnectionParameters result)
{
result.PingServer = Convert.ToBoolean(item.PropertyValue);
}
private static void ParseClientHostProc(ConnectionStringItem item, ConnectionParameters result)
{
result.ClientHostProc = item.PropertyValue;
}
private static void ParseApplicationName(ConnectionStringItem item, ConnectionParameters result)
{
result.ApplicationName = item.PropertyValue;
}
private static void ParseMinPoolSize(ConnectionStringItem item, ConnectionParameters result)
{
result.MinPoolSize = Convert.ToInt16(item.PropertyValue);
}
private static void ParseTrustedFile(ConnectionStringItem item, ConnectionParameters result)
{
result.TrustedFile = item.PropertyValue;
}
private static void ParseTextSize(ConnectionStringItem item, ConnectionParameters result)
{
result.TextSize = Convert.ToInt32(item.PropertyValue);
}
private static void ParseUsername(ConnectionStringItem item, ConnectionParameters result)
{
result.Username = item.PropertyValue;
}
private static void ParseDatabase(ConnectionStringItem item, ConnectionParameters result)
{
result.Database = item.PropertyValue;
}
private static void ParseAnsiNull(ConnectionStringItem item, ConnectionParameters result)
{
result.AnsiNull = Convert.ToInt32(item.PropertyValue) == 1;
}
private static void ParseConnectionLifetime(ConnectionStringItem item, ConnectionParameters result)
{
result.ConnectionLifetime = Convert.ToInt16(item.PropertyValue);
}
private static void ParsePacketSize(ConnectionStringItem item, ConnectionParameters result)
{
result.PacketSize = Convert.ToUInt16(item.PropertyValue);
}
private static void ParsePassword(ConnectionStringItem item, ConnectionParameters result)
{
result.Password = item.PropertyValue;
}
private static void ParseCharset(ConnectionStringItem item, ConnectionParameters result)
{
result.Charset = item.PropertyValue;
}
private static void ParseEncryption(ConnectionStringItem item, ConnectionParameters result)
{
result.Encryption = string.Equals(item.PropertyValue?.Trim(), "ssl", StringComparison.OrdinalIgnoreCase);
}