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