Beginning C# 5.0 Databases

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 TSQL 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 TSQL and C# programs

• Covers all the features ADO.NET most database programming ever requires

  A comprehensive tutorial on both SQL Server 2012 and Visual Studio 2012, Beginning C# 5.0 Databases explains and demonstrates how to create database oriented programs using T-SQL and C#.

  Autorentext
  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.

  Inhalt

1. Getting and Understanding Your Tools
2. Understanding Relational Databases
3. Creating Database and Tables
4. Manipulating Database Data
5. Querying Database
6. Using Stored Procedures
7. Using XML
8. Understanding Transactions
9. Building Windows Form Applications
10. Introduction to ADO .NET
11. Handling Exceptions
12. Making Connections
13. Executing ADO.NET Commands to Retrieve Data
14. Using Data Readers
15. Using Data Sets and Data Adapters
16. Using Data Controls with ASP.NET Applications
17. Working with Text and Binary Data
18. Using LINQ
19. Using ADO.NET Entity Framework
20. Using the CLR in SQL Server