Beginning C# 5.0 Databases, Second Edition

Beginning C# 5.0 Databases, Second Edition

eBook - 2012
Rate this:

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 TSQL 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 handson 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 Gettingand Understanding Your Tools Understanding Relational Databases Creating Database and Tables Manipulating Database Data Querying Database UsingStored Procedures Using XML Understanding Transactions Building Windows Form Applications Introduction toADO .NET Handling Exceptions Making Connections Executing ADO.NET Commands to Retrieve Data Using Data Readers Using Data Sets and Data Adapters Using Data Controls withASP.NET Applications Working with Text and Binary Data Using LINQ Using ADO.NET Entity Framework Using the CLR in SQL Server "

Publisher: [New York] : Apress, c2012 (Norwood, Mass. : Books24x7.com [generator])
Edition: 2nd ed
ISBN: 9781430242611
9781430242604
Additional Contributors: Mayberry, Michael
Books24x7, Inc

Opinion

From the critics


Community Activity

Comment

Add a Comment

There are no comments for this title yet.

Age Suitability

Add Age Suitability

There are no age suitabilities for this title yet.

Summary

Add a Summary

There are no summaries for this title yet.

Notices

Add Notices

There are no notices for this title yet.

Quotes

Add a Quote

There are no quotes for this title yet.

Explore Further

Subject Headings

  Loading...

Find it at VPL

  Loading...
[]
[]
To Top