Which is best way for develop Database API in C#

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

Hi,
You need to implement idbconnection interface.and create your own Database API.
have a look at this link.
http://msdn.microsoft.com/en-us/library/system.data.idbconnection.aspx
http://www.codeproject.com/KB/dotnet/Independent_DAL.aspx

---

Best Regards, C.Gnanadurai ----------------------- Please mark the post as answer if it is helpfull to you