Bob Beauchemin'sData Samples and Tools PageThis page contains utilities, code samples, helper classes, and whitepapers, mainly centered around SQL Server, .NET Data Access, and Web Services. My official DevelopMentor bio is available at http://www.develop.com/dm/staff.asp by clicking on my name. Follow the links on the right to the events I'm speaking at. |
|
I've posted some sample code that uses the new SOAP sessions feature on HTTP endpoints in SQL Server 2005 B2. Follow the link at "Code You Can Download" list below.
I've started a blog at http://staff.develop.com/bobb/weblog.
The first attempt at posting the sample code from First Look at SQL Server 2005 For Developers book. Mostly this is raw code, cut and pasted into projects. I'll be posting more updates soon.
The first set of updates to the First Look at SQL Server 2005 For Developers book has been posted. Although the book is based on SQL Server 2005 material, there were some last minute changes made by the product teams, particularly on the client side, the didn't make it into the book. Read about them here. Updates are being posted weekly (or more frequently) as I'm more aware of them.
ADO.NET 2.0 has a new provider model based on base classes in System.Data.Common. I've updated my sample provider MDirProv2 to use the new architecture and also added a Provider Factory class. Read more about this in my MSDN article on ADO.NET 2.0 features. They'll be two additional upcoming articles dealing with data providers also.
A First Look at SQL Server 2005 For Developers, a book that I wrote with Niels Berglund and Dan Sullivan was released June 28 by Addison-Wesley. It is based on the upcoming beta 2 release of SQL Server 2005, previously codenamed "Yukon". The book's official page at Addison-Wesley is here. The book's code download, updates, and errata site is available, but is quite empty at the moment. We'll be retesting all the examples with the official beta 2 release soon.
One of the reviewers on Amazon commented that the listing numbers for the posted code samples for Essential ADO.NET did not correspond to the listing numbers in the book itself. I've updated the code samples to correspond, posted the missing EnterpriseServices example from chapter 3, and also updated the errata page. Download the updated code here.
Enjoy!
| Name | Description |
|---|---|
| SOAP Session Samples | Examples of using SQL Server 2005 B2 HTTP endpoints with Visual Studio 2005 clients. This uses "add web reference" to access the endpoint. Read the corresponding blog entry for more details. |
| MDirProv2_For_ADO.NET 2.0 | An update of the sample data provider for ADO.NET 2.0 using base classes and factories. |
| Migrating Data Access Code whitepaper | This paper discusses migration issues and database-specific behaviors exposes by native data providers. |
| WS-Inspection Samples | Samples that use the Web Service Inspection Language protocol for .NET RTM. Includes whitepaper. |
| MDirProv2 | Data provider for the file system updated to .NET RTM version |
| ProcessListReader | Mike Woodring's IDataReader process snapshot sample |
| OracleSP | Using Oracle refcursors with ADO.NET. Examples for Microsoft and Oracle providers |
| Access_autonum | Using Access autonumber columns and inserts with the DataSet and DataAdapter |
| Getprovs | Returns the OLE DB Root Enumerator's sources rowset as an ADO Recordset |
| ATLOLEDB25 | ATL Consumer Templates for OLE DB 2.5 |
| WizardProv_SQL7 | A Word document enumerating the changes that must be made to the default provider made by the ATL Provider Template Wizard to work with as a SQL Server 7 Linked Server. |
| MultiParm | Two extension classes for using multiple sets of parameters in a single call with ATL consumer templates |
| OLEDB_Extras | Some extension classes, dealing with chapters and accessors, named accessors and an "attachable accessor" for using with providers. By Mark Dawson. |
| ShapeChild | Class for using Child Rowset with a chapter. By Ron Jacobs |
| MakeMDB | A simple way to create a new Access database through ATL consumer templates |
| OLEDBBlob | An OLE DB consumer class and paper dealing with updating and inserting blob data. By Michael Brannan. |
| OLEDB2ADO | A simple component that does data access using OLE DB then returns an ADO Recordset crafted using the ADORecordsetConstruction interface. |
| OLEDBUtil | Allows you to prompt the user for OLE DB/ADO connection information using the system standard wizardsheet. It's a simple shim component usable in any language with an example of its use in Visual Basic/ADO |
| MDATL | An include file, atlschmd.h, that extends the ATL schema classes to include the Multidimensional (OLE DB for OLAP) schemas. Also, an example of its use, including a working version of the sample OLE DB for OLAP SDK code fragments |
| VSA Test | A simple component that sends out user-defined events to be caught by Visual Studio Analyzer |
| COM+ Pooled Resource object using OLE DB | COM+ object pooling will enable you to use pooled objects as simple resource dispensers. Here's the example from my talk about it at 1998 PDC. You can download the slides too. Requires Nov 1998 platform SDK to build and COM+ Preview from NT5 beta2 or above to run. Includes simple test program in VB. |
