datalab icon indicating copy to clipboard operation
datalab copied to clipboard

Another Tds client

Open Anderman opened this issue 3 years ago • 0 comments

4 years ago I did a almost complete rewrite of the sqlClient for fun and to do some performance test. The bulk insert was fast but for small queries the improvement was small. Most of the time was spend on the sql server and communication. Async was wrong implemented and probably much more but a lot could be simplified.

the Repo can be found here.

The old repro was based on a data reader and writer. I skipped that part and did the reading and writing directly to a poco. I think with EF core this should also possible. There is some mapping between sql fields and poco properties and there are some value convertors.

Directly converting json strings from the input stream will skip the copy part.

Anderman avatar Mar 08 '22 22:03 Anderman