private Entities GetList(SqlDataReader reader) { Entities entities = new Entities(); MajorCourse majorCourse; while (reader.Read()) { majorCourse = new MajorCourse(); majorCourse.MajorCourseId = reader.GetInt32(0); majorCourse.MajorId = reader.GetInt32(1); majorCourse.CourseId = reader.GetInt32(2); entities.Add(majorCourse); } return(entities); }
public Entity Add(Entity entity) { MajorCourse majorCourse = entity as MajorCourse; string sql = "insert into MajorCourse(MajorId,CourseId)values(@MajorId,@CourseId);select @MajorCourseId = @@Identity"; SqlParameter prmMajorId = new SqlParameter("@MajorId", SqlDbType.Int) { Value = majorCourse.MajorId }; SqlParameter prmCourseId = new SqlParameter("@CourseId", SqlDbType.Int) { Value = majorCourse.CourseId }; SqlParameter prmMajorCourseId = new SqlParameter("@MajorCourseId", SqlDbType.Int) { Direction = ParameterDirection.Output }; ExecuteNoQuery(sql, prmMajorId, prmCourseId, prmMajorCourseId); majorCourse.MajorCourseId = (int)prmMajorCourseId.Value; return(majorCourse); }