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"); } } }