Skip to main content

Full Text Search using Entity Framework

By
I've been working on a project where I needed to implement full time search on one table. My current solution was based on SQL Server db and Entity Framework 6. I had two choices implement the full text search in C# or use the functionality available in SQL server, since the data was stored in SQL Server the obvious solution was to use the built in full text search.
How this works:
1. You need to activate and configure the full text search: Activate on the sql server table by using SSMS, and specify which columns are going to be included.
2. To perform a full text search in a T-SQL query you have the choice between 2 Boolean functions: Contains and Freetext or two functions that returns 2 columns tables. In my case I need a function that could be used in a where clause (Boolean), and decided to use 'Contains'. For more details about the difference between Freetext and contains have a look at this article.
3. I need to instruct EF6 to generate a particular T-SQL statement when I want to make a full text search on a particular column. Luckily there is a way to perform this in EF6, by using a custom interceptor (A class that implements:IDbCommandInterceptor). You can find below a link that describes one implementation, in my case I just made a small alteration to the code in the RewriteFullQuery function, where I change the value of the parameter to split a sentence into multiple word: "news paper" ==> '"news" AND "paper"'

Labels:

Comments

Post a Comment

Popular posts from this blog

Understanding Monte Carlo Simulation C#

By
This method has been introduced to resolve numerically complex physics problems, such as neutron diffusion, that were to complex for an analytical solution. This method is based on generating random values for parameters or inputs to explore the behaviour of complex systems, now this method is used in various domains like: Engineering, science and finance. These approaches tend to follow a particular pattern: 1- Define a domain of possible inputs. 2- Generate inputs randomly from the domain using a certain specified probability distribution. 3- Perform a deterministic computation using the inputs. 4- Aggregate the results of the individual computations into the final result. Here is an example of using Monte Carlo simulation to approximate the value of Pi: In this case we have 2 parameters x,y which defines a location in the plane (e.g The picture on the left). We will calculate the probability to have a point in the 1/4 Circle area, with a radius of 1. To calculate Pi we...
Post a Comment
Read more

Twitter API and Microsoft Text Analytics API in Python

By
Since we are getting closer to the French presidential election, and that I'm working on a project that involves using social media API and sentiment analysis, I've decide to post an example that will use these technologies to try and give an idea about each major candidate popularity. Solution description: 1. Collect social media information related to each candidate: For this example the main source is Twitter. 2. Extract sentiment for each Candidate from the Twitter posts collected previously. Implementation: For a quick implementation I decided to use python, but I'll definitely post a C# version as well. Code: 1. Twitter Client code: The code is pretty basic, I'm streaming the posts to a text file in son, by applying a list of filters; the names of the candidates I've decided to include: #Import the necessary methods from tweepy library from tweepy.streaming import StreamListener from tweepy import OAuthHandler from tweepy import Stream #Vari...
Post a Comment
Read more