Question : I may be missing some pieces to this puzzle, but this is what I have: All of this […]
Tag: ado.net
Use serial ID for multiple columns and return it from INSERT
Question : I am using Npgsql and I want to be able to do an insert, and if statement that […]
How can I setup and use a PostgreSQL database without installing a driver?
Question : I have a portable PostgreSQL database that runs perfectly on my computer as a database server. This is […]
SSMS returns results immediately; ADO takes longer
Question : I am running a query that returns ~250k results. It is basically SELECT * FROM my_schema.my_view (and the […]
Trying to get a large amount of data (column type is “text”) from an MS SQL Server
Question : I want to get like 300MB of data (text column) out of an MS SQL Server, but with […]
What is the purpose of sqlbulkcopy’s useinternaltransaction property?
Question : I’m just testing my PowerShellScript to do bulkcopy of multiple tables between sql-server and oracle Databases. When the […]
Exception when calling Postgresql function returning a local numeric from C#
Question : I wrote a Postgresql function to insert a row and return the value generated from the identity column. […]
Joining tables on DB server vs App-Backend server
Question : I have two tables stored on the DB server. I need to join these two tables and perform […]
Will these two queries result in a deadlock if executed in sequence?
Question : This is almost certainly the cause of my other question, but I thought it was worth separating the […]
Joining tables on DB server vs App-Backend server
Question : I have two tables stored on the DB server. I need to join these two tables and perform […]