connect to more than one database which are in different database servers

Question

I am working on a project which is functioning on .netframework 4.6, VS 2015, EntityFramework 6.x

I am trying to connect to more than one database which are in different database servers.

My dabatase looks like :

I have a main project and repository project which is a class library.

my proj structure :

In my repository project I added two EntityFramework models namely CompanyEmployeeModel.edmx and MultipleTestModel.edmx.

In My EmployeeDAL.CS :

private static async Task<string> GetCompanyInformationByIdCompany(int idCompany)
        {
            string result = string.Empty;

            try
            {
                using (var db = new Entities())
                {
                    var companyInformation = await db.CompanyInformations.Where(x => x.id == idCompany).FirstOrDefaultAsync();
                    result = companyInformation.name;
                }

 using (var dbTest = new fccidevEntities())
                    {
                        var EmployeeInformation = await dbTest.Employees.Where(x => x.Id == 10).FirstOrDefaultAsync();
                        //result = EmployeeInformation..name;
                    }
            }
            catch
            {
                result = string.Empty;
            }

            return result;
        }

Is this the right way of doing. Can somebody suggest how to connect to multiple databases residing in multiple servers.

Exception :

just use mutlipe connection strings: stackoverflow.com/questions/24769451/… — Bassam Alugili
– Bassam Alugili, Commented May 20, 2016 at 21:29
I agree with bateloche comment below. However, if you dont have time to refactor your model, you can always pass in the connection string to the dbcontext. — dfdsfdsfsdf
– dfdsfdsfsdf, Commented May 20, 2016 at 21:33

bateloche · Accepted Answer · 2016-05-20 21:25:15Z

2

With EF you'll need two contexts, there's no way of getting rid of this, what I would do in your case is to have something encapsulating the contexts.

This way you'll have not to worry what database are you acessing at this moment.

Just be aware that for most requests you'll open two differente connections and that comes at a cost, you'll have more network IO and memory load than a single database application.

answered May 20, 2016 at 21:25

bateloche

7094 silver badges20 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

BumbleBee Over a year ago

an example please. by the way I am getting the following error. Invalid object dbo.Employees. Employees is a table in fccidev.

bateloche Over a year ago

is the schema dbo? post your exception details so we know what's happening.

BumbleBee Over a year ago

added a screenshot of the exception.

bateloche Over a year ago

check the sql query being executed.

bateloche Over a year ago

it may be wrong connection string, check also if EF's running the query on the right database.

Collectives™ on Stack Overflow

connect to more than one database which are in different database servers

1 Answer 1

5 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related