using System;

using Microsoft.Data.SqlClient;

public class Program

{

    public static void Main()

    {

        Console.WriteLine("Hello World");

​

        string commandText = "SELECT * FROM dbo.Files WHERE CustomerID = @ID;";

        SqlCommand command = new SqlCommand(commandText);

        command.Parameters.AddWithValue("@ID", "mem");

        Console.WriteLine(command.CommandText + "\n\n");    

        LogSQL(command);

    }

        private static void LogSQL(SqlCommand cmd)

        {

            string query = cmd.CommandText;

​

            foreach (SqlParameter prm in cmd.Parameters)

            {

                switch (prm.SqlDbType)

                {

                    case System.Data.SqlDbType.Bit:

                        int boolToInt = (bool)prm.Value ? 1 : 0;

                        query = query.Replace(prm.ParameterName, string.Format("{0}", (bool)prm.Value ? 1 : 0));

                        break;

                    case System.Data.SqlDbType.Int:

                        query = query.Replace(prm.ParameterName, string.Format("{0}", prm.Value));

                        break;

                    case System.Data.SqlDbType.VarChar:

                        query = query.Replace(prm.ParameterName, string.Format("'{0}'", prm.Value));

                        break;

                    default:

                        query = query.Replace(prm.ParameterName, string.Format("'{0}'", prm.Value));

                        break;

                }

            }

​

            // the following is my how I write to my log - your use will vary

            Console.WriteLine("{0}", query);

​

            return;

        }

}