/// <summary>
/// Initializes a new instance of the <see cref="iOSDataConnection"/> class.
/// </summary>
/// <param name="filename">The filename</param>
public iOSDataConnection(string filename)
{
_connectionString = string.Format("Data Source={0}; Version=3;", filename);
_tConverter = new iOSCLRConverter();
_commandGenerator = new iOSCommandGenerator();
_dConverter = new StandardDBConverter();
}
/// <summary>
/// Initializes a new instance of the <see cref="SqlServerConnection"/> class.
/// </summary>
/// <param name="ConnectionString">The connection string.</param>
public SqlServerConnection(string ConnectionString)
{
_commandGenerator = new SqlServerCommandGenerator();
_connectionString = ConnectionString;
_tConverter = new SqlServerTypeConverter();
_dConverter = new SqlServerDBConverter();
}
/// <summary>
/// Initializes a new instance of the <see cref="PostgreSQLServerConnection"/> class.
/// </summary>
/// <param name="ConnectionString">The connection string.</param>
public PostgreSQLServerConnection(string ConnectionString)
{
_commandGenerator = new PostgreCommandGenerator();
_connectionString = ConnectionString;
_tConverter = new StandardCLRConverter();
_dConverter = new PostgreDBConverter();
}
/// <summary>
/// Initializes a new instance of the <see cref="MySqlServerConnection"/> class.
/// </summary>
/// <param name="ConnectionString">The connection string.</param>
public MySqlServerConnection(string ConnectionString)
{
_commandGenerator = new MySqlCommandGenerator(StorageEngine.InnoDB, this);
_connectionString = ConnectionString;
_tConverter = new StandardCLRConverter();
_dConverter = new MySqlServerDBConverter();
}
/// <summary>
/// Initializes a new instance of the <see cref="MySqlServerConnection"/> class.
/// </summary>
/// <param name="ConnectionString">The connection string.</param>
/// <param name="engine">The storage engine to use when creating tables</param>
public MySqlServerConnection(string ConnectionString, StorageEngine engine)
{
_commandGenerator = new MySqlCommandGenerator(engine);
_connectionString = ConnectionString;
_tConverter = new StandardCLRConverter();
_dConverter = new MySqlServerDBConverter();
}
/// <summary>
/// Initializes a new instance of the <see cref="SqlLiteDataConnection"/> class.
/// </summary>
/// <param name="filename">The filename</param>
public SqlLiteDataConnection(string filename)
{
_connectionString = string.Format("Data Source={0}; Version=3;", filename);
_tConverter = new StandardCLRConverter();
_commandGenerator = new SqliteCommandGenerator(this);
_dConverter = new SQLiteDBConverter();
}
/// <summary>
/// Initializes a new instance of the <see cref="SqlServerConnection"/> class with a connection string appropriate for sql server 2k8
/// </summary>
/// <param name="Server">The server.</param>
/// <param name="Catalog">The catalog.</param>
/// <param name="User">The user.</param>
/// <param name="Password">The password.</param>
public SqlCompactConnection(string file)
{
_commandGenerator = new SqlCompactCommandGenerator();
_connectionString = string.Format("Data Source={0};Persist Security Info=False;", file);
_tConverter = new SqlCompactTypeConverter();
_dConverter = new SqlCompactDBConverter();
if (!System.IO.File.Exists(file))
{
using (SqlCeEngine engine = new SqlCeEngine(_connectionString))
{
engine.CreateDatabase();
}
}
}
