Take the 2-minute tour ×  I have two tables that have the same
layout -  Report Table  In another database I have   Reporting
Table  I want to use a single entity model called Report to load
the data from both of these tables.  In my context class I have
public DbSet<Report> Report{ get; set; }          protected
override void OnModelCreating(DbModelBuilder modelBuilder)
modelBuilder.Configurations.Add(new ReportMap());  In my call to
the first database Report table I get the results as expected.
I change the connection string to point to the second database,
but I can't change the name of the table in the table mapping.
I don't want to use stored procs for the reason outlined in my
comment.  What can I do, short of the tables names in the
database(that is not an option).  share|improve this question
You could write two SP, one in each DB with the same name and
then call that to get your results –  glosrob Feb 6 '13 at 21:11
I'm hoping to do this entirely from code, there are in fact ab