title: VB.NET SQLClient Table Names are ambiguous
body: <p>Here is some simple sample code that demonstrates how I am getting results back from SQL Server:</p>
  
  <pre><code>Dim dtbTable As System.Data.DataTable
  Dim sdaDataAdapter As New System.Data.SqlClient.SqlDataAdapter()
  sdaDataAdapter = New System.Data.SqlClient.SqlDataAdapter("SELECT * FROM A; SELECT * FROM B", Connection)
  
  dtbTable = New System.Data.DataTable()
  dtbTable.Locale = System.Globalization.CultureInfo.InvariantCulture
  sdaDataAdapter.Fill(dtbTable)
  
  sdaDataAdapter = Nothing
  objCommandBuilder = Nothing
  </code></pre>
  
  <p>In .Net, table A will come out TABLE and Table B will come out TABLE1... I want them to hold their real table names.</p>
  
  <p>How do I get the real table names of the tables that come in from the SQL Query ?  All the column names are correct, but the tables come out TABLE, TABLE1, TABLE2...  I obviously know how to set them in my code or parse the table names and set them in code...  I am wondering why .Net looses the table names in the first place and if there is a way for them to not be turned into ambiguous names.</p>
  
  <p>Why would the writers of the SQLClient drivers not think we care about table names?</p>
  
  <p>Any ideas from anyone on a way to get around this without having to set Table Name manually?  </p>