Hello curiousj,
>>One approach would be to create one database and one dbcontext for each project
For first approach, my suggestion is that you might need to increase your database server number and use the
Cluster Service so that you could create 32,767*N(your server number) databases. However, I think this is not very relevant with Entity Framework.
>> I am not sure if there is any performance issue with 32767 live database though.
You could ask it to the
SQL Server forum so that SQL Server experts would explain it for you.
>> However I did not find a way that EF can create dbContext per schema.
Entity Framework would pull all schema to the select dialog. If you use the second approach, you need to choose the needed one by hand:

Regards,
Fred.
We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
Click
HERE to participate the survey.