Is it a good practice to manage SQLite connection in a DbContext class?
I am writing a program that uses SQLite, and it seemed strange to me to open and close the connection every time I use the database, so I decided to use this in the context class. Is this a normal practice, or can it cause problems?