Existing .edml wtih different database in same server

[sabbir]

hi,
Suppose i created a .edml file with database 'x' in server 'y'.it works.if i want to connect with another database like 'x1'(identical schema as database 'x') in the same server y, what can i do without recreating the model?i think changing the database name in connection string will not work.Please let me know.

[Shalex]

i think changing the database name in connection string will not work.

Open *.edml, navigate to Database Explorer, change the database name in connection properties, save the model to regenerate the code. It should be enough. If not, specify the exact problem you have encountered.