We have an MVC code-first EF 6 solution implemented and we now need to create an advanced search feature within our database. We would like to use Full-Text Search and a stored procedure but I am unsure how this would work with code first. Does this sounds
correct?
1. Set up a Full-Text index on each searchable column
2. Create stored proc in Management Studio
3. Copy this sql script to a file within a SQL folder in our MVC solution
4. Create a migration and add this stored proc to our data model (read from file) - using CreateStoredProcedure
Any advice welcome.