public static List <CarModelClass> GetIndivCarData() { CarModelClass CarInfo = new CarModelClass(); var CarInfoList = new List <CarModelClass>(); //Assignment 2 //Get Car information from the CarDB and the connection string details from Web.Config file DataSet dsCarDataReport = new DataSet(); dsCarDataReport = CarDataClass.GetCarDataUsingDbWithConfig(); //transfer Dataset details to List Object if (dsCarDataReport.Tables.Count > 0) { CarInfoList = dsCarDataReport.Tables[0].AsEnumerable().Select(m => new CarModelClass { //Left is Model, Right is CarDB columns Model = Convert.ToString(m["Model"]), Description = Convert.ToString(m["Description"]), Horsepower = Convert.ToString(m["Horsepower"]) }).ToList(); } //Business Logic return(CarInfoList); }
public DataSet GetCarDataUsingDbWithConfig() { return(CarDataClass.GetCarDataUsingDbWithConfig()); }