Latest posts on "ADO-NET"

In this article, I will show you how to check if a record exists before insert in to the database using entity framework in c#. You can use Any() because it will check soon as matches in records.

We can use metadata to add functionality to entities by adding properties in a metadata class with attributes that we can affect the behavior of entities implemented with partial class called metadata classes.

You can overwrite entity framework data model class by defining separate class using partial keyword.

In this article we will discuss, to transfer xml data to sql server using SqlBulkCopy in asp.net c#. SqlBulkCopy class used to write data only to SQL server tables. It is efficient and very easy to copy large amount of data.

Caching is a technique to store the data in memory using dataset object. It improves scalability and performance to the web application. Below example we will be implementing the caching technique.

In this article we will discuss, How to Load two tables into a dataset and bind to gridview in asp.net c#. We want to show employee data in one gridview and prductdetail to another gridview using a collection property of dataset object.

In this article we will discuss about to bind a grid using disconnected data access model SqlDataAdapter and DataSet in ASP.Net c#. We are creating instance of SqlDataAdapter by passing sqlconnectiontext and Connection object and create instance for DataSet then fill the dataset with data.

In this article we will discuss, How to retrieving two or more result sets using SqlDataReader object’s NextResult() method in ASP.Net c#. To retrieve the second result-set from SqlDataReader object using the NextResult() .

In this article we will discuss, How to calculate discount price at runtime binding on gridview using Read() method, which returns true there are rows to read. If there are no more rows to read then it will return false.

In this article we will discuss, How to calling a store procedure with output parameters in ASP.Net c#. Write a store procedure with output parameter for employeeId with based on the employee table. The main thing is that to set EmployeeId marked as identity column.