i am building an all C# based DAL. I am choosing this over the designer DAL in VS because i had terrible issues with it a while back and am gun shy about trying it again. So my dal is relatively simple. Has methods that return either single custom objects, or DataTAbles, or Lists<myClass>, etc. But i am having some issues with insert and update methods. Should they just be voids in my dal? or should they return something? They are designed to be bound directly to an object data source, and ideally i would like the SQL to return the record once its been updated or inserted so i figured i should probably return an object or a DataTable. Is this the best way to approach this?
Also Are there interfaces or base classes i should be extending for the DAL? Should the DAL Classes contain any other special properties or anything? ANyone have a good example of a Code based DAL that has updates / inserts / selects / and ...
Go to the complete details ...