Wouldn’t it be nice, if there were tools that (given a database and a table in that database) did the whole bit of magic and generated a C# solution, which will have a GUI for all the basic CRUD operations along with the DAL? I bet that would be nice!! Well, we are not alone; there are so many people who have thought of this before us... Check out this CodeProject article about Code Generators, ORM mappers or what-ever you prefer to call them.
http://www.codeproject.com/dotnet/CodeGenResource.asp