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