Dotnetcat » .NET Books » Database books

This book is a comprehensive and easy-to-understand guide for using the Oracle Data Provider (ODP) version 11g on the .NET Framework. It also outlines the core GoF (Gang of Four) design patterns and coding techniques employed to build and deploy high-impact mission-critical applications using advanced Oracle database features through the ODP.NET provider.

The book details the features of the ODP.NET provider in two main sections: “Basic,” covering the basics and mechanisms for data access via ODP.NET; and “Advanced,’ covering advanced Oracle features such as globalization, savepoints, distributed transactions and how to call them via ODP.NET, advanced queueing (AQ), and promotable transactions. It takes you from the ground up through different implementation scenarios via a rich collection of C# code samples.

It outlines database security and performance optimization tricks and techniques on ODP.NET that conform to best practices and adaptable design. Different GoF design patterns are highlighted for different types of ODP.NET usage scenarios with consideration of performance and security.

It provides a comprehensive guide to the synergistic integration of Oracle and Microsoft technologies such as the Oracle Developer Tools for Visual Studio (11.1.0.7.10). It also details how programmers can make use of ODT to streamline the creation of robust ODP.NET applications from within the Visual Studio environment.

What you’ll learn

• How to use the full set of features available in ODP.NET 11g (with code samples and diagrams illustrating each feature/concept). New features such as using Oracle Streams AQ, promotable transactions, Oracle database event notifications, and Oracle database control are also covered.
• The core performance and feature differences between ODP.NET, Microsoft .NET Provider for Oracle, OLEDB.NET, and ODBC.NET, together with the strengths and weaknesses of each method. This section also provides comprehensive coverage on the differences between ODP.NET 9i, 10g, and 11g.
• How to take advantage of connection pooling, fetch size controls, ref cursors, bind variables, client result cache and statement caching via ODP.NET to squeeze every ounce of performance from your .NET application.
• How to secure your ODP.NET applications via authentication and ODP.NET 11g’s new classes to enforce imperative and declarative Oracle security.
• The common programming pitfalls and design patterns to use/avoid in different ODP.NET usage scenarios
• How to use a significant set of features of Oracle Developer Tools for Visual Studio (11.1.0.7.10), including new features such as the AQ designers, user/role management, and performance-tuning tools.

Who this book is for

This book is aimed at .NET developers looking for a comprehensive guide to ODP.NET and its latest features. The book will also appeal to those looking to optimize their ODP.NET applications by applying the best design patterns and other practices.

Table of Contents

1. Introduction to Oracle .NET Connectivity
2. ODP.NET: A Functional Overview
3. Connecting to Oracle with ODP.NET
4. Retrieving and Manipulating Data with ODP.NET
5. Using PL/SQL and NET CLR Stored Procedures with ODP.NET
6. ODP.NET Globalization
7. Transactions with ODP.NET
8. Oracle Database Change Notifications with ODP.NET
9. Using Oracle Database Streams Advanced Queuing with ODP.NET
10. Oracle XML Support
11. ODP.NET Security Features
12. ODP.NET Performance
13. Design Patterns and Considerations in Using ODP.NET
14. ODP.NET Tool Basics
15. Building Data-Driven Applications with ODP.NET

Dig into LINQ -- and transform the way you work with data.

With LINQ, you can query data from a variety of sources -- including databases, objects, and XML files -- directly from Microsoft Visual Basic® or C#. Guided by data-access experts who've worked in depth with LINQ and the Microsoft development teams, you'll learn how .NET Framework 4 implements LINQ, and how to exploit it. Clear examples show you how to deliver your own data-access solutions faster and with leaner code.

Discover how to:

• Use LINQ to query databases, object collections, arrays, XML, Microsoft Excel® files, and other sources
• Apply LINQ best practices to build data-enabled .NET applications and services
• Manipulate data in a relational database with ADO.NET Entity Framework or LINQ to SQL
• Read, write, and manage XML content more efficiently with LINQ to XML
• Extend LINQ to support additional data sources by creating custom operators and providers
• Examine other implementations, such as LINQ to SharePoint®
• Use LINQ within the data, business, and service layers of a distributed application
• Get code samples on the Web

Get a thorough introduction to ADO.NET Entity Framework 4 -- Microsoft's core framework for modeling and interacting with data in .NET applications. The second edition of this acclaimed guide provides a hands-on tour of the framework latest version in Visual Studio 2010 and .NET Framework 4. Not only will you learn how to use EF4 in a variety of applications, you'll also gain a deep understanding of its architecture and APIs.

Written by Julia Lerman, the leading independent authority on the framework, Programming Entity Framework covers it all -- from the Entity Data Model and Object Services to WCF Services, MVC Apps, and unit testing. This book highlights important changes for experienced developers familiar with the earlier version.

• Understand the core concepts you need to make the best use of the EF4 in your applications
• Learn to query your data, using either LINQ to Entities or Entity SQL
• Create Windows Forms, WPF, ASP.NET Web Forms, and ASP.NET MVC applications
• Build and consume WCF Services, WCF Data Services, and WCF RIA Services
• Use Object Services to work directly with your entity objects
• Create persistent ignorant entities, repositories, and write unit tests
• Delve into model customization, relationship management, change tracking, data concurrency, and more
• Get scores of reusable examples -- written in C# (with notes on Visual Basic syntax) -- that you can implement right away

• Combining both VB.Net and C# coverage in one book, this guide focuses on using ASP.NET 2.0 for solving business dynamic Web site challenges in a logical progression, from connecting to a database to displaying information to changing data
• Covers the fundamentals of connecting Web pages to databases, techniques for creating data objects and events, and ways to handle data errors
• Features tricks and traps for displaying data in grids, lists, and trees
• Goes beyond the usual basic techniques to discuss the best practices and pitfalls that can occur in real-world scenarios with SQL Server, Oracle, MySQL, Access, and the new SQL Server Express Edition

Teach yourself the fundamentals of ADO.NET 4 -- one step at a time. With this practical, learn-by-doing tutorial, you get the clear guidance and hands-on examples you need to start creating datacentric applications for Windows® and the Web.

Discover how to:

• Connect to external data sources, including databases and other data formats
• Use ADO.NET Entity Framework to interact with underlying data stores
• Build Entity Framework models with graphical design tools in Microsoft Visual Studio 2010
• Analyze information stored in ADO.NET with various LINQ providers
• Bind data directly to Windows Forms and Web Forms to drive information to users
• Manage disconnected or standalone data and information
• Go beyond the core functionality of ADO.NET to manipulate data in more advanced ways

Your step by step digital content includes:

• Practice exercises
• Fully searchable online edition of this book -- with unlimited access on the Web

The most up-to-date Visual Basic.NET programming textbook—covering both fundamentals and advanced-level programming techniques—complete with examples and solutions

Visual Basic.NET (VB.NET) is an object-oriented computer programming language that can be viewed as an evolution of the classic Visual Basic (VB), which is implemented on the .NET Framework. Microsoft currently supplies two major implementations of Visual Basic: Microsoft Visual Studio (which is commercial software) and Microsoft Visual Studio Express (which is free of charge).

Forgoing the large amounts of programming codes found in most database programming books, Practical Database Programming with Visual Basic.NET shows students and professionals both how to develop professional and practical database programs in a Visual Basic.NET environment by using Visual Studio.NET Data Tools and Wizards related to ADO.NET 4.0, and how to apply codes that are auto-generated by solely using Wizards. The fully updated Second Edition:

• Covers both fundamentals and advanced database programming techniques
• Introduces three popular database systems with practical examples including MS Access, SQL Server 2008, and Oracle
• Features more than fifty sample projects with detailed illustrations and explanations to help students understand key techniques and programming technologies
• Includes downloadable programming codes and exercise questions

This book provides undergraduate and graduate students as well as database programmers and software engineers with the necessary tools to handle the database programming issues in the Visual Studio.NET environment.

Whether you are using WinForms, WebForms, or Web Services, Database Access with Visual Basic® .NET, Third Edition, is your practical guide to developing database applications with Visual Basic .NET and ADO.NET. The authors provide real-world solutions to the data-access issues Visual Basic .NET developers face every day and share their secrets for becoming a more effective database programmer using .NET technologies.

The book begins by reviewing the fundamentals of database development, Structured Query Language (SQL), and Microsoft SQL Server™ 2000. It then examines how to use the major ADO.NET objects to access data stored in relational databases. Through detailed examples, readers learn how to use properties and methods, as well as more advanced features and techniques. Extensive code listings in Visual Basic .NET illustrate each concept, while business cases apply concepts to real-world applications. The final chapters provide a solid examination of how XML and ASP.NET integrate with ADO.NET to create various types of database applications. A companion Web site provides the code used in the book's myriad examples, all of which is compatible with Visual Basic .NET 2003.

Key topic coverage includes:

SQL queries and commands

Using SQL Server 2000

ADO.NET objects

Advanced ADO.NET features and techniques

SQL Server and OLEDB, as well as ODBC .NET Data Providers

Using Visual Studio .NET Data Projects for managing SQL Scripts

Integrating XML with ADO.NET

Developing Web-based database applications with ASP.NET

Web services and middle-tier objects

Database Access with Visual Basic® .NET, Third Edition, equips VB developers with the knowledge and skills needed to build a powerful new generation of database applications in less time using .NET technologies.

0672323435B01092003

Unlike most other database programming books, which discuss and present database programming techniques through huge blocks of programming code, this book uses a unique writing style to show readers how to develop professional and practical database programs using Visual Basic.NET 2005 Design Tools and Wizards related to ADO.NET 2.0, and to apply codes that are auto-generated by using Wizards. Avoiding overly large blocks of code, the book shows a simple and easy way to create database programs and enable the reader to build professional and practical databases more efficiently. In addition to Design Tools and Wizards, the runtime object method is also discussed and analyzed to allow users to design and implement more sophisticated data-driven applications with complicated coding techniques. Three popular database systems - Microsoft Access, SQL Server 2005, and Oracle Database 10g Express Edition (XE) - are discussed in detail, with practical examples and sample projects. This book will attract college students, programmers, and software engineers alike. Sample code and additional exercise questions for students, as well as solutions and lecture slides for instructors are available via the web (www.cambridge.org/9780521712354).

ASP.NET 4 is the principal standard for creating dynamic web pages on the Windows platform. Pro ASP.NET 4 in VB 2010 raises the bar for high-quality, practical advice on learning and deploying Microsoft's dynamic web solution.

This edition is updated with everything you need to come to grips with version 4 of ASP.NET, including coverage of ASP.NET MVC, ASP.NET AJAX 4, ASP.NET Dynamic Data, and Silverlight 3.

Seasoned .NET professionals Matthew MacDonald and Mario Szpuszta explain how you can get the most from these groundbreaking new technologies. They cover ASP.NET 4 as a whole, illustrating both the brand-new features and the functionality carried over from previous versions of ASP. This book will give you the knowledge you need to code real ASP.NET 4 applications in the best possible style.

What you’ll learn

• Understand why ASP.NET 4 is so special, what its fundamental principles are, the basics of Visual Studio, and how ASP.NET controls are created and how they fit into ASP.NET pages, ultimately creating full applications.
• Become familiar with ASP.NET MVC, one of the biggest additions to ASP.NET 4, and understand how to use it and integrate it within your existing ASP.NET applications.
• Discover the intricacies of ADO.NET and how to perform data binding to many sources, from databases to file streams to XML.
• Learn the various forms of security available and how to best apply them. Once considered the Achilles' heel of all Windows web applications, security has vastly improved and is now a cornerstone of ASP.NET 4.
• Examine in detail advanced user interface techniques, including user controls, customer server controls, client-side JavaScript, GDI+, and Silverlight 3.
• Understand how to work with web services, an important skill in an increasingly connected world.
• Use ASP.NET AJAX 4, with an emphasis on contemporary web development techniques.
• Perform development using Internet Information Services 7, Microsoft's premier web hosting platform.

Who this book is for

This book is for anyone with some software development experience who is interested in the .NET Framework 4 and the VB language. Whether you are moving to .NET for the first time or are already writing applications on .NET 2.0 or .NET 3.5, this book will provide you with a comprehensive grounding in the new technology and serve as a complete reference throughout your coding career.

Table of Contents

1. Introducing ASP.NET
2. Visual Studio
3. Web Forms
4. Server Controls
5. ASP.NET Applications
6. State Management
7. ADO.NET Fundamentals
8. Data Components and the DataSet
9. Data Binding
10. Rich Data Controls
11. Caching and Asynchronous Pages
12. Files and Streams
13. LINQ
14. XML
15. User Controls
16. Themes and Master Pages
17. Website Navigation
18. Website Deployment
19. The ASP.NET Security Model
20. Forms Authentication
21. Membership
22. Windows Authentication
23. Authorization and Roles
24. Profiles
25. Cryptography
26. Custom Membership Providers
27. Custom Server Controls
28. Graphics, GDI+, and Charting
29. JavaScript and Ajax Techniques
30. ASP.NET AJAX
31. Portals with Web Part Pages
32. MVC
33. Dynamic Data
34. Silverlight

“Rebecca provides an invaluable resource to help developers focus on a commonly overlooked but vital part of an application—the user experience.”
—David Sceppa, Program Manager, Microsoft Corporation

“Rebecca Riordan takes UI programming and practices to new heights. She has gone byond simply explaining the theory behind UI programming practices, providing code samples that are practical, well-documented, and can be immediately incorporated into a development project.”
—Wendy Chun, AVP/Product Development, SunGard Insurance Systems

“Riordan has produced what is THE reference guide on user interface design in .NET. Serious developers and beginners alike will learn both design techniques that can put applications over the top and pitfalls to avoid.”
—Kelly J. Martens, Manager, Information Systems and Development, JJ Koepsell Company

Build Outstanding User Interfaces with .NET: Principles, Techniques, and Code

Nowadays, users and clients demand exceptionally usable software. But few developers are trained to create high-quality user interfaces, and few .NET books offer much help—until now.

In Seeing Data, Microsoft MVP Rebecca M. Riordan shows how to use .NET’s advanced UI tools to build applications that reflect today’s interface design best practices. She offers visual examples, code, and techniques for every .NET project.

Writing for experienced .NET developers, Riordan introduces core principles of effective interface design—including focus, flow, alignment, proximity, contrast, and consistency. She demonstrates how to architect databases for better usability, and how to build more effective form layouts. Next, she systematically tackles user interaction, showing how to:

• Help users navigate DataSets, manipulate data, and generate reports
• Utilize menus, toolbars, buttons, and Help systems
• Enforce data integrity
• Simplify installation and customization

Riordan covers essential technical underpinnings ranging from GDI+ Managed Classes to ADO.NET data binding. She presents dozens of Visual Basic .NET examples—all designed for easy, quick reuse, and downloadable from the book’s companion Web site, along with C# equivalents.