Exemplos de BaseDataAccess.GetParameter em C# (CSharp)

Exemplo n.º 1

        static void RunQueryUsingSqlParameter(string input)
        {
            var query        = $"SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME LIKE @@table_name";
            var localDb      = new BaseDataAccess($"Data Source=;Initial Catalog=;Persist Security Info=True;User ID=sa;Password=W!nni3_P00h;");
            var sqlParameter = localDb.GetParameter("@@table_name", input);
            var results      = localDb.ExecuteCommand(query, CommandType.Text, new[] { sqlParameter });

            PrintDataSet(results);
        }