Best way for building Database API in C# for ASP.NET Application

Question

Hi,

I want to create a C# API for ASP.NET Application. How to Create the API in C# for Storing and retrieving the data in sql.

Am in confusion of how to define the API, whether I have to define separate class for connection of sql, and insert I have to define a separate class likewise for update and delete or we can define all the functionality in single class. Can anyone guide me in right in which which way I have to go.

What is the best way for building Database API.

Answer 1

There is no general ultimate answer for designing new API. However there are guidelines and how-tos on the internet and in books, try to check them out, for example:
    http://blogs.msdn.com/kcwalina/archive/tags/General+API+Design/default.aspx
    http://msdn.microsoft.com/en-us/library/ms229042.aspx
    http://blogs.msdn.com/kcwalina/archive/2005/12/20/APIDesignLaws.aspx

If you are designing API for customers, collect their requirements and make sure that your design meets them. If you are designing it just for yourself, then well ... make it so it fits your needs.

-Karel