How to force schema to be used in all selects?

I would like to know how to force db schema to be written into generated sql from Expressions. Some POCOs have attribute [Schema(“foo”)] , but the others assume “dbo”.

Is there a setting tucked away that can force all generated select statements to include schema definition? There are scenarios where not including it can cause MsSQL server to not cache the compilation of the request.


No there’s no other way to specify for a table should use a specific Schema.