- Letting .NET DO Some of the Heavy LiftingA SQL Command Builder Example
- A SQL Command Builder Example
- All the Work in One-Fourth the Time
All the Work in One-Fourth the Time
The biggest challenge in using a huge framework like .NET is figuring out what is there and not reinventing the wheel. The .NET framework has a lot of wheels already in it.
If you're using embedded SQL instead of stored procedures, consider using the SqlCommandBuilder to generate your SQL CRUD statements for you. All you have to do is write the SELECT, and the SqlCommandBuilder will do the rest, on command.