title: Defining OleDbCommand Return Type
body: <p>I'm using the below OleDbCommand to read from a file method multiple times. The problem I'm having is that most of the time it's returning the datatypes as strings but occasionally (depending on the data being read) its returning int types. Is there a way to request all columns return as string without having to convert everything once it's loaded?</p>
  
  <pre><code>static DataTable GetDataTableFromCsv(string path, bool isFirstRowHeader)
      {
          string header = isFirstRowHeader ? "Yes" : "No";
  
          string pathOnly = Path.GetDirectoryName(path);
          string fileName = Path.GetFileName(path);
  
          string sql = @"SELECT * FROM [" + fileName + "]";
  
          using (OleDbConnection connection = new OleDbConnection(
                    @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + pathOnly +
                    ";Extended Properties=\"Text;HDR=" + header + "\""))
          using (OleDbCommand command = new OleDbCommand(sql, connection))
          using (OleDbDataAdapter adapter = new OleDbDataAdapter(command))
          {
              DataTable dataTable = new DataTable();
              dataTable.Locale = CultureInfo.CurrentCulture;
              adapter.Fill(dataTable);
  
              return dataTable;
          }
      }
  </code></pre>