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