title: Implementing a login using ASP.NET C# with SQL database holding username and password
body: <p>Please can someone help me in the right direction to achieving a modern login, using information from a database?</p>
  
  <p>I have a Microsoft SQL database that holds the username and password information.</p>
  
  <p>I wish to take the user's credentials, authentication and then start a session for them.</p>
  
  <p>I'm aware of how to do a login using PHP and best practices such as <code>hashing</code> and <code>salting</code>, re-creating the session id upon login, but the Internet is failing me on this one for ASP.NET.  The results are linking me to old ways of doing things using ADO.</p>
  
  <p>There's built in tried and tested Classes for doing authentication aren't there, but how do I make use of them with an SQL database?</p>