public static DbConnection CreateConnection(string connectionStringName, bool open, out string parameterMarker, out string leftQuote, out string rightQuote)
{
ConnectionStringSettings settings = ConnectionStringSettingsFactory.Create(connectionStringName);
if (settings == null)
{
throw new Exception(String.Format(connectionStringName));
}
if (settings.ProviderName == "CodeOnTime.CustomDataProvider")
{
open = false;
settings = new ConnectionStringSettings("CustomDataProvider", String.Empty, "System.Data.SqlClient");
}
string providerName = settings.ProviderName;
DbProviderFactory factory = DbProviderFactories.GetFactory(providerName);
DbConnection connection = factory.CreateConnection();
string connectionString = settings.ConnectionString;
if (providerName.Contains("MySql"))
{
connectionString = (connectionString + "Allow User Variables=True");
}
connection.ConnectionString = connectionString;
if (open)
{
connection.Open();
}
parameterMarker = ConvertTypeToParameterMarker(providerName);
leftQuote = ConvertTypeToLeftQuote(providerName);
rightQuote = ConvertTypeToRightQuote(providerName);
return(connection);
}
public SqlStatement(CommandType commandType, string commandText, string connectionStringName)
{
ConnectionStringSettings settings = ConnectionStringSettingsFactory.Create(connectionStringName);
DbProviderFactory factory = DbProviderFactories.GetFactory(settings.ProviderName);
_connection = factory.CreateConnection();
_connection.ConnectionString = settings.ConnectionString;
_command = SqlStatement.CreateCommand(_connection);
_command.CommandType = commandType;
_command.CommandText = ParseSql(commandText);
_parameterMarker = ConvertTypeToParameterMarker(settings.ProviderName);
}
public static string GetParameterMarker(string connectionStringName)
{
ConnectionStringSettings settings = ConnectionStringSettingsFactory.Create(connectionStringName);
return(ConvertTypeToParameterMarker(settings.ProviderName));
}