Пример #1
0
        public static InterestedIns GetDistinctInterests()
        {
            InterestedIns iterests = null;

            // get a configured DbCommand object
            DbCommand comm = DbAct.CreateCommand();
            // set the stored procedure name
            comm.CommandText = "up_GetDistinctInterests";

            // execute the stored procedure
            DataTable dt = DbAct.ExecuteSelectCommand(comm);

            // was something returned?
            if (dt != null && dt.Rows.Count > 0)
            {
                iterests = new InterestedIns();
                iterests.AddRange(dt.Rows.Cast<DataRow>()
                                         .Select(dr => new InterestedIn(
                                                FromObj.IntFromObj(dr["interestedInID"])))
                                         .Where(iterest => iterest.InterestedInID != 0));
            }

            return iterests;
        }