private List <MobileDeviceReview> getMobileDeviceReview(String MDID)
{
List <MobileDeviceReview> mobileDeviceReviews = new List <MobileDeviceReview>();
MobileDeviceReview mobileDeviceReview;
var rawSqlCmd = db.Database.Connection.CreateCommand();
rawSqlCmd.CommandText = @"SELECT MobileDeviceReview.*
From MobileDeviceReview
WHERE MobileDeviceReview.MD# = @ID;";
rawSqlCmd.Parameters.Add(new SqlParameter("@ID", MDID));
rawSqlCmd.Connection.Open();
var reader = rawSqlCmd.ExecuteReader();
while (reader.Read())
{
mobileDeviceReview = new MobileDeviceReview();
mobileDeviceReview = MyData.getMobileDeviceReview(reader);
mobileDeviceReviews.Add(mobileDeviceReview);
}
rawSqlCmd.Connection.Close();
return(mobileDeviceReviews);
}
public static MobileDeviceReview getMobileDeviceReview(System.Data.Common.DbDataReader reader)
{
MobileDeviceReview mobileDeviceReview = new MobileDeviceReview();
mobileDeviceReview.MD_ = reader.GetString(reader.GetOrdinal("MD#"));
mobileDeviceReview.ReviewURL = reader.GetString(reader.GetOrdinal("ReviewURL"));
mobileDeviceReview.ReviewType = reader.GetString(reader.GetOrdinal("ReviewType"));
mobileDeviceReview.ReviewName = reader.GetString(reader.GetOrdinal("ReviewName"));
mobileDeviceReview.ReviewMainSite = reader.GetString(reader.GetOrdinal("ReviewMainSite"));
return(mobileDeviceReview);
}
