Install-Package Nice.DataAccess -Version x.x.x      

   DataUtil.Create(new DatabaseConfig()
   {
      ConnString = Configuration["ConnString"],
      ProviderName = Configuration["ProviderName"]
   });

 [Table(Name = "tbl_user_info")]        
 public class UserInfo:TEntity       
 {      
       [Id(GenerateType = IdGenerateType.Assign)]   
       public string UserId { get; set; }   
       public string UserName { get; set; }  
       ........
       [Column(IsReadOnly = true)]
       public DateTime CreateTime { get; set; }
       [Valid(1, 0)]
       [Column(Name = "nState")]
       public byte NState { get; set; }
       ........
  }          

private GeneralDAL<UserInfo> dal = DALFactory<UserInfo>.Create();   

 public bool Insert(UserInfo entity)
 {
     return dal.Insert(entity);
 }
 public bool Update(UserInfo entity)
 {
     return dal.Update(entity);
 }
 public bool UpdateState(UserInfo entity)
 {
    return dal.Update(entity, o => o.NState, o => o.ModifyTime);
 }
 public bool Delete(string UserId)
 {
    return dal.Delete(UserId);
 }
 public bool VirtualDelete(string UserId)
 {
     return dal.VirtualDelete(UserId);
 }
 public UserInfo Get(string UserId)
 {
     return dal.Get(UserId);
 }
 public UserInfo GetByName(string UserName)
 {
    return dal.Get(o => o.UserName == UserName);
 }
 public IList<UserInfo> GetList()
 {
    return dal.GetList();
 }
 public IList<UserInfo> GetList(PageInfo page)
 {
    return dal.GetList(page);
 }
 public bool IsExists(string PropertyName, object PropertyValue, object IdValue)
 {
     return dal.IsExist(PropertyName, PropertyValue, IdValue);
 }

 //private  QueryDAL<InfraElementInfo> query = new QueryDAL<InfraElementInfo>();
 private QueryDAL<InfraElementInfo> query = QueryDALFactory<InfraElementInfo>.Create();
 
 public IList<InfraElementInfo> GetListByRoleId(int RoleId)
 {
       StringBuilder sb = new StringBuilder();
       sb.Append(" select * from infra_element_info e,sys_role_data r ");
       sb.Append(" WHERE e.ElementId=r.DataId and r.DataType=1");
       sb.Append(" and r.RoleId=@RoleId");

       return query.GetListBySQL(sb.ToString(),new IDataParameter[] 
       {
          DataUtil.GetDataHelper().CreateParameter("@RoleId",RoleId)
       });
 }
 
 public IList<InfraElementInfo> GetListByRoleId(int RoleId)
 {
       StringBuilder sb = new StringBuilder();
       sb.Append(" select * from infra_element_info e,sys_role_data r ");
       sb.Append(" WHERE e.ElementId=r.DataId and r.DataType=1");
       sb.Append(" and r.RoleId=?");

       return query.GetListBySQL2(sb.ToString(),new object[] { RoleId });
 }