public List <P_GROUP_MEMBER> GetGroupMembersByType(GroupTypeEnum GroupType) { List <P_GROUP_MEMBER> rtnData; var sqlServerTemplate = sqlServerTemplFactory.CreateDbTemplate(); using (var conn = sqlServerTemplate.GetSqlConnection()) { conn.Open(); rtnData = sqlServerTemplate.Load <P_GROUP_MEMBER>( "SELECT ID, GroupType, UserId, UserName, CreateDate, CreateUserId FROM P_GROUP_MEMBER WHERE (GroupType = @GroupType) ", new SqlParameter[] { SqlParameterFactory.GetSqlParameter("@GroupType", GroupType.ToString("D")) }); } return(rtnData); }