public void CanDoExecuteDataReaderForGenericDatabaseForSqlProviderBug1836()
{
Database db = new GenericDatabase(@"server=(local)\SQLEXPRESS;database=Northwind;Integrated Security=true", SqlClientFactory.Instance);
using (DbConnection connection = db.CreateConnection())
{
connection.Open();
using (DbTransaction transaction = connection.BeginTransaction())
{
using (IDataReader dataReader = db.ExecuteReader(transaction, CommandType.Text, "select * from [Order Details]")) {}
transaction.Commit();
}
}
}
public void CanDoExecuteDataReaderForGenericDatabaseBug1836()
{
Database db = new GenericDatabase(@"Driver={Microsoft Access Driver (*.mdb)};Dbq=northwind.mdb;Uid=sa;Pwd=sa;", OdbcFactory.Instance);
using (DbConnection connection = db.CreateConnection())
{
connection.Open();
using (DbTransaction transaction = connection.BeginTransaction())
{
using (IDataReader dataReader = db.ExecuteReader(transaction, CommandType.Text, "select * from [Order Details]")) {}
transaction.Commit();
}
}
}
public void CanDoExecuteDataReaderForGenericDatabaseForSqlProviderBug1836()
{
Database db = new GenericDatabase(@"server=(localdb)\v11.0;database=Northwind;Integrated Security=true", SqlClientFactory.Instance);
using (DbConnection connection = db.CreateConnection())
{
connection.Open();
using (DbTransaction transaction = connection.BeginTransaction())
{
using (IDataReader dataReader = db.ExecuteReader(transaction, CommandType.Text, "select * from [Order Details]")) { }
transaction.Commit();
}
}
}
public void CanDoExecuteDataReaderForGenericDatabaseBug1836()
{
Database db = new GenericDatabase(@"Driver={Microsoft Access Driver (*.mdb)};Dbq=northwind.mdb;Uid=sa;Pwd=sa;", OdbcFactory.Instance);
using (DbConnection connection = db.CreateConnection())
{
connection.Open();
using (DbTransaction transaction = connection.BeginTransaction())
{
using (IDataReader dataReader = db.ExecuteReader(transaction, CommandType.Text, "select * from [Order Details]")) { }
transaction.Commit();
}
}
}
public void CanDoExecuteDataReaderForGenericDatabaseForSqlProviderBug1836()
{
Database db = new GenericDatabase(String.Format(@"server={0};database=Northwind;Integrated Security=true", ConfigurationManager.AppSettings["SqlServerDatabaseInstance"]), SqlClientFactory.Instance);
using (DbConnection connection = db.CreateConnection())
{
connection.Open();
using (DbTransaction transaction = connection.BeginTransaction())
{
using (IDataReader dataReader = db.ExecuteReader(transaction, CommandType.Text, "select * from [Order Details]")) { }
transaction.Commit();
}
}
}
public void DSDBWrapperTransSqlNoCommitTestBug1857()
{
Database db = new GenericDatabase(@"server=(local)\SQLEXPRESS;database=Northwind;Integrated Security=true", SqlClientFactory.Instance);
using (DbConnection connection = db.CreateConnection())
{
connection.Open();
using (DbTransaction transaction = connection.BeginTransaction())
{
string sqlCommand = "select * from [Order Details]";
DbCommand dbCommand = db.GetSqlStringCommand(sqlCommand);
DataSet dsActualResult = db.ExecuteDataSet(dbCommand, transaction);
}
}
}
public void CanDoExecuteDataReaderForGenericDatabaseBug1836()
{
Database db = new GenericDatabase($@"Driver={{Microsoft Access Driver (*.mdb, *.accdb)}};Dbq={Path.GetDirectoryName(Assembly.GetExecutingAssembly().Location)}\Northwind.mdb;Uid=sa;Pwd=sa;", OdbcFactory.Instance);
using (DbConnection connection = db.CreateConnection())
{
connection.Open();
using (DbTransaction transaction = connection.BeginTransaction())
{
using (IDataReader dataReader = db.ExecuteReader(transaction, CommandType.Text, "select * from [Order Details]")) { }
transaction.Commit();
}
}
}
public void DSDBWrapperTransSqlNoCommitTestBug1857()
{
Database db = new GenericDatabase(@"server=(localdb)\v11.0;database=Northwind;Integrated Security=true", SqlClientFactory.Instance);
using (DbConnection connection = db.CreateConnection())
{
connection.Open();
using (DbTransaction transaction = connection.BeginTransaction())
{
string sqlCommand = "select * from [Order Details]";
DbCommand dbCommand = db.GetSqlStringCommand(sqlCommand);
DataSet dsActualResult = db.ExecuteDataSet(dbCommand, transaction);
}
}
}
public void DSDBWrapperTransSqlNoCommitTestBug1857()
{
Database db = new GenericDatabase(String.Format(@"server={0};database=Northwind;Integrated Security=true", ConfigurationManager.AppSettings["SqlServerDatabaseInstance"]), SqlClientFactory.Instance);
using (DbConnection connection = db.CreateConnection())
{
connection.Open();
using (DbTransaction transaction = connection.BeginTransaction())
{
string sqlCommand = "select * from [Order Details]";
DbCommand dbCommand = db.GetSqlStringCommand(sqlCommand);
DataSet dsActualResult = db.ExecuteDataSet(dbCommand, transaction);
}
}
}