public static IDbConnection GetDbConnection(EDbConnectionTypes dbType, string connectionString)
{
IDbConnection connection = null;
switch (dbType)
{
case EDbConnectionTypes.MariaDb:
connection = new MySqlConnection(connectionString);
break;
case EDbConnectionTypes.MySql:
connection = new MySqlConnection(connectionString);
break;
case EDbConnectionTypes.SQLServer:
// TODO: Implement Document DB connection
break;
default:
connection = null;
break;
}
connection.Open();
return(connection);
}
public static IDbConnection GetDbConnection(EDbConnectionTypes dbType, string connectionString)
{
IDbConnection connection = null;
switch (dbType)
{
case EDbConnectionTypes.SQL:
connection = new SqlConnection(connectionString);
break;
case EDbConnectionTypes.XML:
// TODO: Implement XML Connection (path name)
break;
case EDbConnectionTypes.DOCUMENT:
// TODO: Implement Document DB connection
break;
default:
connection = null;
break;
}
connection.Open();
return(connection);
}
public static SqlConnection GetDbConnection(EDbConnectionTypes dbType, string connectionString)
{
SqlConnection connection = null;
switch (dbType)
{
case EDbConnectionTypes.Sql:
connection = new SqlConnection(connectionString);
break;
default:
connection = null;
break;
}
return(connection);
}
public static IDbConnection GetDbConnection(EDbConnectionTypes dbType, string connectionString)
{
IDbConnection connection = null;
switch (dbType)
{
case EDbConnectionTypes.Sqlite:
connection = new SQLiteConnection(connectionString);
break;
default:
connection = null;
break;
}
connection.Open();
return(connection);
}
public MariaDbRepository(string connectionString)
{
_dbType = EDbConnectionTypes.MariaDb;
_connectionString = connectionString;
}
public SqlRepository(string connectionString)
{
_dbType = EDbConnectionTypes.Sqlite;
_connectionString = connectionString;
}
public SqlRepository(IConfiguration configuration)
{
_dbType = EDbConnectionTypes.Sql;
_config = configuration;
}
public DocumentRepository(string connectionString)
{
_dbType = EDbConnectionTypes.DOCUMENT;
_connectionString = connectionString;
}
public XmlRepository(string filePath)
{
_dbType = EDbConnectionTypes.XML;
_connectionString = filePath;
}
public Repository(string connectionString)
{
_dbType = EDbConnectionTypes.SQL;
_connectionString = connectionString;
}
