Beginning C# 5.0 Databases, 2nd Edition

Beginning C# 5.0 Databases, 2nd Edition
English | 440 pages | ISBN-10: 1430242604 | PDF, EPUB | 29.91 MB

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
Beginning C# 5.0 Databases is for every C# programmer. Database programming requires relatively little knowledge of C# but a lot of knowledge about relational database concepts, database language SQL and ADO.NET. This book assumes no prior database experience and teaches you, always through hands–on examples, how to create and use relational databases with SQL Server 2012 and how to access them with C# 5.0 using ADO.NET. Almost every application needs to access a database, and this book teaches all the fundamentals you need and may ever need to develop professional database applications.

Table of Contents
Getting and Understanding Your Tools
Understanding Relational Databases
Creating Database and Tables
Manipulating Database Data
Querying Database
Using Stored Procedures
Using XML
Understanding Transactions
Building Windows Form 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 ADO.NET Entity Framework
Using the CLR in SQL Server
DOWNLOAD
(Buy premium account for maximum speed and resumming ability)

Download

Download

Download