Wednesday, July 26, 2017

How to Use the SQL Helper Class to Create Web APIs

DZone Database Zone
How to Use the SQL Helper Class to Create Web APIs

The SQL Helper class is used in the Data Access Layer, which interacts with a database with the help of connection strings provided. It contains several methods, as shown below. And it improves the performance for the Business Layer and Data Access Layer.

 ExecuteNonQuery   ExecuteDataset
 ExecuteDataTable   ExecuteReader   ExcuteScalar   ASP.NET Web API

The ASP.NET Web API is a framework for building Web APIs on the top on the .NET framework, which makes it easy to build HTTP services for a range of clients, including mobile devices, browsers, and desktop applications.

No comments:

Fun With SQL: Functions in Postgres

DZone Database Zone Fun With SQL: Functions in Postgres In our previous  Fun with SQL  post on the  Citus Data  blog, we covered w...