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