(Ebook) Beginning C# 5.0 Databases by Vidya Vrat Agarwal ISBN 9781430242604, 1430242604

(Ebook) Beginning C# 5.0 Databases by Vidya Vrat Agarwal ISBN 9781430242604, 1430242604

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 techniquesRich in step-by-step working examples of both T–SQL and C# programsCovers all the features ADO.NET most database programming ever requires What you’ll learn How relational databases work and how to use themHow to create database and table objects using SQL Server 2012     How to write SQL queries to modify data in SQL TablesHow to write SQL queries to retrieve data using various querying techniques, including JOINSHow to write stored procedures in T–SQL and call them from C# 5.0 programsHow C# 5.0 uses various techniques to access databasesHow to build Windows form based applicationsHow to handle runtime anomalies i.e. ExceptionsHow to program with each individual object of ADO .NETHow to use XML in database applicationsHow to use LINQ to simplify C# database programmingHow to use ADO .NET Entity FrameworkHow 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 DatabasesCreating Database and TablesManipulating Database DataQuerying Database Using Stored ProceduresUsing XMLUnderstanding TransactionsBuilding Windows Form Applications Introduction to ADO .NET Handling Exceptions Making Connections Executing ADO.NET Commands to Retrieve DataUsing Data ReadersUsing Data Sets and Data AdaptersUsing Data Controls with ASP.NET ApplicationsWorking with Text and Binary DataUsing LINQUsing ADO.NET Entity FrameworkUsing the CLR in SQL Server