R.SqlDebugHelper

A helper library to generate T-SQL debug scripts from C# SqlParameter arrays or SqlCommand objects. Perfect for debugging stored procedures in SQL Server.

Installation

Install-Package R.SqlDebugHelper

Or via .NET CLI:

dotnet add package R.SqlDebugHelper

Features

• Generate executable T-SQL scripts from SqlParameter arrays
• Support for SqlCommand objects
• Outputs to Visual Studio Debug Output window
• Handles all common SQL data types

Usage

From SqlParameter Array

using R.SqlDebugHelper;

var parameters = new SqlParameter[]
{
    new SqlParameter("@Id", 1),
    new SqlParameter("@Name", "John"),
    new SqlParameter("@CreatedAt", DateTime.Now)
};

SqlDebugHelper.Print("usp_GetUser", parameters);

From SqlCommand

using R.SqlDebugHelper;

SqlCommand cmd = new SqlCommand("usp_UpdateUser", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Id", 1);
cmd.Parameters.AddWithValue("@Name", "John");

SqlDebugHelper.Print(cmd);

Output

The above will generate and output:

-- SP: usp_GetUser
-- Generated: 2024-01-15 10:30:00
DECLARE 
@Id INT = 1,
@Name NVARCHAR(MAX) = 'John',
@CreatedAt DATETIME = '2024-01-15 10:30:00',
BEGIN
EXEC usp_GetUser @Id, @Name, @CreatedAt
END

Supported Data Types

C# Type	SQL Type
bool	BIT
DateTime	DATETIME
string	NVARCHAR(MAX)
decimal	DECIMAL(18,4)
double	FLOAT
long	BIGINT
Guid	UNIQUEIDENTIFIER

Requirements

• .NET Framework 4.5.2 or higher

License

MIT License - see LICENSE for details.

Author

Ronak Munjapara