"Essential ADO.NET" presents an in-depth explanation of ADO.NET and features its capabilities. Not only does this book enumerate the usage of classes, interfaces, properties, and methods, it also examines the structure of data and demonstrates the ways in which ADO.NET can solve data access challenges.

ADO.NET revolutionized the way data was accessed through SQL Server, Oracle, and MySQL. With Microsoft's release of ADO.NET 2, ADO and the .NET Framework are integrated with SQL Server for the first time-enabling you to program .NET applications directly within the SQL Server database. Packed with sample code and recommended best practices for using ADO.NET 2, this code-intensive book explores the new data types that are available in the 2.0 Framework and discusses the appropriate time and way to use them. You'll learn how to make repetitive, mundane tasks much simpler and you'll walk away with a solid foundation for developing database-driven applications. What you will learn from this book The basics of creating a connection, executing a query, and returning a result Best uses for Oracle in the ADO.NET Framework The many new features that are available for XML How to use the full text search capabilities of Microsoft(r) SQL Server 2005 Methods for retrieving data and presenting it in various ways Why MySQL is a viable option for data storage Who this book is for This book is for experienced database developers who want to learn the latest release of ADO.NET 2.0. Knowledge of ADO.NET 1.0, general .NET development, and Microsoft SQL Server is necessary. Wrox Professional guides are planned and written by working programmers to meet the real-world needs of programmers, developers, and IT professionals. Focused and relevant, they address the issues technology professionals face every day. They provide examples, practical solutions, and expert education in new technologies, all designed to help programmers do a better job.

Use PowerShell to Streamline and Automate Your Most Time-Consuming Windows Administration Tasks With Windows PowerShell, Microsoft brings innovative console-based system administration and scripting to Windows clients and servers. PowerShell combines the best features of traditional UNIX shells with the immense power of the .NET Framework, offering a consistent and easy-to-use replacement for both the Windows command line and the Windows Script Host. In Essential PowerShell, noted expert Holger Schwichtenberg gives Windows sysadmins all the knowledge and sample scripts they need to successfully administer production systems with PowerShell. Schwichtenberg begins by introducing the innovative PowerShell architecture, along with crucial PowerShell concepts such as pipelining and navigation. Next, he introduces the PowerShell Script Language, shows the secure execution of command sequences as scripts, and demonstrates how to use PowerShell to access essential operating system interfaces such as COM, WMI, ADSI, and ADO.NET. After you’ve mastered the fundamentals, Schwichtenberg presents an extensive collection of PowerShell solutions for virtually every area of day-to-day administration. For each topic, he presents dozens of self-contained examples, all downloadable from a companion Web site. He covers both Microsoft’s standard PowerShell commandlets and the free commandlets available as PowerShell Community Extensions. He also presents a full chapter of tips, tricks, and troubleshooting solutions. Coverage includes Understanding PowerShell’s components and features Setting up your PowerShell scripting environment Creating and using commandlets Using object-oriented pipelining for filtering, sorting, grouping, comparisons, calculations, and more Mastering PowerShell’s uniform navigation model and using it with all types of data Programming command sequences with the PowerShell Script Language Making the most of the PowerShell console and third-party tools Managing processes, event logs, and registry entries Controlling networking, printing, and software installation Manipulating Active Directory and other enterprise services with PowerShell Using PowerShell to enforce stronger system and network security Storing data in files, documents, and databases Preface xv Part I: Getting Started with PowerShell 1: First Steps with Windows PowerShell 3 2: Commandlets 25 3: Pipelining 43 4: Advanced Pipelining 59 5: The PowerShell Navigation Model 81 6: The PowerShell Script Language 89 7: PowerShell Scripts 115 8: Using Class Libraries 129 9: PowerShell Tools 151 10: Tips, Tricks and Troubleshooting 171 Part II: Windows PowerShell in Action 11: File Systems 205 12: Documents 235 13: Registry and Software 253 14: Processes and Services 267 15: Computers and Hardware 281 16: Networking 295 17: Directory Services 313 18: User and Group Management in the Active Directory 335 19: Searching in the Active Directory 349 20: Additional Libraries for Active Directory Administration 361 21: Databases 373 22: Advanced Database Operations 389 23: Security Settings 401 24: Advanced Security Administration 413 PartIII: Appendices Appendix A: PowerShell Commandlet Reference 429 Appendix B: PowerShell 2.0 Preview 445 Appendix C: Bibliography 449 Index 453

Written by experts on the Microsoft® .NET programming platform, ADO.NET in a Nutshell delivers everything .NET programmers will need to get a jump-start on ADO.NET technology or to sharpen their skills even further. In the tradition of O'Reilly's In a Nutshell Series, ADO.NET in a Nutshell is the most complete and concise source of ADO.NET information available.ADO.NET is the suite of data access technologies in the .NET Framework that developers use to build applications services accessing relational data and XML. Connecting to databases is a fundamental part of most applications, whether they are web, Windows®, distributed, client/server, XML Web Services, or something entirely different. But ADO.NET is substantially different from Microsoft's previous data access technologies--including the previous version of ADO--so even experienced developers need to understand the basics of the new disconnected model before they start programming with it.Current with the .NET Framework 1.1, ADO.NET in a Nutshell offers one place to look when you need help with anything related to this essential technology, including a reference to the ADO.NET namespaces and object model. In addition to being a valuable reference, this book provides a concise foundation for programming with ADO.NET and covers a variety of issues that programmers face when developing web applications or Web Services that rely on database access. Using C#, this book presents real world, practical examples that will help you put ADO.NET to work immediately.Topics covered in the book include: An Introduction to ADO.NET Connections, Commands and DataReaders Disconnected Data Advanced DataSets Transactions DataViews and Data Binding XML and the DataSet Included with the book is a Visual Studio .NET add-in that integrates the entire reference directly into your help files. When combining ADO.NET in a Nutshell with other books from O'Reilly's .NET In a Nutshell series, you'll have a comprehensive, detailed and independent reference collection that will help you become more productive.

A great resource for developers seeking to build databases and applications that access data in Oracle and SQL Server databases and other data sources, this handbook has comprehensive coverage that reveals all the efficiencies of the ADO.NET framework. Includes exclusive coverage with code examples in both VB.NET and C#.

This concise guide for experienced programmers and software architects is a complete no-nonsense overview of key elements and programming languages central to all .NET application development

* Provides compact coverage of new ADO.NET features and use of cutting edge tools, such as Visual Studio .NET 2005. * Content and examples take practical focus as opposed to a theoretical, academic treatment. * Heavily trimmed content eliminates information the reader won’t find useful very often.

The author shows developers with litte or no ADO.NET background how to apply ADO.NET fast to real world scenarios by giving examples and code that really works.

Written for developers who need to get up to speed on ADO.NET, this book covers the ADO.NET object model from start to finish, from database tools to creating data objects, from creating Web Services to developing multi-tier database applications. It also covers everything from Windows Forms classes and data binding to creating ASP.NET Web applications.

Developers need a way to interact with all data platforms in a uniform way, and Microsoft has attempted time and again to meet this need with its Universal Data Access strategy. In developing ADO.NET, Microsoft has made their additions of support for XML and disconnected data sets easier to use. This tutorial will guide the reader through ADO.NET from the top down, showing readers the hows and whys of using ADO.NET with lots of examples they can mold into their own projects right away. It is intended to be an introduction to ADO.NET for developers with some knowledge of data access. While it will show readers how ADO.NET follows on its predecessors, it will be written to avoid repeating any remedial instruction in databases and storage theory.