/// <summary> /// This is a sample specific finder method for Entity1. /// If you want to delete or rename the method think about changing the xml in the BDC model file as well. /// </summary> /// <param name="id"></param> /// <returns>Entity1</returns> public static GreetingEvent ReadItem(string id) { var greetingEvent = new GreetingEvent(); var db2Connection = GetSqlConnection(); db2Connection.Open(); var sqlCommand = new DB2Command { CommandText = string.Format("SELECT * FROM GREETING WHERE deptno = '{0}'", id), Connection = db2Connection }; var sqlDataReader = sqlCommand.ExecuteReader(CommandBehavior.CloseConnection); if (sqlDataReader.Read()) { greetingEvent.DeptNo = sqlDataReader[0].ToString(); greetingEvent.Greeting = sqlDataReader[1].ToString(); } db2Connection.Dispose(); return greetingEvent; }
/// <summary> /// This is a sample finder method for Entity1. /// If you want to delete or rename the method think about changing the xml in the BDC model file as well. /// </summary> /// <returns>IEnumerable of Entities</returns> public static IEnumerable<GreetingEvent> ReadList() { var db2Connection = GetSqlConnection(); var trainingEvents = new List<GreetingEvent>(); db2Connection.Open(); var db2Command = new DB2Command { Connection = db2Connection, CommandText = "SELECT * FROM GREETING", }; var sqlDataReader = db2Command.ExecuteReader(CommandBehavior.CloseConnection); while (sqlDataReader.Read()) { var trainingEvent = new GreetingEvent { DeptNo = sqlDataReader[0].ToString(), Greeting = sqlDataReader[1].ToString() }; trainingEvents.Add(trainingEvent); } db2Connection.Dispose(); return trainingEvents; }