public static void setCurrentVehicle(int vehicleID) { //Get vehicle make / model var context = new seleniumScrapeEntities(); globalMake = (from v in context.tblVehicles where v.Vehicle_ID_Pk == vehicleID select v.Vehicle_Make).First(); globalModel = (from db in context.tblVehicles where db.Vehicle_ID_Pk == vehicleID select db.Vehicle_Model).First(); //var makeList = makeQuery.ToList(); // IQueryable<string> modelQuery = from db in context.tblVehicles // where db.Vehicle_ID_Pk == vehicleID // select db.Vehicle_Model; //var modelList = modelQuery.ToList(); // var vehicleData = new Vehicle() // { // vehicleMake = makeList[0], // vehicleModel = modelList[0] // }; }
public void SaveToDB(tblVehicle vehicle) { var ctx = new seleniumScrapeEntities(); ctx.tblVehicles.AddObject(vehicle); ctx.SaveChanges(); }
public int InsertSearchSession(tblSearchSession searchSession) { // Create database context. var ctx = new seleniumScrapeEntities(); ctx.tblSearchSessions.AddObject(searchSession); ctx.SaveChanges(); return searchSession.Search_Session_ID_PK; }
private int GetHtmlTableId() { var ctx = new seleniumScrapeEntities(); var htmlTableId = (from h in ctx.tblHtmls where h.html_id_pk > 0 orderby h.html_id_pk descending select h.html_id_pk).FirstOrDefault(); return htmlTableId; }
public IQueryable<DataRow> getRow() { var ctx = new seleniumScrapeEntities(); var query = from hr in ctx.tblHtmlRows where hr.Search_Session_ID_fk == 500 select new DataRow() { id = hr.html_row_id_PK, dataRowHtml = hr.html_row_data }; return query; }