I have an application where I am using Code first migrations and EF and I have my connection string in file App.config and all that goes with Code first migrations workflow and all is working fine. The issue I am having now and I am not able to find a solution anywhere online. So, what I need to know and hopefully is possible is to call a Stored Procedure from a different existing database because my existing program already have a connection string that connect to my main database but now I need to be able to somehow to connect to the other database and to call that stored procedure from that other database.
So, far I was able to find how to call a stored procedure but only found example where they call a stored procedure from the same database not other database.
So, please let me know how can I call a stored procedure from a different database still using code first workflow migration so I can add it to my dbsets. so, if is possible I would like if you can send me an code example how to do it would be great.