Using parameters in ESql
I'm using LINQPad to help me create ESQL queries (it saves me a lot of building time! I was happy to find this option).
But, I'd like to add parameters. Strings are not a problem, but I also have to select on guids and datetimeoffsets.
An example from a query:
SELECT VALUE distinct MainTable
FROM DBEntities.MainTable as MainTable
WHERE MainTable.SomeId = @SomeGuidParameter
The error I'm getting is "The command parameter 'SomeGuidParameter' was not defined". But I can't find anywhere where to define it...
But, I'd like to add parameters. Strings are not a problem, but I also have to select on guids and datetimeoffsets.
An example from a query:
SELECT VALUE distinct MainTable
FROM DBEntities.MainTable as MainTable
WHERE MainTable.SomeId = @SomeGuidParameter
The error I'm getting is "The command parameter 'SomeGuidParameter' was not defined". But I can't find anywhere where to define it...