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);
}
