public WordProbability GetWordProbability(string category, string word)
{
WordProbability wp = null;
var matchingCount = 0;
var nonMatchingCount = 0;
OdbcConnection connection = null;
try
{
connection = (OdbcConnection)connectionManager.GetConnection();
IDbCommand command = new OdbcCommand("SELECT " + matchCountColumn + ", " + nonMatchCountColumn + " FROM " + tableName + " WHERE " + wordColumn + " = ? AND " + categoryColumn + " = ?", connection);
command.Parameters.Add(new OdbcParameter("@Word", OdbcType.VarChar, 255, ParameterDirection.Input, true, 0, 0, string.Empty, DataRowVersion.Proposed, word));
command.Parameters.Add(new OdbcParameter("@Category", OdbcType.VarChar, 20, ParameterDirection.Input, true, 0, 0, string.Empty, DataRowVersion.Proposed, category));
var reader = command.ExecuteReader();
if (reader.Read())
{
matchingCount = (int)reader[matchCountColumn];
nonMatchingCount = (int)reader[nonMatchCountColumn];
}
reader.Close();
wp = new WordProbability(word, matchingCount, nonMatchingCount);
wp.Category = category;
}
catch (Exception ex)
{
throw new WordsDataSourceException("Problem obtaining WordProbability from database.", ex);
}
finally
{
if (connection != null)
{
try
{
connectionManager.ReturnConnection(connection);
}
catch {}
}
}
Debug.WriteLine("GetWordProbability() WordProbability loaded [" + wp + "]");
return(wp);
}
