public DataSet GetDataSet(string storedProcName, List <DbParameter> inputParameters, ServerTypes serverType)
{
// checks for stored procedure name
// if not specified then throw exception
if (string.IsNullOrEmpty(storedProcName))
{
throw new MissingMemberException("Stored procedure name not specified.");
}
// create instance of data access factory
IFrameworkDataAccessFactory factory = DbInstance.CurrentInstance;
// create connection object for database access.
string connectionString = ServerManager.Instance.GetConnectionString(serverType);
IDbConnection connection = factory.CreateConnection(connectionString);
IDbTransaction transaction = null;
DataSet result = new DataSet();
try
{
connection.Open();
transaction = connection.BeginTransaction();
// create custom accessor instance
ICustomDataAccessor customAccessor = factory.CreateCustomAccessor <ICustomDataAccessor>(transaction);
result = customAccessor.GetDataSet(storedProcName, inputParameters);
transaction.Commit();
transaction = null;
}
catch (SqlException sx)
{
if (sx.Number == DatabaseErrorConstants.DATA_MISMATCH_ERROR)
{
// Throw custom exception
throw new DataMismatchException(sx.Message, sx);
}
else
{
throw sx;
}
}
finally
{
// if transaction exits then rollback transaction
if (transaction != null)
{
transaction.Rollback();
}
// close connection if it is open
if (connection.State == ConnectionState.Open)
{
connection.Close();
}
}
return(result);
}
/// <summary>
/// Generic data retrieval method for datasets, It fill result to typed dataset
/// </summary>
/// <typeparam name="T">
/// Typed dataset that should implement IDataSet interface.
/// </typeparam>
/// <param name="typedDataSet">
/// Typed dataset instance, stored procedure name property
/// of this instance should have valid data.
/// </param>
/// <returns>
/// A typed dataset instance, filled with query execution result.
/// </returns>
public T GetDataSet <T>(T typedDataSet) where T : DataSet, IDataSet
{
// checks for stored procedure name in given dataset,
// if not specified then throw exception
if (string.IsNullOrEmpty(typedDataSet.StoredProcedureName))
{
throw new MissingMemberException("Stored procedure name not specified in given dataset instance");
}
// create instance of data access factory
IFrameworkDataAccessFactory factory = DbInstance.CurrentInstance;
// create connection object for database access.
string connectionString = ServerManager.Instance.GetConnectionString(typedDataSet.DatabaseServerType);
IDbConnection connection = factory.CreateConnection(connectionString);
try
{
connection.Open();
// create custom accessor instance
ICustomDataAccessor customAccessor = factory.CreateCustomAccessor <ICustomDataAccessor>(connection);
// call generic get method.
typedDataSet = customAccessor.GetDataSet <T>(typedDataSet);
}
finally
{
// close connection if it is open
if (connection.State == ConnectionState.Open)
{
connection.Close();
}
}
return(typedDataSet);
}