{"action":"closed","issue":{"url":"https://api.github.com/repos/aspnet/EntityFramework/issues/4119","labels_url":"https://api.github.com/repos/aspnet/EntityFramework/issues/4119/labels{/name}","comments_url":"https://api.github.com/repos/aspnet/EntityFramework/issues/4119/comments","events_url":"https://api.github.com/repos/aspnet/EntityFramework/issues/4119/events","html_url":"https://github.com/aspnet/EntityFramework/issues/4119","id":122740296,"number":4119,"title":"Rewrite query to achieve full text search using EF7.","user":{"login":"AshishMoradiya","id":16162527,"avatar_url":"https://avatars.githubusercontent.com/u/16162527?v=3","gravatar_id":"","url":"https://api.github.com/users/AshishMoradiya","html_url":"https://github.com/AshishMoradiya","followers_url":"https://api.github.com/users/AshishMoradiya/followers","following_url":"https://api.github.com/users/AshishMoradiya/following{/other_user}","gists_url":"https://api.github.com/users/AshishMoradiya/gists{/gist_id}","starred_url":"https://api.github.com/users/AshishMoradiya/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/AshishMoradiya/subscriptions","organizations_url":"https://api.github.com/users/AshishMoradiya/orgs","repos_url":"https://api.github.com/users/AshishMoradiya/repos","events_url":"https://api.github.com/users/AshishMoradiya/events{/privacy}","received_events_url":"https://api.github.com/users/AshishMoradiya/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":2,"created_at":"2015-12-17T14:02:13Z","updated_at":"2016-01-07T18:46:21Z","closed_at":"2016-01-07T18:46:21Z","body":"Hello,\r\n\r\nI am developing MVC6 application with EF7, I want to use full text search(SQL server feature). full text feature requires special type of query with 'CONTAINS' or 'FREETEXT' keyword. For more details see [this](https://msdn.microsoft.com/en-us/library/ms142583.aspx)\r\n\r\nEF does not generate query that is supported by full text search. that is why I need to rewrite query before it goes to execution to SQL Server. Previously with EF6 I was using [Interception](http://entityframework.codeplex.com/wikipage?title=Interception) to rewrite the query. See [example here](http://www.entityframework.info/Home/FullTextSearch).\r\n\r\nI have noticed that IDbCommandInterceptor interface is removed from EF7. So, I need to find out way for EF7. I have seen there are many classes to handle raw SQL functionality in DI. we might need put something on DI? (see attached picture)\r\n![img_17122015_214614](https://cloud.githubusercontent.com/assets/16162527/11870128/ed35b1dc-a4ea-11e5-844b-2ffe65231117.png)\r\n\r\nI have also considered [RelationalCommand](https://github.com/aspnet/EntityFramework/pull/3210) and [SqlStatementExecutor](https://github.com/aspnet/EntityFramework/pull/3399). RelationalCommand has similar functionality. we want to customize it to rewrite query.\r\nAny solution to achieve this goals?\r\n\r\nThank you,\r\nAshish\r\n\r\n\r\n"}}