Is there a better/faster way to access raw data?
<p>This isn't related to a particular issue BUT is a question regarding "best practise".</p>

<p>For a while now, when I need to get data straight from the database I've been using the following method - I was wondering if there's a faster method which I don't know about?</p>

<pre><code>DataTable results = new DataTable();
using (SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["Name"]))
{
    connection.Open();
    using (SqlCommand command = new SqlCommand("StoredProcedureName",connection))
    {
      command.CommandType = CommandType.StoredProcedure;
      /*Optionally set command.Parameters here*/
      results.Load(command.ExecuteReader());
    }
}
/*Do something useful with the results*/
</code></pre>
