title: Confused between SqlCommand & SqlDataAdapter
body: <p>everyone I am a student and new to .NET and specially MVC3 development but for one of my project I’ve to work over it and so going through the learning phase
  Issue and confusion I am facing is regarding DB-Connectivity, whast I leanree d regarding retrieving records from a database is something like this:</p>
  
  <pre><code>//Method One:
  var conn = new SqlConnection(conString.ConnectionString);
  const string cmdString = "Select * FROM table";
  var cmd = new SqlCommand(cmdString, conn); 
  var mySqlDataAdapter = new SqlDataAdapter(cmd);
  mySqlDataAdapter = new SqlDataAdapter(cmd);
  mySqlDataAdapter.Fill(myDataSet, "design");
  // making a new SqlCommand object with stringQuery and SqlConnection object THEN a new SqlDataAdapter object with SqlCommand object and THEN filling up the table with the resulting dataset.
  </code></pre>
  
  <p>But while I was  checking out <a href="http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqldataadapter.aspx" rel="noreferrer">MSDN Library</a> i found out that SqlDataAdapter offers a constructors SqlDataAdapter(String, String) that directly takes a SelectCommand and a connection string to initiate thus skipping the role of SqlCommand in between, like this:</p>
  
  <pre><code>//Method Two:
  var conn = new SqlConnection(conString.ConnectionString);
  const string cmdString = "Select * FROM table";
  var mySqlDataAdapter = new SqlDataAdapter(cmdString, conn);
  mySqlDataAdapter.Fill(myDataSet, "design");
  </code></pre>
  
  <p>Looks short and pretty to me, But I am confused here that if this is possible in this way then why most of the books/Teachers goes by earlier (SqlCommand’s way).</p>
  
  <ul>
  <li>What’s actually the difference between SqlCommand and SqlDataAdapter?</li>
  <li>Which method is better One or Two?</li>
  <li>Am afraid of I am using a shortcut in method two that could affect security or performance wise?</li>
  </ul>
  
  <p>Apologising in advance if I sound very newbie or blurred! Will appreciate any help that could clear my concepts up! Thankyou! :)</p>