public void SetUp()
{
Factory = new OracleDbFactory();
Connection = Factory.CreateConnection(IntegrationTestOptions.Oracle.ConnectionString);
Quoter = new OracleQuoter();
Processor = new OracleProcessor(Connection, new OracleGenerator(), new TextWriterAnnouncer(System.Console.Out), new ProcessorOptions(), Factory);
}
public OracleTestTable(string table, IDbConnection connection, string schema, params string[] columnDefinitions)
{
Connection = connection;
Factory = new OracleDbFactory();
_schema = schema;
if (Connection.State != ConnectionState.Open)
{
Connection.Open();
}
Name = table;
Create(columnDefinitions);
}
public OracleTestTable(IDbConnection connection, IQuoter quoter, string schema, params string[] columnDefinitions)
{
Connection = connection;
Quoter = quoter;
Factory = new OracleDbFactory();
_schema = schema;
if (Connection.State != ConnectionState.Open)
{
Connection.Open();
}
Name = "TestTable";
Create(columnDefinitions);
}
public void TestQuery()
{
IDbFactory oracleFactory = new OracleDbFactory();
var connection = oracleFactory.CreateConnection(connectionString);
string sql = "Select * from Users";
DataSet ds = new DataSet();
using (var command = oracleFactory.CreateCommand(sql, connection))
{
var adapter = oracleFactory.CreateDataAdapter(command);
adapter.Fill(ds);
}
Assert.Greater(ds.Tables.Count, 0);
Assert.Greater(ds.Tables[0].Columns.Count, 0);
}
