Connect to two databases using .Net 4 Entity Framework

I have  a c# .Net web application using Visual Studio 2010 which uses the entity framework to connect to a SQL Server 2008 database.  

I now need to connect to a new and seperate ODBC data source to retrieve data for reads-only.  No modifications are required to data in this data source..

Can I access another data source using the Entity Framework?
canuckconsultingAsked:
Who is Participating?
 
Éric MoreauSenior .Net ConsultantCommented:
create 2 edmx
0
 
Éric MoreauSenior .Net ConsultantCommented:
are your databases linked?
0
 
canuckconsultingAuthor Commented:
No, completely separate.
0
 
canuckconsultingAuthor Commented:
I wasn't sure I could do this...I'll give it a go when I get back to this project tonight.  Thanks.
0
 
canuckconsultingAuthor Commented:
This looks to be the correct answer but unfortunately my datasource needs to be odbc for this which EF appears not to support.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.