Beginning C# 5.0 Databases, Second Edition

  • 4h 55m
  • Vidya Vrat Agarwal
  • Apress
  • 2012

Assuming only basic knowledge of C#, Beginning C# 2012 Databases teaches all the fundamentals of database technology and database programming readers need to quickly become highly proficient database users and application developers.

A comprehensive tutorial on both SQL Server 2012 and Visual Studio 2011, Beginning C# 2012 Databases explains and demonstrates various techniques and ways to build a database application using T–SQL and C#. Full of practical, detailed examples, it’s been fully revised and updated for Winforms using C# 2012 and Visual Studio 2011 and offers the most complete, detailed, and gentle introduction to database technology for all C# programmers at any level of experience.

  • Comprehensively and concisely explains fundamental database concepts and database programming techniques
  • Rich in step-by-step working examples of both T–SQL and C# programs
  • Covers all the features ADO.NET most database programming ever requires

What you’ll learn

  • How relational databases work and how to use them
  • How to create database and table objects using SQL Server 2012
  • How to write SQL queries to modify data in SQL Tables
  • How to write SQL queries to retrieve data using various querying techniques, including JOINS
  • How to write stored procedures in T–SQL and call them from C# 2012 programs
  • How C# 2012 uses various techniques to access databases
  • How to build Windows form based applications
  • How to handle runtime anomalies i.e. Exceptions
  • How to program with each individual object of ADO .NET
  • How to use XML in database applications
  • How to use LINQ to simplify C# database programming
  • How to use ADO .NET Entity Framework

About the Author

Vidya Vrat Agarwal, a Microsoft .NET purist and an MCT, MCPD, MCTS, MCSD.NET, MCAD.NET, and MCSD, works with Lionbridge Technologies (NASDAQ: LIOX), and his business card reads "Subject Matter Expert" (SME). He is also a lifetime member of the Computer Society of India (CSI). He started working on Microsoft .NET with its beta release. He has been involved in software development, evangelism, consultation, corporate training, and T3 programs on Microsoft .NET for various employers and corporate clients. His articles can be read at, and he also reviews .NET preparation kits, available at He has contributed as technical reviewer to many books published by Apress, including Beginning VB 2008 Databases: From Novice to Professional.

In this Book

  • Getting and Understanding Your Tools
  • Understanding Relational Databases
  • Creating Database and Tables
  • Manipulating Database Data
  • Querying Databases
  • Using Stored Procedures
  • Using XML
  • Understanding Transactions
  • Building Windows Forms Applications
  • Introduction to ADO.NET
  • Handling Exceptions
  • Making Connections
  • Executing ADO.NET Commands to Retrieve Data
  • Using Data Readers
  • Using Data Sets and Data Adapters
  • Using Data Controls with ASP.NET Applications
  • Working with Text and Binary Data
  • Using LINQ
  • Using the ADO.NET Entity Framework
  • Using the CLR in SQL Server