Ado.net Programming Style

Description:ADO.net Programming article which focus on both how to write efficient code and how to represent the information which take advantage of layered design of .net framework. Articles describes how you can write code efficiently and improve performance of application and avoids errors due to poor coding style. Advantages of Article and DemoCode are : i) Opening of connection for a short time and Closing it as soon as database task is completed, it thus help in improving performance of application. ii) Better usage of Error-Handling, to make sure that connection is closed even if the exception occurs. iii) Follow Stateless design, taking all needed information as parameter and return all the data through return value. It helps in load balancing and it would be easy while implementing web-service. iv) Storing connection string in app.config file allow us to made a single change, to change a connection string. It helps in connection pooling.