public void SetUp() { DatabaseProviderFactory factory = new DatabaseProviderFactory(TestConfigurationSource.CreateConfigurationSource()); db = factory.Create("OracleTest"); CreateTableWithGuidAndBinary(); }
public void SetUp() { NetCoreHelpers.RegisterDbProviderFactories(); DatabaseProviderFactory factory = new DatabaseProviderFactory(TestConfigurationSource.CreateConfigurationSource()); sqlDatabase = (SqlDatabase)factory.CreateDefault(); }
void DeleteUser() { DatabaseProviderFactory factory = new DatabaseProviderFactory(TestConfigurationSource.CreateConfigurationSource()); Database adminDb = factory.CreateDefault(); using (DbConnection connection = adminDb.CreateConnection()) { connection.Open(); string query; DbCommand dropUser; try { query = string.Format("exec sp_revokedbaccess '{0}'", TestConfigurationSource.NorthwindDummyUser); dropUser = adminDb.GetSqlStringCommand(query); adminDb.ExecuteNonQuery(dropUser); } catch {} try { query = string.Format("exec sp_droplogin '{0}'", TestConfigurationSource.NorthwindDummyUser); dropUser = adminDb.GetSqlStringCommand(query); adminDb.ExecuteNonQuery(dropUser); } catch {} } }
public void SetUp() { DatabaseProviderFactory factory = new DatabaseProviderFactory(TestConfigurationSource.CreateConfigurationSource()); db = factory.CreateDefault(); CompleteSetup(db); }
public void SetUp() { DatabaseProviderFactory factory = new DatabaseProviderFactory(TestConfigurationSource.CreateConfigurationSource()); db = factory.Create("OracleTest"); CreateStoredProcedure(); }
public void SetUp() { DatabaseProviderFactory factory = new DatabaseProviderFactory(TestConfigurationSource.CreateConfigurationSource()); db = factory.CreateDefault(); baseFixture = new DataAccessTestsFixture(db); }
public void TestInitialize() { DatabaseProviderFactory factory = new DatabaseProviderFactory(TestConfigurationSource.CreateConfigurationSource()); db = factory.Create("OracleTest"); baseFixture = new DataAccessTestsFixture(db); }
public void CanGetConnectionWithoutCredentials() { DatabaseConfigurationView view = new DatabaseConfigurationView(TestConfigurationSource.CreateConfigurationSource()); ConnectionStringSettings data = view.GetConnectionStringSettings("DbWithSqlServerAuthn"); SqlDatabase sqlDatabase = new SqlDatabase(data.ConnectionString); Assert.AreEqual(@"server=(local)\sqlexpress;database=northwind;", sqlDatabase.ConnectionStringWithoutCredentials); }
public void SetUp() { NetCoreHelpers.RegisterDbProviderFactories(); DatabaseProviderFactory factory = new DatabaseProviderFactory(TestConfigurationSource.CreateConfigurationSource()); db = factory.CreateDefault(); baseFixture = new DataAccessTestsFixture(db); }
public void CanGetConnectionForStringWithNoCredentials() { DatabaseConfigurationView view = new DatabaseConfigurationView(TestConfigurationSource.CreateConfigurationSource()); ConnectionStringSettings data = view.GetConnectionStringSettings("NewDatabase"); SqlDatabase sqlDatabase = new SqlDatabase(data.ConnectionString); Assert.AreEqual(@"server=(local)\sqlexpress;database=northwind;integrated security=true;", sqlDatabase.ConnectionStringWithoutCredentials); }
public void SetUp() { DatabaseProviderFactory factory = new DatabaseProviderFactory(TestConfigurationSource.CreateConfigurationSource()); db = factory.CreateDefault(); DbCommand command = db.GetSqlStringCommand("Select count(*) from region"); baseFixture = new ExecuteScalarFixture(db, command); }
public void SetUp() { DatabaseProviderFactory factory = new DatabaseProviderFactory(TestConfigurationSource.CreateConfigurationSource()); db = factory.CreateDefault(); DbCommand insertionCommand = db.GetSqlStringCommand(insertString); DbCommand countCommand = db.GetSqlStringCommand(countQuery); baseFixture = new ExecuteNonQueryFixture(db, insertString, countQuery, insertionCommand, countCommand); }
public void TestInitialize() { DatabaseProviderFactory factory = new DatabaseProviderFactory(TestConfigurationSource.CreateConfigurationSource()); db = factory.CreateDefault(); DbCommand insertCommand = db.GetSqlStringCommand(insertString); DbCommand queryCommand = db.GetSqlStringCommand(queryString); baseFixture = new ExecuteReaderFixture(db, insertString, insertCommand, queryString, queryCommand); }
public void TestInitialize() { DatabaseProviderFactory factory = new DatabaseProviderFactory(TestConfigurationSource.CreateConfigurationSource()); db = factory.Create("OracleTest"); storedProcedure = db.GetStoredProcCommand("CustOrdersOrders"); connection = db.CreateConnection(); connection.Open(); storedProcedure.Connection = connection; cache = new ParameterCache(); baseFixture = new ParameterDiscoveryFixture(storedProcedure); }
public void Initialize() { DatabaseProviderFactory factory = new DatabaseProviderFactory(TestConfigurationSource.CreateConfigurationSource()); db = factory.Create("OracleTest"); try { DeleteStoredProcedures(); } catch {} CreateStoredProcedures(); base.SetUp(); }
public void SetUp() { DatabaseProviderFactory factory = new DatabaseProviderFactory(TestConfigurationSource.CreateConfigurationSource()); db = factory.Create("OracleTest"); try { DeleteStoredProcedures(); } catch {} CreateStoredProcedures(); baseFixture = new TransactionScopeFixture(db); baseFixture.Clenaup(); }
public void ConnectionTest() { DatabaseConfigurationView view = new DatabaseConfigurationView(TestConfigurationSource.CreateConfigurationSource()); ConnectionStringSettings data = view.GetConnectionStringSettings("NewDatabase"); SqlDatabase sqlDatabase = new SqlDatabase(data.ConnectionString); DbConnection connection = sqlDatabase.CreateConnection(); Assert.IsNotNull(connection); Assert.IsTrue(connection is SqlConnection); connection.Open(); DbCommand cmd = sqlDatabase.GetSqlStringCommand("Select * from Region"); cmd.CommandTimeout = 60; Assert.AreEqual(cmd.CommandTimeout, 60); }
public static DictionaryConfigurationSource CreateConfigurationSource() { DictionaryConfigurationSource configSource = TestConfigurationSource.CreateConfigurationSource(); var connectionString = new ConnectionStringSettings( OracleConnectionStringName, OracleConnectionString, OracleProviderName); var connectionStrings = new ConnectionStringsSection(); connectionStrings.ConnectionStrings.Add(connectionString); configSource.Add("connectionStrings", connectionStrings); return(configSource); }
public void Initialize() { DatabaseProviderFactory factory = new DatabaseProviderFactory(TestConfigurationSource.CreateConfigurationSource()); db = factory.Create("OracleTest"); // ensure that stored procedures are dropped before trying to create them try { DeleteStoredProcedures(); } catch { } CreateStoredProcedures(); base.SetUp(); }
public void CanInsertNullStringParameter() { DatabaseProviderFactory factory = new DatabaseProviderFactory(TestConfigurationSource.CreateConfigurationSource()); Database db = factory.Create("OracleTest"); using (DbConnection connection = db.CreateConnection()) { connection.Open(); using (DbTransaction transaction = connection.BeginTransaction()) { string sqlString = "insert into Customers (CustomerID, CompanyName, ContactName) Values (:id, :name, :contact)"; DbCommand insert = db.GetSqlStringCommand(sqlString); db.AddInParameter(insert, ":id", DbType.Int32, 1); db.AddInParameter(insert, ":name", DbType.String, "fee"); db.AddInParameter(insert, ":contact", DbType.String, null); db.ExecuteNonQuery(insert, transaction); transaction.Rollback(); } } }
public void CanExecuteProcedureWithUnicaodeParametersInSql() { DatabaseProviderFactory factory = new DatabaseProviderFactory(TestConfigurationSource.CreateConfigurationSource()); SqlDatabase db = factory.CreateDefault() as SqlDatabase; object procedureOutput = null; using (DbConnection connection = db.CreateConnection()) { connection.Open(); using (DbTransaction transaction = connection.BeginTransaction()) { db.ExecuteNonQuery(transaction, CommandType.Text, @"CREATE PROCEDURE CanAddSqlTypeParameters @UnicodeParam nvarchar(50) AS SELECT @UnicodeParam"); DbCommand commandToCustOrderHist = db.GetStoredProcCommand("CanAddSqlTypeParameters"); db.AddInParameter(commandToCustOrderHist, "UnicodeParam", SqlDbType.NVarChar, "PROCEDURE INPUT \u0414"); procedureOutput = db.ExecuteScalar(commandToCustOrderHist, transaction); transaction.Rollback(); } } Assert.AreEqual("PROCEDURE INPUT \u0414", procedureOutput); }
private void CreateUser() { DatabaseProviderFactory factory = new DatabaseProviderFactory(TestConfigurationSource.CreateConfigurationSource()); Database adminDb = factory.CreateDefault(); using (DbConnection connection = adminDb.CreateConnection()) { connection.Open(); string query; DbCommand addUser; try { query = string.Format("exec sp_addlogin '{0}', '{1}', 'Northwind'", TestConfigurationSource.NorthwindDummyUser, TestConfigurationSource.NorthwindDummyPassword); addUser = adminDb.GetSqlStringCommand(query); adminDb.ExecuteNonQuery(addUser); } catch (Exception e) { Console.WriteLine(e.Message); } try { query = string.Format("exec sp_grantdbaccess '{0}', '{0}'", TestConfigurationSource.NorthwindDummyUser); addUser = adminDb.GetSqlStringCommand(query); adminDb.ExecuteNonQuery(addUser); } catch { } try { query = string.Format("exec sp_addrolemember N'db_owner', N'{0}'", TestConfigurationSource.NorthwindDummyUser); addUser = adminDb.GetSqlStringCommand(query); adminDb.ExecuteNonQuery(addUser); } catch { } } }
public void CheckNoPasswordInConnectionStringWithPersistInfoEqualsFalse() { try { CreateUser(); DatabaseConfigurationView view = new DatabaseConfigurationView(TestConfigurationSource.CreateConfigurationSource()); ConnectionStringSettings data = view.GetConnectionStringSettings("NorthwindPersistFalse"); SqlDatabase sqlDatabase = new SqlDatabase(data.ConnectionString); DbConnection dbConnection = sqlDatabase.CreateConnection(); dbConnection.Open(); dbConnection.Close(); string connectionString = dbConnection.ConnectionString; if (connectionString.ToLower().Contains("pwd") || connectionString.ToLower().Contains("password")) { Assert.Fail(); } } finally { DeleteUser(); } }
public void CanGetConnectionForStringWithNoCredentials() { DatabaseSyntheticConfigSettings settings = new DatabaseSyntheticConfigSettings(TestConfigurationSource.CreateConfigurationSource()); ConnectionStringSettings data = settings.GetConnectionStringSettings("NewDatabase"); SqlDatabase sqlDatabase = new SqlDatabase(data.ConnectionString); Assert.AreEqual(String.Format(@"server={0};database=northwind;integrated security=true;", ConfigurationManager.AppSettings["SqlServerDatabaseInstance"]), sqlDatabase.ConnectionStringWithoutCredentials); }
public void CanGetConnectionForStringWithNoCredentials() { DatabaseSyntheticConfigSettings settings = new DatabaseSyntheticConfigSettings(TestConfigurationSource.CreateConfigurationSource()); ConnectionStringSettings data = settings.GetConnectionStringSettings("NewDatabase"); SqlDatabase sqlDatabase = new SqlDatabase(data.ConnectionString); Assert.AreEqual(@"server=(localdb)\v11.0;database=northwind;integrated security=true;", sqlDatabase.ConnectionStringWithoutCredentials); }
public void CanGetConnectionWithoutCredentials() { DatabaseSyntheticConfigSettings settings = new DatabaseSyntheticConfigSettings(TestConfigurationSource.CreateConfigurationSource()); ConnectionStringSettings data = settings.GetConnectionStringSettings("DbWithSqlServerAuthn"); SqlDatabase sqlDatabase = new SqlDatabase(data.ConnectionString); Assert.AreEqual(@"server=(localdb)\v11.0;database=northwind;", sqlDatabase.ConnectionStringWithoutCredentials); }
public void TestInitialize() { DatabaseProviderFactory factory = new DatabaseProviderFactory(TestConfigurationSource.CreateConfigurationSource()); db = factory.CreateDefault(); }
public void SetUp() { DatabaseProviderFactory factory = new DatabaseProviderFactory(TestConfigurationSource.CreateConfigurationSource()); sqlDatabase = (SqlDatabase)factory.CreateDefault(); }
public ThreadTests() { DatabaseProviderFactory factory = new DatabaseProviderFactory(TestConfigurationSource.CreateConfigurationSource()); db = factory.CreateDefault(); }