title: Is it possible to automatically prefix all table names in SQL Server and in LINQ to SQL?
body: <p>I'm working on a few ASP.NET MVC projects which all require database functionality. Unfortunately, my hosting provider only gives me two SQL Server databases to work with, so I want to put the tables of multiple projects into a single database.</p>
  
  <p>However, some of my tables are similarly named, so I might run into some issues. Thus, I'm trying to find a way to <strong>change the names of all the tables</strong> so that they reflect what application they belong to.</p>
  
  <p>Currently, I have the following tables in Project A:</p>
  
  <ul>
  <li><code>Table1</code></li>
  <li><code>Table2</code></li>
  </ul>
  
  <p>In Project B, I have these tables:</p>
  
  <ul>
  <li><code>Table1</code></li>
  <li><code>Table2</code></li>
  </ul>
  
  <p>I would like to combine the tables into a single database:</p>
  
  <ul>
  <li><code>ATable1</code></li>
  <li><code>ATable2</code></li>
  <li><code>BTable1</code></li>
  <li><code>BTable2</code></li>
  </ul>
  
  <hr>
  
  <h2>My Questions</h2>
  
  <ol>
  <li>How can I <strong>automatically add a prefix to the names</strong> of all of the tables inside of a SQL Server database?</li>
  <li>Is it possible to <strong>have LINQ to SQL automatically map</strong> <code>Table1</code> from my code into <code>ATable1</code> or <code>BTable1</code> (depending on what application it is)?</li>
  </ol>