[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Connect to two databases using .Net 4  Entity Framework

Posted on 2012-08-13
5
Medium Priority
?
361 Views
Last Modified: 2012-08-14
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?
0
Comment
Question by:canuckconsulting
  • 3
  • 2
5 Comments
 
LVL 70

Expert Comment

by:Éric Moreau
ID: 38290021
are your databases linked?
0
 

Author Comment

by:canuckconsulting
ID: 38290716
No, completely separate.
0
 
LVL 70

Accepted Solution

by:
Éric Moreau earned 2000 total points
ID: 38291307
create 2 edmx
0
 

Author Comment

by:canuckconsulting
ID: 38292151
I wasn't sure I could do this...I'll give it a go when I get back to this project tonight.  Thanks.
0
 

Author Closing Comment

by:canuckconsulting
ID: 38293887
This looks to be the correct answer but unfortunately my datasource needs to be odbc for this which EF appears not to support.
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

It was really hard time for me to get the understanding of Delegates in C#. I went through many websites and articles but I found them very clumsy. After going through those sites, I noted down the points in a easy way so here I am sharing that unde…
Hello there! As a developer I have modified and refactored the unit tests which was written by fellow developers in the past. On the course, I have gone through various misconceptions and technical challenges when it comes to implementation. I would…
this video summaries big data hadoop online training demo (http://onlineitguru.com/big-data-hadoop-online-training-placement.html) , and covers basics in big data hadoop .
In a question here at Experts Exchange (https://www.experts-exchange.com/questions/29062564/Adobe-acrobat-reader-DC.html), a member asked how to create a signature in Adobe Acrobat Reader DC (the free Reader product, not the paid, full Acrobat produ…
Suggested Courses
Course of the Month18 days, 10 hours left to enroll

834 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question