public void Convert() { sqlDbContextEF context = new sqlDbContextEF(); var query = context.agvStationTestFlow .Select(a => new agvStationTestFlow { Id = a.Id, Dest_Station = a.Dest_Station }).ToList(); ToDataTable(query); }
public agvStation_Info GetStation(string destination) { using (sqlDbContextEF privatedbContext = new sqlDbContextEF()) { var query = privatedbContext.agvStation_Info .Where(x => x.Name.Equals(destination, StringComparison.OrdinalIgnoreCase)) .FirstOrDefault(); if (query != null) { return(query); } return(null); } }