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