Stored Procedure in Code-First RRS feed

  • Question

  • 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. 

    Wednesday, June 8, 2016 1:51 PM