public void ExecuteStoredProcedureToReaderWithoutParameters() { Framework.DataServices.CommonDatabase commonDatabase = new Framework.DataServices.CommonDatabase(ConnectionName, ConnectionString, ProviderName); DbDataReader result = (DbDataReader)commonDatabase.ExecuteReader( CommandType.StoredProcedure, "sp_select_users_reader", false, CurrentUser, true); }
public void ExecuteTextToReaderWithoutParameters() { Framework.DataServices.CommonDatabase commonDatabase = new Framework.DataServices.CommonDatabase(ConnectionName, ConnectionString, ProviderName); DbDataReader result = (DbDataReader)commonDatabase.ExecuteReader( CommandType.Text, "SELECT * FROM Users", false, CurrentUser, true); }
public void ExecuteStoredProcedureToReaderWithIntParameters() { Framework.DataServices.CommonDatabase commonDatabase = new Framework.DataServices.CommonDatabase(ConnectionName, ConnectionString, ProviderName); DbDataReader result = (DbDataReader)commonDatabase.ExecuteReader( CommandType.StoredProcedure, "sp_select_users_reader", false, CurrentUser, true, commonDatabase.Parameters.Create("@Children", DbType.Int32, ParameterDirection.Input, 1)); }
public void FailedToExecutStoredProcedureToReaderInWrongStoredProcedure() { Framework.DataServices.CommonDatabase commonDatabase = new Framework.DataServices.CommonDatabase(ConnectionName, ConnectionString, ProviderName); DbDataReader result = (DbDataReader)commonDatabase.ExecuteReader( CommandType.StoredProcedure, "sp_select_users_fail", false, CurrentUser, true, commonDatabase.Parameters.Create("@BirthDate", DbType.Date, ParameterDirection.Input, DateTime.Now), commonDatabase.Parameters.Create("@Children", DbType.Int32, ParameterDirection.Input, 1)); }
public void ExecuteStoredProcedureToReaderWithDefaultOutputParameters() { Framework.DataServices.CommonDatabase commonDatabase = new Framework.DataServices.CommonDatabase(ConnectionName, ConnectionString, ProviderName); DbDataReader result = (DbDataReader)commonDatabase.ExecuteReader( CommandType.StoredProcedure, "sp_select_users_outputparameters", true, CurrentUser, true); Assert.AreEqual(commonDatabase.ExecutionStatus.ErrorNumber, 10); Assert.AreEqual(commonDatabase.ExecutionStatus.ErrorDescription, "User: "******" - Number: 10"); Assert.AreEqual(commonDatabase.ExecutionStatus.CurrentUser, CurrentUser); }
public void ExecuteTextToReaderWithIntParameters() { Framework.DataServices.CommonDatabase commonDatabase = new Framework.DataServices.CommonDatabase(ConnectionName, ConnectionString, ProviderName); Framework.DataServices.ParameterConfiguration parameterConfig = new Framework.DataServices.ParameterConfiguration(commonDatabase.GetProvider()); DbDataReader result = (DbDataReader)commonDatabase.ExecuteReader( CommandType.Text, "SELECT * FROM Users WHERE Children > @Children", false, CurrentUser, true, parameterConfig.Create("@Children", DbType.Int32, ParameterDirection.Input, 0)); }
public void FailedToExecuteTextToReaderInWrongFieldName() { Framework.DataServices.CommonDatabase commonDatabase = new Framework.DataServices.CommonDatabase(ConnectionName, ConnectionString, ProviderName); Framework.DataServices.ParameterConfiguration parameterConfig = new Framework.DataServices.ParameterConfiguration(commonDatabase.GetProvider()); DbDataReader result = (DbDataReader)commonDatabase.ExecuteReader( CommandType.Text, "SELECT * FROM Users_Fail " + " WHERE Children > @Children " + " AND BirthDateFail < @BirthDate ", false, CurrentUser, true, parameterConfig.Create("@Children", DbType.Int32, ParameterDirection.Input, 1), parameterConfig.Create("@BirthDate", DbType.Date, ParameterDirection.Input, DateTime.Now)); }