I've always worked with code first and using only one database. However, I need to work with an application with two databases already created.
To work with two databases, I created this:
Passing:
Receiving:
Now, how can I easily work to reuse existing banks, including views?
For read-only contexts, add the following in the context class:
public override int SaveChanges()
{
throw new AccessViolationException(
"Contexto é somente leitura.");
}
public override async Task<int> SaveChanges()
{
throw new AccessViolationException(
"Contexto é somente leitura.");
}
This ensures that the context can not make changes to the database.
On the plus side, I think you're already using it accordingly.