Custom SQL Server driver

Question

I had a crazy thought about writing my own SQL Server driver to make it work something like non-blocking http client, so it won't be thread thirsty and could handle lots of db queries within one thread.

I tried to look over google for some guidelines about implementing SQL Server client protocol, but found none really, where do those guys get information about it when they write own implementations for PHP or python?

I need a really low level to be documented so I can implement all phases of working with a connection through sockets. And would be really nice to have a an example in c# language. :)

Answer 1

I regularly use the existing Async functionality in the .NET SQLClient, this easily allows additional threads to handle the database operations.

I'm not sure how you would really handle multiple non-blocking operations in the same thread.

Answer 2

MSSQL Protocol specs:

http://www.microsoft.com/downloads/details.aspx?familyid=91ef5106-944a-41e1-b3a0-5bd3f2356f32&displaylang=en

Without knowing anything factual about it, I would guess that PHP et al, use either the native MSSQL API or they use the standardized ODBC - warping around at the protocol level is just asking for it.