What I always finding limiting with EntityFramework

Using EF5 (database first) at the moment against Oracle, but the concepts would be the same for SQLServer.

  1. Being able to define a model from multiple schemas. As long as my user has access, I should be able to create a model of the following:

    uac_user.MODEL sys_frank.MODEL_SUMMARY

  2. Being able to define my own foreign key relationships without an actual foreign key in the database that can cross schemas or even within the same schema:

    uac_user.MODEL.MODEL_ID <=> sys_frank.MODEL_SUMMARY.MODEL_ID

Venting in the event someone has tricks 🙂

by pug_walker via /r/csharp

Leave a Reply