C# (CSharp) SSMS Ado Examples

Example #1

        public IActionResult SqlCommand([FromRoute] string sqlCommand)
        {
            int rows = Ado.ExecuteNonQuery(sqlCommand);

            return(Ok($"{rows} row(s) affected ..."));
        }

Example #2

        public IActionResult Query([FromRoute] string sql)
        {
            var result = Ado.ExecuteQuery(sql);

            return(Ok(result));
        }