Guest User

Untitled

a guest
Jan 16th, 2019
91
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.65 KB | None | 0 0
  1. select * from A; //no problem
  2. select * from B; // no problem
  3. select * from A inner join B on B.id = A.bId; // no problem + joining
  4.  
  5. var cm1 = connection.CreateCommand();
  6. cm1.CommandText = "select * from A;";
  7. var cm2 = connection.CreateCommand();
  8. cm2.CommandText = "select * from B;";
  9. var cm3 = connection.CreateCommand();
  10. cm3.CommandText = "select * from A inner join B on B.id = A.bId;";
  11. ...
  12. var dt1 = cm1.ExecuteReader(); // ok
  13. var dt2 = cm2.ExecuteReader(); // ok
  14. var dt3 = cm3.ExecuteReader(); // crash oracle error ORA-00911 : invalid character
  15.  
  16. cm3.CommandText = "select * from A inner join B on ( B.id = A.bId ) ;";
  17.  
  18. cm3.CommandType = CommandType.Text;
Add Comment
Please, Sign In to add comment