title: How do I copy whole tables from ODBC source to SQL server using c# .Net without specifying columns
body: <p>This will be in C#</p>
  
  <p>I would like to do this without specifying column names as will be multiple tables.</p>
  
  <p>Will be a nightly scheduled task, truncating old then writing new.</p>
  
  <p>I have a working odbc connection and sql connection.</p>
  
  <p>One thought is to use dapper but cast to an object instead of a model class. Would this work.</p>