title: ASP.NET C# Search in a SQL Server Database Table
body: <p>I'm building a portal, which isn't a blogging engine, but is quite similar to one. In SQL Server, I have a database containing a table that is the basis for the "posts". This Posts table includes the following columns: </p>
  
  <ul>
  <li>ID</li>
  <li>Author(s)</li>
  <li>Tags</li>
  <li>Title</li>
  <li>Markdown post content</li>
  </ul>
  
  <p>This is my first time building such a portal, and I'd like to implement some sort of <strong>ASP.NET search</strong> over these rows, preferably using all of the properties (columns), except for the ID one. Also, in the long run, I'm considering the possibility of implementing a search of this and comments to those posts, which would be stored in a different table.</p>
  
  <p><strong>Are there any open-source implementations or example code online for accomplishing this search</strong>? If not, how can I get started? Could you point me towards some tutorials w/ sample code on how to accomplish this with ASP.NET and C#? Also, has Google (or some other company) created any things for this?</p>
  
  <p>I hope my question isn't too broad or vague. Thanks in advance!</p>