//[Test]
public void MontaConexaoSQLite()
{
JokeConfigurationBuilder.NewConfigurationToSQLite()
.BuildConfiguration();
DbConnection connection = new DbConnectionFactory().Get();
Assert.That(connection.GetType().ToString(), Is.EqualTo("System.Data.SQLite.SQLiteConnection"));
}
//[Test]
public void MontaConexaoPostgreSQL()
{
JokeConfigurationBuilder.NewConfigurationToPostgreSQL()
.BuildConfiguration();
DbConnection connection = new DbConnectionFactory().Get();
Assert.That(connection.GetType().ToString(), Is.EqualTo("Npgsql.NpgsqlConnection"));
}
//[Test]
public void MontaConexaoMySQL()
{
JokeConfigurationBuilder.NewConfigurationToMySQL()
.BuildConfiguration();
DbConnection connection = new DbConnectionFactory().Get();
Assert.That(connection.GetType().ToString(), Is.EqualTo("MySql.Data.MySqlClient.MySqlConnection"));
}
//[Test]
public void MontaConexaoPostgreSQL()
{
JokeConfigurationBuilder.NewConfigurationToPostgreSQL()
.BuildConfiguration();
DbConnection connection = new DbConnectionFactory().Get();
DbDataAdapter dbDataAdapter = new DbDataAdapterFactory(SQL, connection).Get();
Assert.That(dbDataAdapter.GetType().ToString(), Is.EqualTo("Npgsql.NpgsqlDataAdapter"));
}
internal DataTable Generate()
{
DbConnection conn = new DbConnectionFactory().Get();
conn.Open();
DbDataAdapter adp = new DbDataAdapterFactory(commandSQL, conn).Get();
DataTable dataTable = new DataTable();
adp.Fill(dataTable);
conn.Close();
return dataTable;
}
