public void ExecuteStoredProcedureToDataSetWithoutParameters()
{
Framework.DataServices.CommonDatabase commonDatabase =
new Framework.DataServices.CommonDatabase(ConnectionName, ConnectionString, ProviderName);
DataSet dsResult = commonDatabase.ExecuteDataSet(
CommandType.StoredProcedure,
"sp_select_users", false, CurrentUser);
}
public void ExecuteTextToDataSetWithoutParameters()
{
Framework.DataServices.CommonDatabase commonDatabase =
new Framework.DataServices.CommonDatabase(ConnectionName, ConnectionString, ProviderName);
DataSet dsResult = commonDatabase.ExecuteDataSet(
CommandType.Text,
"SELECT * FROM Users", false, CurrentUser);
}
public void ExecuteStoredProcedureToDataSetWithIntParameters()
{
Framework.DataServices.CommonDatabase commonDatabase =
new Framework.DataServices.CommonDatabase(ConnectionName, ConnectionString, ProviderName);
DataSet dsResult = commonDatabase.ExecuteDataSet(
CommandType.StoredProcedure,
"sp_select_users", false, CurrentUser,
commonDatabase.Parameters.Create("@Children", DbType.Int32, ParameterDirection.Input, 1));
}
public void FailedToExecutStoredProcedureToDataSetInWrongStoredProcedure()
{
Framework.DataServices.CommonDatabase commonDatabase =
new Framework.DataServices.CommonDatabase(ConnectionName, ConnectionString, ProviderName);
DataSet dsResult = commonDatabase.ExecuteDataSet(
CommandType.StoredProcedure,
"sp_select_users_fail", false, CurrentUser,
commonDatabase.Parameters.Create("@BirthDate", DbType.Date, ParameterDirection.Input, DateTime.Now),
commonDatabase.Parameters.Create("@Children", DbType.Int32, ParameterDirection.Input, 1));
}
public void ExecuteStoredProcedureToDataSetWithDefaultOutputParameters()
{
Framework.DataServices.CommonDatabase commonDatabase =
new Framework.DataServices.CommonDatabase(ConnectionName, ConnectionString, ProviderName);
DataSet dsResult = commonDatabase.ExecuteDataSet(
CommandType.StoredProcedure,
"sp_select_users_outputparameters", true, CurrentUser);
Assert.AreEqual(commonDatabase.ExecutionStatus.ErrorNumber, 10);
Assert.AreEqual(commonDatabase.ExecutionStatus.ErrorDescription, "User: "******" - Number: 10");
Assert.AreEqual(commonDatabase.ExecutionStatus.CurrentUser, CurrentUser);
}
public void ExecuteTextToDataSetWithIntParameters()
{
Framework.DataServices.CommonDatabase commonDatabase =
new Framework.DataServices.CommonDatabase(ConnectionName, ConnectionString, ProviderName);
Framework.DataServices.ParameterConfiguration parameterConfig =
new Framework.DataServices.ParameterConfiguration(commonDatabase.GetProvider());
DataSet dsResult = commonDatabase.ExecuteDataSet(
CommandType.Text,
"SELECT * FROM Users WHERE Children > @Children", false, CurrentUser,
parameterConfig.Create("@Children", DbType.Int32, ParameterDirection.Input, 0));
}
public void FailedToExecuteTextToDataSetInWrongFieldName()
{
Framework.DataServices.CommonDatabase commonDatabase =
new Framework.DataServices.CommonDatabase(ConnectionName, ConnectionString, ProviderName);
Framework.DataServices.ParameterConfiguration parameterConfig =
new Framework.DataServices.ParameterConfiguration(commonDatabase.GetProvider());
DataSet dsResult = commonDatabase.ExecuteDataSet(
CommandType.Text,
"SELECT * FROM Users_Fail " +
" WHERE Children > @Children " +
" AND BirthDateFail < @BirthDate ", false, CurrentUser,
parameterConfig.Create("@Children", DbType.Int32, ParameterDirection.Input, 1),
parameterConfig.Create("@BirthDate", DbType.Date, ParameterDirection.Input, DateTime.Now));
}