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