CODEWITHSUNDEEP
c#sql-serversocketsdriver
hoodoos
hoodoos

Reputation: 360

Custom SQL Server driver

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. :)

Upvotes: 0

Views: 866

Answers (2)

S.Skov
S.Skov

Reputation: 717

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.

Upvotes: 2

Cade Roux
Cade Roux

Reputation: 89741

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.

Upvotes: 2

Related Questions