i have 3 databases same schema (sap business 1 databases). in databases have item masters table connected warehouse stock table via item code. can have 1 entity framework model has 1 item master object , 1 warehouse stocks object draws data 3 databases? items same in 3 databases have different warehouse codes. don't know if have made myself clear.
if want single ef model simultaneously load data 3 databases answer no. if want single ef model can used 3 databases answer yes databases must use same database provider (server) , must have same schema of mapped tables.
the whole magic in case in connection string can connect single database , cross database calls not allowed.
if need first scenario can try hide unions , cross database queries in views , map views in model. have 2 disadvantages:
- relation between views not allowed in sql server can create relation in ef model
- views read in ef model. if want modify data best way mapping stored procedures that.
Comments
Post a Comment