Dotnetcat » .NET Books » Database books

• Build SOA applications on Microsoft platforms
• Apply best practices to your WCF services and utilize Entity Framework to access underlying data storage
• A step-by-step, practical guide with nifty screenshots to create six WCF and Entity Framework solutions from scratch

If you are a C#, VB.NET, or C++ developer and want to get started with WCF and Entity Framework, then this book is for you. Competence in Entity Framework will be needed to follow the examples in the book, but experience in creating WCF services using Entity Framework is not necessary. Developers and architects evaluating SOA implementation technologies for their company will find this book useful.

• Create a WCF service without using the built-in WCF templates so you can understand the versatility of what's going on under the hood
• Explore the…

“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…

Learn to harness the power of Visual Basic for Applications (VBA) in Microsoft Excel to develop interesting, useful, and interactive Excel applications. This book will show you how to manipulate Excel with code, allowing you to unlock extra features, accuracy, and efficiency in working with your data. Programming Excel 2016 with VBA is a complete guide to Excel application development, using step-by-step guidance, example applications, and screenshots in Excel 2016.
In this book, you will learn:

• How to interact with key Excel objects, such as the application object, workbook object, and range object
  
• Methods for working with ranges in detail using code
  
• Usage of Excel as a database repository
  
• How to exchange data between Excel applications
  
• How to use the Windows API to expand the capabilities of Excel
  
• A step-by-step method for producing your own custom Excel ribbon

This book has been fully tested on and is compliant with the official release of NET.

Almost all applications have to deal with data access in some way or another. This book will teach you how to build Visual Basic .NET applications that make effective use of databases. Visual Basic .NET is the latest version of the most widely used programming language in the world, popular with professional developers and beginners alike.

Starting with a guide to the basic principles of database design, we then examine how to query databases and how to access their data - both in Windows applications and remotely using the Internet and Web Services. Every new concept is explained thoroughly with Try It Out examples, plenty of code samples, and end-of-chapter questions to test you.

This book covers:

- The basic principles of relational database design

- Microsoft SQL Server Desktop Engine

- Querying the database with the T-SQL language

- Visual…

• 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

Build your expertise as you move beyond the basics—and delve into the essential topics of programming with ADO.NET 2.0. This comprehensive reference offers expert guidance, hands-on instruction, and code samples in Microsoft Visual C# and Visual Basic to help advance your mastery of developing database applications for Microsoft Windows and the Web.

Discover how to:

• Work with design-time data access features in Microsoft Visual Studio 2005
• Use Microsoft .NET Framework 2.0 data providers to connect to databases
• Build connection strings and enable connection pooling
• Execute queries, including parameterized and asynchronous queries, and retrieve their results
• Create DataSet objects to work with offline data and explore common usage scenarios
• Use the new Common Language Runtime features and XML data type in Microsoft SQL Server 2005
• Generate logic and use stored procedures for simple to advanced updating…

Since its inception during the Great Depression the Dictionary of Occupational Titles has been relied on for the description of jobs and workforce development. However, as global competition and technological change has created a new world of work, the Department of Labor realized that a more flexible and precise system for chronicling work-related information was needed. Thus, the O*NET, or the occupational information network, was launched. Written by the developers of the O*NET system, this edited volume describes the research and methodology used in the design and development of this ground-breaking system. The O*NET is intended to provide a framework for describing jobs in terms that are capable of addressing the needs of workers and employers into the 21st Century. Instead of relying on rigid task descriptions, the O*NET uses domains of worker and occupation characteristics--such as abilities, work styles, generalized work activities and work context--to describe each job…

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…

Begin to Code with C