title: SqlKata - Oracle example program
body: <p>I wonder if anyone can provide me with a simple program that connects to the database and performs a query against an Oracle database using SqlKata.</p>
  <p>Please also tell what one needs to install.</p>
  <p>This is my code so far:</p>
  <pre><code>using SqlKata.Compilers;
  
  using SqlKata.Execution;
  
  using System.Data.OracleClient;
  
  var connection = new SqlConnection(&quot;Data Source=tellus:1526/aom19c;User Id=Test1;Password=TEST1&quot;);
  
  var compiler = new OracleCompiler();
  
  var db = new QueryFactory(connection, compiler);
  
  var parts = db.Query(&quot;part&quot;).Get();
  
  Console.WriteLine(parts);
  </code></pre>