title: New .NET 3.5 Project: Which DAL technology to use?
body: <p>I am preparing a new Windows project and wonder what kind of DAL technology to use. Originally I was looking for something simpler to not spending too much time on building it. But I understand also that it has to be efficient and scalable in the long run.</p>
  
  <p>I plan to use WPF (MVVM) Client and WCF Service on a 3 Tier system.</p>
  
  <p>Just to sum up all the existing technologies I am familiar with:</p>
  
  <p><strong>DataSets</strong></p>
  
  <p>PRO: Might be a bit old fashioned, but very easy to use and let the most parts to be auto generated for you. One powerful aspect about datasets are the ease of traversing related data through the Relations. Also in a way its disconnected from database and might simplify the updates by taking care of timestamps automatically. Includes validation.</p>
  
  <p>CONTRA: Quite old fashioned. Some consider them as no real business objects/Models but just a mirror of your SQL data tables. Passing them between WCF Service/Client might be more difficult than self created business objects.</p>
  
  <p><strong>Enterprise Library 4.1 - Data Access Block</strong></p>
  
  <p>PRO: The DAL is beautifully put into a Factory pattern. It takes care of connection opening and closing automatically. Very easy to use for most part. It supports both dataSets and normal SQL Sps to create your own Business objects. As part of an ongoing Framework it can be much more efficient to use in combination with rest of the Enterprise Library for an efficient end product.</p>
  
  <p>CONTRA: ??</p>
  
  <p><strong>Linq to SQL</strong></p>
  
  <p>PRO: Auto creates the SQL tables into business objects. Easy to CRUD. Theoretically a very nice way to do it.</p>
  
  <p>CONTRA: Having played around with it when it came out, I found it flaky and sometimes instable. It is already considered a dead technology after Microsoft announcement that Entity Framework 4.0 - as part of .NET 4.0 - will be Microsoft recommended way. Only few bug fixes are too be expected in .NET 4.0 but no more feature extending plans. </p>
  
  <p><strong>Entity Framework 4.0</strong></p>
  
  <p>I don't know anything about it, but only that it will eventually replace everything else as on .NET 4.0. I am also tempted to use it, however since its still in BETA, I wouldnt be able to go that way yet.</p>
  
  <p>I am very tempted to use Enterprise Library 4.1 - Data Access Block and to create my own business objects. The big Con is that it will take more time to create the DAL.  Unless someone can convince me of using DataSets through the Data Access Block instead. </p>
  
  <p>What are your comments and ideas?
  Many Thanks,
  Kave</p>