Hi All
little assistance here with my query using dapper, been getting error Message = "ORA-00936: missing expression\n" on my query. I would like to know what am I missing here?
- public class LocationDto
- {
- public int LocationId { get; set; }
- public int RouteId { get; set; }
- public string StartTime { get; set; }
- public string Location { get; set; }
- }
-
- using (OracleConnection connection = new OracleConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString))
- {
- try {
- var x = connection.QueryAsync("Select ROUTE_ID as RouteId, SCHEDULE_STOP as Location, START_TIME as StartTime From SCHEDULE WHERE ROUTE_ID = @Id", new { input.RouteId }).Result.ToList();
-
- }
- catch (Exception ex)
- {
-
- }
- }