SQL Server
-
Insert and Update in SQL Using User-Defined Table Type and XML
In this article I show various ways to insert in SQL. Using Datatable Using XML By showing examples of inserts…
Read More » -
Working with the SqlTransaction Class in ADO.NET
Introduction: The SqlTransaction class is very important class of .NET Framework. The SqlTransaction class is used for satisfying the ACID…
Read More » -
Overview Of Concurrency In LINQ To SQL
In this article, we will see Difference between optimistic and pessimistic concurrency control. Concurrency control in LINQ to SQL. Handling…
Read More » -
LINQ To SQL – CRUD Operations
We have seen a lot of articles on LINQ to SQL. Before going through this article, I would recommend to…
Read More » -
SQL Helper for C#.Net
using System; using System.Collections.Generic; using System.Linq; using System.Text; using Microsoft.VisualBasic; using System.Collections; using System.Data; using System.Diagnostics; using System.Data.SqlClient; using System.Xml;…
Read More »