Calling Stored procedures with Enterprise library C#

Step by step tutorial for creating Data Access class which will call a stored procedure using Enterprise library.

1. Create a C# class and name it as DataAccess
2. Add references to enterprise library dlls.
3. Add the below code in the class file.

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using Microsoft.Practices.EnterpriseLibrary.Data;
using System.Data.Common;

namespace DataAccess
{
public class DataAccess
{
#region Stored Procs
private const string SQL_SELECT_EMPLOYEES = “usp_select_employees”;
#endregion
DataSet ds = new DataSet();
Database db = DatabaseFactory.CreateDatabase(“ConnString”);

public DataTable GetEmployees(string empNo)
{
try
{
DbCommand dbCommand = db.GetStoredProcCommand(SQL_SELECT_EMPLOYEES);
db.AddInParameter(dbCommand, “EmployeeNumber”, DbType.String, empNo);
db.LoadDataSet(dbCommand, ds, “Employees”);
}
catch (Exception myException)
{
}
return ds.Tables["Employees"];
}
}
}

4. Next, for Calling GetEmployees stored proc from your code

DataAccess.DataAccess objDirectory = new DataAccess.DataAccess();
DataTable SuprEmptable = objDirectory.GetEmployees(empId);