UserDAO

using com.sample.model;
using com.tg.framework.core;
using System.Collections.Generic;

namespace com.sample.dao
{
    /// <summary>
    /// This is the user DAO class. 
    /// </summary>
    public class UserDAO : BaseDAO
    {
        #region Constructors and Destructors
        /// <summary>
        /// Initializes a new instance of the UserDAO class       
        /// </summary>
        public UserDAO() : base()
        {
            SetDataModel(new User());
        }

        /// <summary>
        /// Initializes a new instance of the UserDAO class with regionName      
        /// </summary>
        /// <param name="regionName">parameter -- region name</param>
        public UserDAO(string regionName) : base(regionName)
        {
            SetDataModel(new User());
        }
        #endregion

        /// <summary>
        /// get user list by top 5
        /// </summary>
        /// <returns>the list of user</returns>
        public  List<IDataModel> GetTop5()
        {
            const string sql = "select top 5 * from [User] ";
            return this.GetBySql(sql);
        }

        /// <summary>
        /// get user top list by parameter
        /// </summary>
        /// <param name="topRecords">parameter -- topRecords</param>
        /// <returns>the list of user</returns>
        public List<IDataModel> GetTopRecords(int topRecords)
        {
            string sql = "select top " + topRecords + " * from [User] ";
            return this.GetBySql(sql);
        }
    }
}