title: Dapper and Oracle CRUD issues, how to?
body: <p>How do i make Dapper.NET to CRUD my Oracle DB?</p>
  
  <p>I have table named: <code>PLAYER_LOG</code> it's identity is done by trigger, here is the sql</p>
  
  <pre><code>SELECT SQ_MASTER_SEQUENCE.NEXTVAL INTO tmpVar FROM dual;
  :NEW.ID := tmpVar;
  </code></pre>
  
  <p>my Model is:</p>
  
  <pre><code>public class PlayerLogStorage : IEntity //-&gt; here is the identity
  {       
      public string Cli { get; set; }
      public string PlayerAnswer { get; set; }
      public DateTime InsertDate { get; set; }
  }
  </code></pre>
  
  <p>here is my insert:</p>
  
  <pre><code> using (IDbConnection ctx = DbConnectionProvider.Instance.Connection)
   {
              ctx.Query&lt;PlayerLogStorage&gt;("INSERT INTO PLAYER_LOG (CLI, ANSWER, INSERT_DATE) VALUES (:Cli, :PlayerAnswer, :InsertDate)", new
              {
                  Cli = model.Cli,
                  PlayerAnswer = model.PlayerAnswer,
                  InsertDate = model.InsertDate
              });
   }
  </code></pre>
  
  <p>here is the exception:</p>
  
  <pre><code>ORA-01008: not all variables bound
  </code></pre>