Guest User

Untitled

a guest
Feb 28th, 2017
127
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.00 KB | None | 0 0
  1. using System;
  2. using System.Collections.Generic;
  3. using System.Linq;
  4. using System.Text;
  5. using System.Threading.Tasks;
  6. using Oracle.DataAccess.Client;
  7. namespace MinimalConsoleProject
  8. {
  9. class Program
  10. {
  11. static void Main(string[] args)
  12. {
  13. string s = "select * from USERS where NAME = 'Foo'";
  14. string b = parameterizedQuery(s);
  15. Console.Out.Write("Hello, World!");
  16. while (true) {; }
  17. }
  18.  
  19. public static string parameterizedQuery(string s)
  20. {
  21. OracleConnection conn = new OracleConnection("idk lol");
  22. OracleCommand command = new OracleCommand();
  23. command.CommandText = s;
  24. var pNames = new OracleParameter("thisParameterDoesntActuallyExist", "foo");
  25. command.Parameters.Add(pNames);
  26.  
  27. command.Connection = conn;
  28. conn.Open();
  29. var reader = command.ExecuteReader();
  30.  
  31. return command.ToString();
  32. }
  33.  
  34. }
  35. }
Advertisement
Add Comment
Please, Sign In to add comment