Archives

Archives / 2004 / May
  • ADO.NET Provider Factory

    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:

  • SharpDbSchema 0.1 available

    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.