Beginning C# 5.0 Databases (Expert's Voice in C#)

Assuming only basic knowledge of C#, Beginning C# 5.0 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 2012, Beginning C# 5.0 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# 5.0 and Visual Studio 2012 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# 5.0 programs


• How C# 5.0 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


• How to use SQL CLR to create stored procedures using C#

Who this book is for