Coding Sign | Coding Tricks and Crack the Tech Interview

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…

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…