David Talbot, Mahesh Chand

Applied ADO.NET (eBook, PDF)

Building Data-Driven Solutions

• Format: PDF

Produktbeschreibung

In this book, readers will learn to: * Understand the basics of ADO.NET, the data architecture for the .NET platform. * Work with both connected and disconnected data. * Build a custom data provider and leverage XML in applications. * Code custom stored procedures and call them from .NET. * Work with diverse types of databases including SQL Server, Oracle, and MySQL from .NET. * Use databinding on both Windows desktop and ASP.NET Web applications for easy and seamless data manipulation. * Architect and code cutting-edge Web services.

---

Dieser Download kann aus rechtlichen Gründen nur mit Rechnungsadresse in A, B, BG, CY, CZ, D, DK, EW, E, FIN, F, GR, HR, H, IRL, I, LT, L, LR, M, NL, PL, P, R, S, SLO, SK ausgeliefert werden.

Produktdetails

• Verlag: Apress
• Seitenzahl: 928
• Erscheinungstermin: 9. November 2013
• Englisch
• ISBN-13: 9781430207597
• Artikelnr.: 43999913

Autorenporträt

David Talbot's background is diverse, ranging from developing license-plate recognition technology to television-set boxes to scalable web applications. Currently, David works in the new business technologies group at FreeMarkets, applying cutting-edge .NET technologies to solve business problems. He has been working with .NET since the early betas, developing a number of solutions for a number of start-ups and established companies while working on several .NET books and articles. Prior to the development of .NET, David worked primarily on Java, SCO UNIX, Linux, DB2, SQL Server, and Perl.

Inhaltsangabe

1 ADO.NET Basics.- 2 Data Components in Visual Studio .NET.- 3 ADO.NET in Disconnected Environments.- 4 ADO.NET in Connected Environments.- 5 Handling ADO.NET Events.- 6 Integrating XML with ADO.NET.- 7 Data Binding and Windows Forms Data-Bound Controls.- 8 Constraints and Data Relations.- 9 ADO.NET Exception Handling.- 10 Working with the ODBC .NET Data Provider.- 11 Stored Procedures and Views.- 12 Oracle, SQLXML, and Other .NET Data Providers.- 13 Developing a Custom Data Provider.- 14 Developing Database Web Applications Using ASP.NET.- 15 Using ADO.NET in XML Web Services.- 16 ASP.NET Server Controls and Data Binding.- 17 Building Real-World Web Applications.- 18 Object-Relational Mapping in .NET.- 19 Mapped Objects: Performance Considerations and Data Binding.- 20 COM Interoperability and ADO.NET.- 21 Messaging.- 22 SQL Server and ADO.NET: Notes on Performance.- Appendix A Relational Databases: Some Basic Concepts.- Understanding Normalization.- First Normal Form (1NF).- Second Normal Form (2NF).- Third Normal Form (3NF).- Boyce-Codd Normal Form (BCNF).- Fourth Normal Form (4NF).- Fifth Normal Form (5NF or PJ/NF).- Introducing Sets, Cursors, and ADO.NET.- Using Locking.- Isolation Levels.- Locking Modes.- Summary.- Appendix B Commonly Used SQL Statements.- Understanding SQL References.- Using the SELECT Statement.- Using the UPDATE Statement.- Using the DELETE Statement.- Using the CREATE TABLE Statement.- Using the DROP TABLE Statement.- Using the TRUNCATE TABLE Statement.- Using the INSERT Statement.- Using Joins and Aliases.- Understanding Views.- Using SQL Server's SELECT...FOR XML Clause.- Summary.- Appendix C ADO.NET Frequently Asked Questions.- Summary.