title: Linq to SQL or Linq to DataSet?
body: <p>I am new to Linq world and currently exploring it. I am thinking about using it in my next project that involves database interaction.</p>
  
  <p>From whatever I have read, I think there are 2 different ways to interact with databases:</p>
  
  <ul>
  <li>Linq to SQL</li>
  <li>Linq to DataSet</li>
  </ul>
  
  <p>Now the product that I am to work on, cannot rely on the type of database. For example, it might be deployed with SQL server/Oracle.</p>
  
  <p>Now my questions are:</p>
  
  <ol>
  <li>If I use Linq to SQL, am I stuck with SQL server only?</li>
  <li>I think I can use Linq to DataSet for both SQL server and oracle. But will I loose something (ease of programming, performance, reliability etc) if I use Linq to DataSet for SQL server (compared to Linq to SQL offcourse).</li>
  </ol>