ADO.NET

Abstract: The definitive guide to using Microsoft Visual C#™ .NET to develop stand-alone applications for Microsoft Windows and Web-enabled Microsoft .NET applications Microsoft ActiveX® Data Objects .NET (ADO.NET) is a set of libraries included with the Microsoft .NET Framework that helps you communicate with data from .NET-based applications-including XML data. Discover how to access, sort, and manipulate data in Web-enabled enterprise applications with this book. You'll get expert guidance and insider tips from a leading database and ADO authority about how to write, test, and debug database code with the tools and wizards in Visual Studio .NET. You'll also learn about the improved ADO.NET object model, its XML features for Web extensibility, its enhanced integration with Microsoft SQL Server™ 2000, and more.

Abstract: Object-oriented programming is the most successful programming paradigm. Relational database management systems are the most successful data storage components. Despite their individual successes and their desirable tight binding, they rely on different points of view about data entailing difficulties on their integration. Some solutions have been proposed to overcome these difficulties, such as Embedded SQL, object/relational mappings (O/RM), language extensions and even Call Level Interfaces (CLI), as JDBC and ADO.NET. In this paper we present a new model aimed at integrating object-oriented languages and relational databases, named CRUD Data Object Model (CRUD-DOM). CRUD-DOM relies on CLI (JDBC) and aims not only at exploring CLI advantages as preserving its performance and SQL expressiveness but also on providing a type state approach for the implementation of the ResultSet interface. The model design aims to facilitate the development of automatic code generation tools. We also present such a tool, called CRUD Manager (CRUD-M), which provides automatic code generation with a complementary support for software maintenance. This paper shows that CRUD-DOM is an effective model to address the aforementioned objectives.

Abstract: From the Publisher: This title is ideal for any developer who seeks guidance on how to exploit the database functionality and advanced, integrated development environment in Microsoft Visual Basic .NET. The book covers core Visual Basic database development topics, with details on using Visual Basic .Net with Microsoft ActiveX® Data Objects (ADO), ADO+, and Microsoft SQL Server™. It's full of insightful explanations and expertly rendered examples for rapid acceleration of development productivity, faster applications, and more powerful results. Master a core set of database programming skills for Visual Basic .NET at your own pace, using the proven Microsoft step-by-step method. The proven Microsoft step by step format makes it easy to learn at your own pace—even for beginning developers. Key Book Benefits: * Get up to speed quickly on using ADO+ and SQL Server with Visual Basic .NET. * Find out about core Visual Basic database development topics, plus details on using Visual Basic .Net with ADO, ADO+, and SQL Server. * Learn at your own pace and practice with real-world examples and insightful explanations for rapid acceleration of development productivity; faster, leaner applications; and more powerful results.

Abstract: This paper describes the ADO.NET Entity Framework, a platform for programming against data that raises the level of abstraction from the logical (relational) level to the conceptual (entity) level, and thereby significantly reduces the impedance mismatch for applications and data services such as reporting, analysis, and replication. The conceptual data model is made real by a runtime that implements an extended relational model (the Entity Data Model aka the EDM), that embraces entities and relationships as first class concepts; a query language for the EDM; a comprehensive mapping engine that translates from the conceptual to the logical (relational) level, and a set of model-driven tools that help create entity-object, object-xml, and entity-xml transformers.