title: How to search for FirstName + Lastname from sql data base when input is full name with entities in c#?
body: <p>I have a data base table with columns FirstName and Last Name and I have to make a search where the input is the full name. I'm working in c# with entities framework. I'm using the following code: </p>
  
  <pre><code>  var user = context.User.Where(i =&gt; i.FirstName + " " + i.LastName == fullName)
  </code></pre>
  
  <p>Is there a better or more elegant way of doing this?</p>
  
  <p>I thought of doing split to the fullName but there are first names and last names made of more than one word which seems to make the search very awkward.</p>