I find it preferable to write the data access as a separate layer:
#region " ListAll "
/// <summary>
/// Select list of all on ChangeLog table
/// </summary>
/// <remarks>
/// This code was autogenerated on 29Jun2009
/// </remarks>
/// <returns>dataset of ChangeLog </returns>
public static DataSet ListAll()
{
return CommonData.GetDataSet("usp_ChangeLogListAll");
}
#endregion
Don't forget to click "Mark as Answer" on the post that helped you.
This credits that member, earns you a point and marks your thread as Resolved so we will all know you have been helped.