Beginning C# 5.0 Databases

Front Cover
Apress, Aug 8, 2012 - Computers - 440 pages

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
 

What people are saying - Write a review

User Review - Flag as inappropriate

Its a great book to download :)

Contents

Getting and Understanding Your Tools
3
Understanding Relational Databases
15
Creating Database and Tables
25
Manipulating Database Data
43
Querying Databases
51
Using Stored Procedures
85
Using XML
101
Understanding Transactions
115
Using Data Readers
241
Using Data Sets and Data Adapters
277
Using Data Controls with ASPNET Applications
315
Working with Text and Binary Data
333
Using LINQ
357
Using the ADONET Entity Framework
375
Using the CLR in SQL Server
395
Index
409

Building Windows Forms Applications
137
Introduction to ADONET
171
Handling Exceptions
183
Making Connections
197
Executing ADONET Commands to Retrieve Data
213
Contents
vi
About the Author
xviii
About the Technical Reviewer
xix
Acknowledgments
xx
Copyright

Common terms and phrases

About the author (2012)

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 ProgrammersHeaven.com, and he also reviews .NET preparation kits, available at UCertify.com. He has contributed as technical reviewer to many books published by Apress, including Beginning VB 2008 Databases: From Novice to Professional.

He lives with his beloved wife, Rupali, and lovely daughter, Vamika ("Pearly"). He believes that nothing will turn into a reality without them. He is the follower of the concept "No pain, no gain" and believes that his wife is his greatest strength. He is a bibliophile; when he is not working on technical stuff, he likes to be with his family and also likes reading spiritual and occult science books. He blogs at http://Dotnetpassion.blogspot.com. You can reach him at Vidya_mct@yahoo.com.

Bibliographic information