Connecting to a Database with Visual Studio Tools
Before we delve into the data-driven world of , let’s first take a look at some tools available in the Visual Studio products. The following example shows you one way…
Installing SQL Server 2008 Express
We will be using Microsoft SQL Server 2008 Express as our main data source. SQL Server is already installed if you have Visual C# Express or Visual Studio 2010, provided…
Databases and ADO.NET
Most of the applications today uses some sort of data storage. Perhaps the only applications I can imagine that doesn’t use some kind of storage for its data are those…
Creating an XML Document Using LINQ to XML
If you played with the XML Document Object Model classes to create XML documents from scratch, it will be easy for you to migrate to a brand new set of …
LINQ to XML
The .NET Framework provided us with several techniques for accessing and manipulating an XML file. In the past, you can use the XmlReader or the different XML Document Object Model classes such…
Modifying Database with LINQ to SQL
Mapping the database tables and its records to their corresponding LINQ to SQL classes makes it even easier to manipulate databases. Once LINQ to SQL classes is generated, you can…
Querying a Database with LINQ to SQL
We will be creating a Windows Forms Application that allows as to you to query and view records from a particular table using LINQ to SQL classes, SQL Server 2008,…
LINQ to SQL
LINQ to SQL is a powerful tool which allows developers to access databases as objects in C#. With LINQ to SQL, you are able to use LINQ query operators and methods…
LINQ Aggregate Methods
LINQ has aggregate operators or methods that allows you to perform mathematical calculations based on the values of all the elements in a collection. We will learn here the different aggregate operators…
LINQ Examples
Now that you have learnt some basic LINQ querying including how to select, filter, and order results of a query, let’s take a look at more examples combining the concepts…