Professional ADO.NET 2 : programming with SQL Server 2005, by Wallace B. McClure

By Wallace B. McClure

ADO.NET revolutionized the way in which facts was once accessed via SQL Server, Oracle, and MySQL. With Microsoft's free up of ADO.NET 2, ADO and the .NET Framework are built-in with SQL Server for the 1st time-enabling you to application .NET functions at once in the SQL Server database.

Packed with pattern code and instructed top practices for utilizing ADO.NET 2, this code-intensive e-book explores the hot information forms which are to be had within the 2.0 Framework and discusses the proper time and solution to use them. you will how one can make repetitive, mundane initiatives a lot less complicated and you can stroll away with a high-quality beginning for constructing database-driven applications.

What you'll examine from this book

  • The fundamentals of constructing a connection, executing a question, and returning a result
  • Best makes use of for Oracle within the ADO.NET Framework
  • The many new positive aspects which are on hand for XML
  • How to take advantage of the complete textual content seek functions of Microsoft(r) SQL Server 2005
  • Methods for retrieving information and proposing it in a number of ways
  • Why MySQL is a manageable choice for info storage

Who this booklet is for

This ebook is for skilled database builders who are looking to research the newest free up of ADO.NET 2.0. wisdom of ADO.NET 1.0, normal .NET improvement, and Microsoft SQL Server is necessary.

Wrox specialist courses are deliberate and written through operating programmers to satisfy the real-world wishes of programmers, builders, and IT pros. concentrated and proper, they tackle the problems know-how execs face on a daily basis. they supply examples, sensible recommendations, and specialist schooling in new applied sciences, all designed to assist programmers do a greater job.

Show description

Read Online or Download Professional ADO.NET 2 : programming with SQL Server 2005, Oracle, and MySQL PDF

Similar oracle books

Oracle PL/SQL Programming 4Th Edition

За последние 10 лет книга Oracle PL/SQL Programming издательства O'Reilly's стала бестселлером среди книг по PL/SQL, процедурному языку базы данных Oracle. Снабженная примерами и полезными рекомендациями книнга является незаменимой как новичкам, так и гуру, как разработчикам на Oracle kinds, так и администраторам - используйте PL/SQL на полную мощь.

Oracle Streams 11g Data Replication

Grasp Oracle Streams 11g Replication allow real-time info entry and information sharing throughout your allotted framework utilizing the specialist info during this Oracle Press advisor. Oracle Streams 11g information Replication explains how you can arrange and administer a unified firm information sharing infrastructure.

Oracle Application Express 4 Recipes

Oracle software convey four Recipes offers an example-based method of studying software show - the ground-breaking, fast program improvement platform integrated with each Oracle Database license. The recipes layout is perfect for the quick-study who simply wishes a great instance or to kick commence their considering and get pointed within the correct path.

Extra resources for Professional ADO.NET 2 : programming with SQL Server 2005, Oracle, and MySQL

Example text

Most people wouldn’t argue with the belief that it is far easier to write an OLE-DB provider than an ODBC driver. A provider needs to perform only four basic steps: 1. 2. 3. 4. Open the session. Process the command. Access the data. Prepare a rowset. OLE-DB Consumers The other half of the OLE-DB framework is the OLE-DB consumer. The consumer is the layer that speaks directly to the OLE-DB providers, and it performs the following steps: 1. 2. 3. 4. Identify the data source. Establish a session. Issue the command.

Second, developers can have a common framework for data access when switching between programming languages, making the transition to new languages easier. NET and C#. Third, it enables developers to more easily write a single application that can be deployed against multiple data stores. Finally, it provides a level of abstraction between the application and direct communication to the database to simplify the code the average developer needs to write. Microsoft has conducted surveys to determine which key factors companies are looking for in a data access layer.

5 Chapter 1 Application OLE-DB Consumer OLE-DB Provider Data Store Data Source Specific API Figure 1-1 Data Access Consumers Developers who use languages that support pointers — such as C, C++, VJ++, and so on — can speak directly to the ODBC and OLE-DB APIs. However, developers using a language such as Visual Basic need another layer. NET come into play. 0, developers were introduced to a new method for accessing data, known as Data Access Objects (DAO). This was Microsoft’s first attempt to create a data consumer API.

Download PDF sample

Rated 4.69 of 5 – based on 34 votes