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.
Read Online or Download Professional ADO.NET 2 : programming with SQL Server 2005, Oracle, and MySQL PDF
Similar oracle books
За последние 10 лет книга Oracle PL/SQL Programming издательства O'Reilly's стала бестселлером среди книг по PL/SQL, процедурному языку базы данных Oracle. Снабженная примерами и полезными рекомендациями книнга является незаменимой как новичкам, так и гуру, как разработчикам на Oracle kinds, так и администраторам - используйте PL/SQL на полную мощь.
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 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.
- Building Database Clouds in Oracle 12c
- Linux Recipes for Oracle DBAs (Expert's Voice in Oracle)
- Oracle PL/SQL For Dummies
- Beginning Oracle Application Express (Wrox Programmer to Programmer) New Edition by Greenwald, Rick published by John Wiley & Sons (2008)
- Oracle E-Business Suite Development & Extensibility Handbook (Oracle Press)
- PeopleSoft for the Oracle DBA (Oaktable Press)
Extra resources for Professional ADO.NET 2 : programming with SQL Server 2005, Oracle, and MySQL
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.