Year: 2017
-
Develop and Install a Windows Service in C#
What a Windows Service is Enables you to create long-running executable applications that run in their own windows session. Can…
Read More » -
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 » -
C# 7 Features – Tuples
In order to return multiple values from a method in C#, we can use approaches like creating out parameters, creating…
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 » -
Identity Cache In LINQ To SQL
What is Identity Cache? DataContext object uses identity cache to manage objects. In this example, we are retrieving two students…
Read More » -
Compile Queries And Execute SQL Queries Using LINQ To SQL
In this article, we will see Compiled queries in LINQ to SQL and How to execute SQL queries, using LINQ…
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 » -
Introduction To Entity Framework
What is Entity Framework Entity Framework is an ORM framework. ORM stands for Object Relational Mapping. What is an Object…
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 »