Showing posts from September, 2023
API Key Authentication - In API Key Authentication, the API owner will share an API key with the users and this key will authenticate the users of that API. The disadvantage of it is, API keys can be shared or stolen therefore it may not be suitable …
Token-based authentication is a protocol that generates encrypted security tokens. It enables users to verify their identity to websites, which then generates a unique encrypted authentication token.
JSON Web Token (JWT) authentication is a stateless method of securely transmitting information between parties as a JavaScript Object Notation (JSON) object . It is often used to authenticate and authorize users in web applications and APIs. JWT authe…
A JWT token typically consists of three parts: Header : Contains metadata about the token, such as the type of token (JWT) and the signing algorithm being used (e.g., HMAC SHA256 or RSA). Payload : Contains claims, which are statements about …
You'll pass the token as part of the authorization header on the client-side after the client logged in, like Authorization:Bearer In REQUEST HEADER. KEY - Authorization VALUE - Token
Web API(Application Programming Interface) are HTTP based services that can be accessed from browser or mobile-apps. Web API enables different software applications to communicate with each other through the internet. Web API’s mostly use JSON and XML…
Web APIs are simpler to use and learn, and use familiar web technologies like HTTP, JSON and XML. Web APIs are more flexible, can be hosted on a wide range of platforms, and are compatible with many devices including mobile devices, web browsers, and …
REST is a set of guidelines which helps in creating a system where applications can easily communicate with each other. REST stands for Representational State Transfer.
Separation of Client and Server - The implementation of the client and the server must be done independently. Stateless - The server will not store anything about the latest HTTP request the client made. It will treat every request as new request. Un…
Differences between MVC (Model, View, Controller) and ASP.NET Web API are: MVC is for developing applications that return both data and views, while Web API only returns data using the HTTP services . They trace actions differently. Web API traces bas…
DataSet class - A DataSet is basically a container which gets the data from one or more tables from the database. It follows disconnected architecture. DataAdapter class - A DataAdapter bridges the gap between the disconnected DataSet/ DataTable obj…
🌟 Exploring the World of ADO.NET: Connected vs. Disconnected Architectures 🌐 Are you diving into the realm of ADO.NET and wondering about its different architectural approaches? Let's demystify the concepts of Connected and Disconnected architec…
Disconnected Architecture - Disconnected architecture means, you don’t need to connect always to get data from the database. Get data into DataAdapter. Manipulate the DataAdapter Resubmit the data. It is fast and robust(data will not lose in case of …
EXECUTESCALAR() - It is used to return SINGLE value from the database. EXECUTENONQUERY() – It returns a RESULTSET from databse and it has multiple values. It can be used for insert, update and delete. EXECUTEREADER() - It only retrieves data from d…
The main authentication techniques are: Windows Authentication: This technique uses the current Windows user account to authenticate to SQL Server. It is the most secure and recommended technique for applications running on a Windows domain. SQL Serve…
ORM (Object-Relational Mapper) is for mapping objects in your application with database tables. It is like a wrapper to make database calls simple and easy.
Entity Framework is an open source object–relational mapping framework for ADO.NET. It was originally shipped as an integral part of .NET Framework, however starting with Entity Framework version 6.0 it has been delivered separately from the .NET F…
ADO.NET public class UserRepository { public DataSet GetAllUsersList () { DataSet ds = new DataSet (); // Initializes disconnected dataset to fetch results //Creat…
