Hi
Forgive me for sounding like a newbie, but I would like to know what the current best way is to work with a SQL database. I recently had to design a program in which I worked with a SQL database, and the way I accessed data was to create 2 seperate classses for each Table, and then I used these classes to call the stored procedures that I wrote to read and write data to and from the database.
Just the other day I saw that one can simply add an ADO.NET Entity Model and associate it with your SQL database. This creates objects for each of your tables as well as methods such as "AddToTable". This results in far less code than my previous attempt. I know its good to know how the background stuff works e.g how these objects and methods are actually created etc., but once one knows all that, is it a good approach to simply let .NET do most of the work for you?
Submit an article or tip