Dapper Tutorial - Knowledge Base (KB)

Azure SqlException: Database on server is not currently available

Our site has been running for a few weeks in Azure without getting this error:...SqlException: Database 'database' on server 'server' is not currently available. Please retry the connection later. If the problem persists, contact customer support, a...

Azure SQL Database: "No columns were selected" when calling a stored procedure using Dapper

I have a really simple stored procedure in Azure SQL Database:...CREATE PROCEDURE dbo.spfindPartialIdentity @ClientId nvarchar(50), @ExternalId nvarchar(250) AS BEGIN SET NOCOUNT ON; SELECT ClientId, ExternalId FROM [db...

SQL Azure connection closed for large json strings

I'm trying to save a largish json string (c.2Mb) to a NVARCHAR(MAX) column in a SQL Azure database but get the following exception:...[SqlException (0x80131904): A transport-level error has occurred when sending the request to the server. (provider: TCP P...

Http Handler/Azure SQL concurrency issue

I have the following situation, one web app, running under ...IIS... on ...Azure App Service.... Said app, connect to a database on ...Azure Sql... to update records on a table. My problem is that two calls made really, really close seems to be calling IN...

Bulk data processing using dapper and data warehouse

I am using dapper in front end to process the data and inserting it into data warehouse. I have a scenario where i need to send bulk data from from dapper to data warehouse and perform few operation on it. I can do that using data table. i can create a da...