[Mono-list] System.Data.SqlClient Status

Tim Coleman tim@timcoleman.com
Fri, 25 Oct 2002 14:20:50 -0400

Here's some information on the current status of the Mono class
libraries for access to SQL Server databases.

The internal TDS API is now stabilizing, so I think the timing
is appropriate to branch out the provider into System.Data.SqlClient,
while maintaining separate code for the Mono.Data.TdsClient.

The SqlClient will use TDS version 7.0, which is used by 
Microsoft SQL Server 7 and 2000.  The TdsClient uses TDS 
version 4.2, which is supported by both Microsoft and Sybase.

It is possible to connect and run some simple queries using
commands and datareaders.  The connection objects support
connection pooling, although there is still some implementation
to be done in that area.

At this point, I think it is appropriate for another member of the
Mono ADO.Net team to take up the System.Data.SqlClient namespace,
and I will continue to work on the internal TDS code, and I will
use the generic TDS provider to test as I progress.  I also have
a Sybase database now, so I'll be able to start on a 
Mono.Data.SybaseClient provider as well.

At the moment, there appears to be a problem with executing a
query with TDS 7.0.  I'm sure I'll fix it soon though :)

Tim Coleman <tim@timcoleman.com>                       [43.28 N 80.31 W]
BMath, Honours Combinatorics and Optimization, University of Waterloo
Software Developer, Global Services, Open Text Corporation
"Under capitalism, man exploits man.  Under communism, it's just the
 opposite." -- J.K. Galbraith