We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see our documentation.
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
CONTAINSTABLE is being escaped when I'm trying to use join. It seems like a JoinRaw option would be appropriate here?
var query = new Query("Activity as a") .Join("CONTAINSTABLE(Activity, *, @query) as s", "a.Id", "s.Key") .OrderByDesc("s.Rank")
SELECT * FROM [Activity] AS [a] INNER JOIN [CONTAINSTABLE(Activity, *, @query)] AS [s] ON [a].[Id] = [s].[Key] ORDER BY [s].[Rank] DESC
I really want it to output:
SELECT * FROM [Activity] AS [a] INNER JOIN CONTAINSTABLE(Activity, *, @query) AS [s] ON [a].[Id] = [s].[Key] ORDER BY [s].[Rank] DESC
Is there a current workaround for this?
The text was updated successfully, but these errors were encountered:
Currently there is no support for XJoinRaw methods, but you can use the FromRaw to achieve this, Check this example on SqlKata Playground
FromRaw
Sorry, something went wrong.
#128 #475
No branches or pull requests
CONTAINSTABLE is being escaped when I'm trying to use join. It seems like a JoinRaw option would be appropriate here?
I really want it to output:
Is there a current workaround for this?
The text was updated successfully, but these errors were encountered: