ASP.NET Optimistic Concurrency Control

using System;
using System.Collections;
using System.Data;
using System.Data.SqlClient;
using Microsoft.ApplicationBlocks.Data;

namespace Concurrency.BLL
{
	/// <summary>
	/// Represents a supplier
	/// </summary>
	public class Supplier
	{

		#region Constructors

		/// <summary>
		/// Initializes a new instance of the supplier class
		/// </summary>
		public Supplier()
		{
		}

		/// <summary>
		/// Initializes a new instance of the supplier class
		/// </summary>
		/// <param name="id">Supplier id</param>
		/// <param name="name">Supplier name></param>
		public Supplier(int id, string name)
		{
			_id = id;
			_name = name;
		}

		#endregion

		#region Methods

		/// <summary>
		/// Gets the suppliers
		/// </summary>
		/// <returns>Suppliers list</returns>
		public IList GetSuppliers()
		{
			IList suppliers = new ArrayList();

			// Get the data reader
			using (SqlDataReader dr = SqlHelper.ExecuteReader(Util.ConnectionString, CommandType.StoredProcedure , "SuppliersList"))
			{
				while (dr.Read())
				{
					// Get data for the product
					Supplier supplier = new Supplier(	dr.GetInt32(0), dr.GetString(1));
				
					// Add the category to the collection
					suppliers.Add(supplier);
				}
			}
			return suppliers;
		}

		#endregion

		#region Properties

		private int _id;
		private string _name;

		public int ID
		{
			get { return _id; }
			set { _id = value; }
		}

		public string Name
		{
			get { return _name; }
			set { _name = value; }
		}

		#endregion

	}
}