Field initializer error with DBContext constructor when connection string has been passed to the repository constructor

Question

I am building a multi-tenanted application. The code is shared but each client has a different database. I have code that determines the specific client's database connection string (based on an API key they are using).

I want to initialise the context using this connection string.

I approached this by passing the string to the repository constructor in the hope I could then reuse it for the context constructor but I am getting the error:

A field initializer cannot reference the non-static field, method, or property...

when I attempt to initialize an Entity Framework database context using a connection string that I have previously passed into the Repository constructor.

I have researched and understand the error (you can't initialize one instance member using an other instance member, as it may not be available at that time) but I am unsure how to work my way around it.

What I am trying to achieve is self-evident from the code:

public class GlobalCompanyRepository : IGlobalCompanyRepository
{
    private readonly string _dbConnectionString;

    public GlobalCompanyRepository(string dbConnectionString)
    {
        _dbConnectionString = dbConnectionString;
    }

    public IntrinsicDbContext dbContext = new IntrinsicDbContext(_dbConnectionString);
    public void Add(GlobalCompany entity)
    {
        dbContext.GlobalCompanies.Add(entity);
        dbContext.SaveChanges();
    }
}

Eric J. · Accepted Answer · 2016-03-12 15:42:26Z

2

You are trying to initialize your field dbContext

public IntrinsicDbContext dbContext = new   IntrinsicDbContext(_dbConnectionString);

Before _dbConnectionString has been given a value.

You can move the initialization into the constructor.

answered Mar 12, 2016 at 15:42

Eric J.

151k65 gold badges353 silver badges563 bronze badges

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

Comments

Steve Wong · Accepted Answer · 2016-03-12 15:44:19Z

0

You can initialize the dbContext in the constructor when _dbConnectingString has a value:

public class GlobalCompanyRepository : IGlobalCompanyRepository
{
    private readonly string _dbConnectionString;

    public GlobalCompanyRepository(string dbConnectionString)
    {
        _dbConnectionString = dbConnectionString;
        dbContext = new IntrinsicDbContext(_dbConnectionString);
    }

    public IntrinsicDbContext dbContext;
    public void Add(GlobalCompany entity)
    {
        dbContext.GlobalCompanies.Add(entity);
        dbContext.SaveChanges();
    }
}

answered Mar 12, 2016 at 15:44

Steve Wong

2,27617 silver badges24 bronze badges

1 Comment

ChrisCurrie Over a year ago

Perfect! Exactly what I needed.

Collectives™ on Stack Overflow

Field initializer error with DBContext constructor when connection string has been passed to the repository constructor

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related