Use DataSet Genterator Build DAL

Visual 2005 comes with a DataSet Designer that is a convenient way to generate DAL and datasets as domain library. However you need to seperate the datasets and the TableAdapters, or you expose connection string and DAL logic that are not supposed to be exposed for security reason and from architecteure point of view. Unfortunately you have to cut and paste to a new project (assembly) manually. In Visual 2008 or Orcas, there is a DataSet Project property for a dataset, which can be used to seperate automatically when you compile the project


References

[1] MSDN Library, "Creating an N-Tier Data Application", http://msdn.microsoft.com/en-us/library/bb384570.aspx
[2] Guy Bursteins, "Orcas Datasets - Separate Datasets from TableAdapters", http://blogs.microsoft.co.il/blogs/bursteg/archive/2007/05/19/OrcasDatasets.aspx