Synopses & Reviews
Enter a New World of Database Programming C# and ADO.NETfacilitate the development of a new generation of database applications,including remote applications that run on theWeb. Mastering C# Database Programming is the resource you need to thrivein this new world. Assuming no prior experience with database programming, thisbook teaches you every aspect of the craft, from GUI design to server developmentto middle-tier implementation. If you’re familiar with earlier versions ofADO, you’ll master the many new features of ADO.NET all the more quickly.You'll also learn the importance of XML within the new .NET paradigm. Coverageincludes:
- Accessing a database using C# andADO.NET
- Using SQL to access a database
- Using Visual Studio .NET to buildapplications
- Creating and modifying database tables
- Understanding ADO.NETclasses
- Designing, building, and deploying Web applications that access adatabase
- Designing, building, and deploying effective Web services
- UsingSQL Server’s built-in XML capabilities
- Working with a database in adisconnected manner
- Using advanced transaction controls
- UsingTransact-SQL to create stored procedures and functions in a SQL Server database
Synopsis
C# is Microsoft's hot new object oriented programming language, specifically designed for the .NET platform. It simplifies the development of Web applications. C# is based on C++ but adds the functionality that Java developers have come to love. It is Microsoft's first true object-oriented programming language. It is popular with both C++ and VB developers and over time may pull away some of the Java audience as well. Interest in the language has grown faster than expected, with 24 percent of developers in a recent survey saying they planned to use the language in the next year. Experienced C# programmers who want to learn database programming, as well as Visual C++ and VB programmers who have less familiarity with database programming but are learning C#.
Synopsis
* Using Transact-SQL to create stored procedures and functions in a SQL Server database
Synopsis
Enter a New World of Database ProgrammingC# and ADO.NET facilitate the development of a new generation of database applications, including remote applications that run on the Web. Mastering C# Database Programming is the resource you need to thrive in this new world. Assuming no prior experience with database programming, this book teaches you every aspect of the craft, from GUI design to server development to middle-tier implementation. If you're familiar with earlier versions of ADO, you'll master the many new features of ADO.NET all the more quickly. You'll also learn the importance of XML within the new .NET paradigm. Coverage includes:
- Accessing a database using C# and ADO.NET
- Using SQL to access a database
- Using Visual Studio .NET to build applications
- Creating and modifying database tables
- Understanding ADO.NET classes
- Designing, building, and deploying Web applications that access a database
- Designing, building, and deploying effective Web services
- Using SQL Server's built-in XML capabilities
- Working with a database in a disconnected manner
- Using advanced transaction controls
- Using Transact-SQL to create stored procedures and functions in a SQL Server database
About the Author
Jason Price has more than 10 years' experience in the software industry. He is an MCSE, OCP, and has extensive experience with C#, .NET, and Java. He is the author of Sybex's Mastering Visual C# .NET and two Oracle books for other publishers. All his books have received 5-star reviews on Amazon.
Table of Contents
Introduction.
Part 1: Introduction to ADO.NET and Databases.
Chapter 1: Introduction to Database Programming with ADO.NET.
Chapter 2: Introduction to Databases.
Chapter 3: Introduction to Structured Query Language (SQL).
Chapter 4: Introduction to Transact-SQL Programming.
Chapter 5: Overview of the ADO.NET Classes.
Chapter 6: Introducing Windows Applications and ADO.NET.
Part 2: Fundamental Database Programming with ADO.NET.
Chapter 7: Connecting to a Database.
Chapter 8: Executing Database Commands.
Chapter 9: Using DataReader Objects to Read Results.
Chapter 10: Using DataSet Objects to Store Data.
Chapter 11: Using DataSet Objects to Modify Data.
Chapter 12: Navigating and Modifying Related Data.
Chapter 13: Using DataView Objects.
Part 3: Advanced Database Programming with ADO.NET.
Chapter 14: Advanced Transaction Control.
Chapter 15: Introducing Web Applications?ASP.NET.
Chapter 16: Using SQL Server?s XML Support.
Chapter 17: Web Services.
Index.