How to get rank from full-text search query with Linq to SQL?
- by Stephen Jennings
I am using Linq to SQL to call a stored procedure which runs a full-text search and returns the rank plus a few specific columns from the table Article. The rank column is the rank returned from the SQL function FREETEXTTABLE(). I've added this sproc to the data model designer with return type Article.
This is working to get the columns I need;…