May 2004 - Posts
I've been reading about the new additions coming in ADO.NET 2.0. One of them is a “Provider Factory” (DbProviderFactory) interface for creating connections in a more abstract fashion. To read about how it works:
Need similar functionality today? Try the Provider Factory which has been part of the Mono class library for quite a while. And, of course, it works on regular .NET too! I'm glad Microsoft liked my idea. :-)
ADO.NET is missing an extensible architecture for accessing database schema information. While there are ways to get this information using the OLE provider, or importing the old ADO COM libraries, there doesn't seem to be a pure managed code method.
Hopefully, the new SharpDBSchema library changes this. It is designed using a provider pattern which will allow each database provider to implement a method for collecting schema information. The initial version includes the basic interfaces, factory-based provider creation using a configuration file, and a MS SQL Server schema provider.
Any feedback would be appreciated.
My home page is now .NET powered @ www.dotnetpowered.com! It has projects I've been working on as well as .NET resources.
The .NET resources include:
Methods for hosting ASP.NET applications
.NET Remoting Channels, Formatters, etc.
Mono Beta 1 has been released. See the Release Notes, or go directly to the download page.
For more information about the Mono release schedule, take a look at the Roadmap.