public void Create_Odbc()
{
IDatabaseFactory f = new DatabaseFactory("System.Data.Odbc",
"DSN=CS08;user id=cmdseries;password=cmdseries");
Assert.IsNotNull(f, "failed to create factory");
Assert.IsFalse(f.IsSqlServerProvider, "failed to create factory");
Assert.IsFalse(f.IsOracleProvider, "failed to create factory");
using (IDbConnection db = f.Create())
{
Assert.IsNotNull(db, "failed to create odbc connection");
Assert.IsInstanceOf<System.Data.Odbc.OdbcConnection>(db, "failed to create odbc connection");
using (IDbCommand cmd = db.CreateCommand())
{
IDbDataParameter p = f.AddCommandParameter(cmd, "Foo", DbType.String, ParameterDirection.Input, 1);
Assert.IsNotNull(p, "failed to create odbc command parameter");
}
}
}
// doesn't work on appharbor
//[Test]
public void Create_OdbcFromAsn_SqlServer()
{
IDatabaseFactory f = new DatabaseFactory("System.IO.File",
System.IO.Path.Combine(this.TestFolderPath, "cmdserie.mssql.asn"));
Assert.IsNotNull(f, "failed to create factory");
Assert.IsTrue(f.IsSqlServerProvider, "failed to create factory");
Assert.IsFalse(f.IsOracleProvider, "failed to create factory");
using (IDbConnection db = f.Create())
{
Assert.IsNotNull(db, "failed to create odbc connection");
Assert.IsInstanceOf<System.Data.Odbc.OdbcConnection>(db, "failed to create odbc connection");
using (IDbCommand cmd = db.CreateCommand())
{
IDbDataParameter p = f.AddCommandParameter(cmd, "Foo", DbType.String, ParameterDirection.Input, 1);
Assert.IsNotNull(p, "failed to create odbc command parameter");
}
}
}
public void Create_Oracle()
{
IDatabaseFactory f = new DatabaseFactory("System.Data.OracleClient",
"Data Source=orcl11g;user id=cmdseries;password=cmdseries");
Assert.IsNotNull(f, "failed to create factory");
Assert.IsTrue(f.IsOracleProvider, "failed to create factory");
using (IDbConnection db = f.Create())
{
Assert.IsNotNull(db, "failed to create oracle connection");
Assert.IsInstanceOf<System.Data.OracleClient.OracleConnection>(db, "failed to create oracle connection");
using (IDbCommand cmd = db.CreateCommand())
{
IDbDataParameter p = f.AddCommandParameter(cmd, "Foo", DbType.String, ParameterDirection.Input, 1);
Assert.IsNotNull(p, "failed to create oracle command parameter");
}
}
}
public void Create_SqlServer()
{
IDatabaseFactory f = new DatabaseFactory("System.Data.SqlClient",
"Data Source=localhost;User ID=cmdseries;Password=cmdseries;Initial Catalog=cmdseries;Persist Security Info=False;Pooling=False");
Assert.IsNotNull(f, "failed to create factory");
Assert.IsTrue(f.IsSqlServerProvider, "failed to create factory");
using (IDbConnection db = f.Create())
{
Assert.IsNotNull(db, "failed to create sql connection");
Assert.IsInstanceOf<System.Data.SqlClient.SqlConnection>(db, "failed to create sql connection");
using (IDbCommand cmd = db.CreateCommand())
{
IDbDataParameter p = f.AddCommandParameter(cmd, "Foo", DbType.String, ParameterDirection.Input, 1);
Assert.IsNotNull(p, "failed to create sql command parameter");
}
}
}
