Command Class
Each data provider has their Command class which is used to execute SQL commands or stored procedures to the database. Each Command class inherits from the ;base class. The following are the different…
Connection Class
Each data provider in contains a Connection class that inherits from the ; class. The DbConnection serves as the base class for all the Connection classes of different data providers. The following are the connection categories for…
Data Providers
A data provider is a set of classes the manages and handles the connection to a data source such as SQL Server. The .NET Framework provides you with different data…
Connection Strings
A connection string may be a series of name/value pairs separated by punctuation that indicate the settings for connecting to a database. Such settings embody the situation of the database,…
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…