SQLServerで実行されたSQLやストアドをキャプチャする方法 ref: https://qiita.com/zaki_zaki/items/799928cf0b225b10b4d4

01_create_table.sql

use SampleDB

if exists(select obj.* from sys.objects as obj where obj.name = N'SampleTable')
begin
    drop table SampleTable
end

create table SampleTable
(
    id          int
,   sample_name nvarchar(max)
,   option_a    nvarchar(max)
)

insert into SampleTable select 1, N'AAA', N''
insert into SampleTable select 2, N'BBB', N'a'
insert into SampleTable select 3, N'CCC', N''
insert into SampleTable select 4, N'AAA', N'a'

02_create_procedure.sql

USE SampleDB

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

DROP PROCEDURE GetSampleTable
GO

CREATE PROCEDURE GetSampleTable
    @sample_name    NVARCHAR(MAX) = null
,   @option_a       NVARCHAR(MAX) = null
AS
BEGIN
    SET NOCOUNT ON;

    SELECT * FROM SampleTable WHERE
        (@sample_name IS NULL OR sample_name = @sample_name) AND
        (@option_a IS NULL OR option_a = @option_a)
END
GO

Form1.cs

        private string CreateConnectionString()
        {
            // 接続文字列生成
            var conStrBuilder = new SqlConnectionStringBuilder()
            {
                DataSource = "localhost",
                InitialCatalog = "SampleDB",
                UserID = "sa",
                Password = "pass"
            };
            return conStrBuilder.ToString();
        }