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