public void GetSequenceTest() { long id; using (iDB2Connection conn = new iDB2Connection(DB2Helper.ConnectionString)) { id = DB2Helper.GetSequence(conn, "USER"); } Assert.AreNotEqual(id, 0); }
public void create(User user) { string sql = "INSERT INTO \"USER\"(USER_NO,USERNAME,PASSWORD) VALUES(@USER_NO,@USERNAME,@PASSWORD)"; using (iDB2Connection conn = new iDB2Connection(DB2Helper.ConnectionString)) { conn.Open(); long userNo = DB2Helper.GetSequence(conn, "USER"); iDB2Parameter[] parms = new iDB2Parameter[] { new iDB2Parameter("@USER_NO", userNo), new iDB2Parameter("@USERNAME", user.username), new iDB2Parameter("@PASSWORD", user.password) }; DB2Helper.ExecuteNonQuery(conn, CommandType.Text, sql, parms); } }