public void InitDbs(string conn)
{
if (conn == "")
{
string assemblyFolder = Path.GetDirectoryName(Assembly.GetExecutingAssembly().CodeBase);
assemblyFolder = assemblyFolder.Replace("\\Debug", "");
assemblyFolder = assemblyFolder.Replace("\\bin", "");
assemblyFolder = assemblyFolder.Replace("\\netcoreapp2.1", "");
assemblyFolder = assemblyFolder.Replace("file:\\", "");
string text = System.IO.File.ReadAllText(assemblyFolder + @"\appsettings.json");
dynamic o = Newtonsoft.Json.JsonConvert.DeserializeObject <appSetting>(text);
conn = o.Conn;
if (conn == null)
{
conn = DbConnection;
}
}
//Modify the connections to suit
//Comment any databases that should not be executed against
DBDatabase mysql = DBDatabase.Create("MySQL"
, conn
, DbProvider);
this._database = mysql;
this._database.HandleException += new DBExceptionHandler(database_HandleException);
var il = conn.Split(';').Where(x => x.ToLower().IndexOf("initial") >= 0).ToList();
if (il.Count > 0)
{
_Schema = il[0].ToLower().Replace("initial catalog=", "");
_Schema = _Schema.Replace("database=", "");
}
}
/// <summary>
/// Creates a new DBDatabase referring to the constants DBConnection and DBProvider
/// </summary>
/// <returns></returns>
public static DBDatabase CreateDB()
{
DBDatabase db = DBDatabase.Create(Nw.DbConnection, Nw.DbProvider);
//requires valid connection
//Console.WriteLine("DataBase '" + db.ProviderName + "' properties: " + db.DBProperties.ToString());
return(db);
}
public void InitDbs(string conn)
{
//Modify the connections to suit
//Comment any databases that should not be executed against
DBDatabase mysql = DBDatabase.Create("MySQL"
, conn
, DbProvider);
this._database = mysql;
this._database.HandleException += new DBExceptionHandler(database_HandleException);
}
private void toolStripButton2_Click(object sender, EventArgs e)
{
ClientConnection con = new ClientConnection();
if (con.ShowDialog(this) == DialogResult.OK)
{
database = DBDatabase.Create(con.ConnectionString, con.ProviderName);
provider = database.GetSchemaProvider();
this.LoadSchemaTree();
}
}
/// <summary>
/// Creates and returns a reference to a (non-existant) Oracle Database
/// </summary>
/// <returns></returns>
private static DBDatabase GetOracleDB()
{
DBDatabase db = CreateDB();
if (db.ProviderName != Oracle.DBOracleImplementation.OracleProviderName)
{
Console.WriteLine("Running with NON Oracle Provider - so everything will fail. Only oracle provider supports the Squence generation");
Console.WriteLine("Switching to oracle provider");
//Doesn't need to exist to run the tests
db = DBDatabase.Create("DATA SOURCE=0.0.0.0;PERSIST SECURITY INFO=True;USER ID=NONE;PASSWORD=NONE", Oracle.DBOracleImplementation.OracleProviderName);
}
return(db);
}
private bool ChooseConnection()
{
ClientConnection con = new ClientConnection();
if (con.ShowDialog() == DialogResult.OK)
{
database = DBDatabase.Create(con.ConnectionString, con.ProviderName);
provider = database.GetSchemaProvider();
return(true);
}
else
{
return(false);
}
}
public void InitDbs(string conn)
{
string dataProvider = @"MySql.Data.MySqlClient";
string dataProviderDescription = @".Net Framework Data Provider for MySQL";
string dataProviderName = @"MySQL Data Provider";
string dataProviderType = @"MySql.Data.MySqlClient.MySqlClientFactory, MySql.Data, Version=8.0.19.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d";
DataTable dt = new DataTable();
dt.Columns.Add("Name");
dt.Columns.Add("Description");
dt.Columns.Add("InvariantName");
dt.Columns.Add("AssemblyQualifiedName");
dt.Rows.Add(dataProviderName, dataProviderDescription, dataProvider, dataProviderType);
//if (conn == "")
//{
// string assemblyFolder = Path.GetDirectoryName(Assembly.GetExecutingAssembly().CodeBase);
// assemblyFolder = assemblyFolder.Replace("\\Debug", "");
// assemblyFolder = assemblyFolder.Replace("\\bin", "");
// assemblyFolder = assemblyFolder.Replace("\\netcoreapp2.1", "");
// assemblyFolder = assemblyFolder.Replace("file:\\", "");
// string text = System.IO.File.ReadAllText(assemblyFolder + @"\appsettings.json");
// dynamic o = Newtonsoft.Json.JsonConvert.DeserializeObject<appSetting>(text);
// conn = o.Conn;
// if (conn == null)
// {
// conn = DbConnection;
// }
//}
//Modify the connections to suit
//Comment any databases that should not be executed against
DBDatabase mysql = DBDatabase.Create("MySQL"
, conn
, DbProvider, dt);
this._database = mysql;
this._database.HandleException += new DBExceptionHandler(database_HandleException);
var il = conn.Split(';').Where(x => x.ToLower().IndexOf("initial") >= 0).ToList();
if (il.Count > 0)
{
_Schema = il[0].ToLower().Replace("initial catalog=", "");
_Schema = _Schema.Replace("database=", "");
}
}
public bool CheckConnection(out Exception failure)
{
bool success = false;
failure = null;
try
{
DBDatabase db = DBDatabase.Create(this.ConnectionString, this.ProviderName);
//validate that we can get the properties and a schema provider
DBDatabaseProperties props = db.GetProperties();
Schema.DBSchemaProvider prov = db.GetSchemaProvider();
Schema.DBSchemaMetaDataCollectionSet collections = prov.Collections;
success = true;
}
catch (Exception ex)
{
success = false;
failure = ex;
}
return(success);
}
/* End SQL Server connections */
/* MySql Connections
* public const string DbConnection = "server=172.16.56.1;User Id=testaccount;Password=test;Persist Security Info=True;database=northwind;AllowUserVariables=true";
* public const string DbProvider = "MySql.Data.MySqlClient";
* /* End SQL Server connections */
/* SQLite connections
* public const string DbConnection = @"data source=C:\Development\DynaSQL\DynaSQLUnitTest.db;foreign keys=true;"; //we add the foreign keys=true here to enforce them
* public const string DbProvider = "System.Data.SQLite";
* /* End SQLite connections */
/* MS Access connections
* public const string DbConnection = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Sample Databases\Northwind2007.accdb;Persist Security Info=False;";
* public const string DbProvider = "System.Data.OleDb";
* /* End MSAccess connections */
#region private static DBDatabase CreateDb()
/// <summary>
/// Creates the database connection
/// </summary>
/// <returns></returns>
private static DBDatabase ConnectDb()
{
return(DBDatabase.Create(DbConnection, DbProvider));
}
