private List <MobileDeviceColor> getMobileDeviceColor(String MDID) { List <MobileDeviceColor> mobileDeviceColors = new List <MobileDeviceColor>(); MobileDeviceColor mobileDeviceColor; var rawSqlCmd = db.Database.Connection.CreateCommand(); rawSqlCmd.CommandText = @"SELECT MobileDeviceColor.* From MobileDeviceColor WHERE MobileDeviceColor.MD# = @ID;"; rawSqlCmd.Parameters.Add(new SqlParameter("@ID", MDID)); rawSqlCmd.Connection.Open(); var reader = rawSqlCmd.ExecuteReader(); while (reader.Read()) { mobileDeviceColor = new MobileDeviceColor(); mobileDeviceColor = MyData.getMobileDeviceColor(reader); mobileDeviceColors.Add(mobileDeviceColor); } rawSqlCmd.Connection.Close(); return(mobileDeviceColors); }
public static MobileDeviceColor getMobileDeviceColor(System.Data.Common.DbDataReader reader) { MobileDeviceColor mobileDeviceColor = new MobileDeviceColor(); mobileDeviceColor.MD_ = reader.GetString(reader.GetOrdinal("MD#")); mobileDeviceColor.Color = reader.GetString(reader.GetOrdinal("Color")); return(mobileDeviceColor); }