TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Anele Ngqandu
1.3k
429
27.8k
Issues with Dapper query syntax
Nov 11 2020 4:57 AM
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
; }
}
// Query Below
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)
{
}
}
Reply
Answers (
1
)
sql OLAP using PIVOT
Extracting string after and before a character '-' or '<'