Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

saving a new word to the database when encrypting a message doesn't close the database connection #8

Open
acnicholls opened this issue Jul 2, 2021 · 0 comments
Assignees
Labels

Comments

@acnicholls
Copy link
Owner

Describe the bug
Ignore the fact that it's spelt wrong

2021-07-01 8:22:28 PM, FindWordValue, Searching for word : millionare
2021-07-01 8:22:35 PM, CheckDatabaseForWord, Checking Word : millionare
2021-07-01 8:22:35 PM, CheckDatabaseForWord, -------------------------------------------------------------------

2021-07-01 8:22:35 PM, CheckDatabaseForWord, The connection was not closed. The connection's current state is open.

2021-07-01 8:22:35 PM, CheckDatabaseForWord,    at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
   at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry)
   at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry)
   at System.Data.SqlClient.SqlConnection.Open()
   at cypher.data.classes.Dictionary.CheckDatabaseForWord(String word) in A:\source\githubRepos\Cypher\dev\cypher_data\cypherData\classes\Dictionary.cs:line 107

2021-07-01 8:22:35 PM, CheckDatabaseForWord, -------------------------------------------------------------------

2021-07-01 8:22:35 PM, AddWordToDatabase, Adding Word : millionare
2021-07-01 8:22:35 PM, CalcWordValue, Word Value for : millionare : 108
2021-07-01 8:22:35 PM, AddWordToDatabase, Row Added : millionare : 108 : Result : -1

To Reproduce
Steps to reproduce the behavior:

  1. type a message in that contains a word that is not yet in the database
  2. when prompted to save the word, click yes
  3. user will not see the error, but it's logged

Expected behavior
connections should be closed.

Screenshots

Additional context

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

1 participant