public TrascodingTokenizer(OleDbConnection conn, ReaderWriterLock aLock, String tableName, bool caseSensitive, String keyField, String descField) { this.conn = conn; this.aLock = aLock; this.caseSensitive = caseSensitive; keyContext = tableName + ".key"; descContext = tableName + ".desc"; Cache.AddContext(keyContext); Cache.AddContext(descContext); findKey = new OleDbCommand(); findKey.Connection = conn; findKey.CommandText = String.Format(SELECT, new Object[] { tableName, keyField, descField }); findKey.Parameters.Add("@value", OleDbType.VarChar); findDesc = new OleDbCommand(); findDesc.Connection = conn; findDesc.CommandText = String.Format(SELECT, new Object[] { tableName, descField, keyField }); findDesc.Parameters.Add("@key", OleDbType.Integer); addKey = new OleDbCommand(); addKey.Connection = conn; addKey.CommandText = String.Format(INSERT, new Object[] { tableName, keyField, descField }); addKey.Parameters.Add("@value", OleDbType.VarChar); }