Make .dbml file in a class library use connectionstring from config file without subclassing it

Question

I have a class library that is referenced from a web application. The class library defaults to using TestProject.Properties.Settings.Default.NFU_Custom_Website_DataConnectionString1. I would like it to get the connectionstring from ConfigurationManager.ConnectionStrings.

I can't change the .designer.cs file because it will get overwritten. If possible I would like to avoid creating a class which inherits from the .dbml file and setting the connection string in there. My boss recommends creating a web application project and deleting all of the default.aspx etc files from it and using that instead of a class library, is this a viable solution?

Thanks

Joe

Community · Accepted Answer · 2017-05-23 11:45:16Z

3

You can do that. We had done that inadvertently and I got this problem when I switched to a class library. Rather than switch back I found the answer here: Point connectionstring in dbml to app.config

In summary:

Set the connection property of the DBML to (none) in the designer. This will remove the default constructor from the DB Context class.
Create a partial class for your DB Context with a default constructor:


    using System.Configuration;

    namespace TestProject
    {
        public partial class MyDBContext
        {
            public MyDBContext() : base(ConfigurationManager.ConnectionStrings["MyConnectionString"].ConnectionString)
            {
                OnCreated();
            }
        }
    }

edited May 23, 2017 at 11:45

CommunityBot

11 silver badge

answered Jul 16, 2013 at 0:59

Andrew McLachlan

3491 silver badge15 bronze badges

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

1 Comment

JoeS Over a year ago

Thanks for the solution, I ended up creating a class pretty much exactly like the one above but setting it as the base class in the designer instead.

Collectives™ on Stack Overflow

Make .dbml file in a class library use connectionstring from config file without subclassing it

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related