Dapper Question .net core 3.1 WPF ConnectionStrings

Question

I am banging my head on the wall trying to figure out how to set up my connection string for my WPF .net core 3.1 app, Everything I see says to use app.config then when I look up app.config I see use appsettings.json, neither file is natively built into the project.

I feel like I am missing a baked-in way to add and access my connection string, please advise.

.net core WPF app does not have a startup.cs @Red it isn't baked into the project. I am looking for a baked-in way to set up my connection string. — csharpnovice
– csharpnovice, Commented Sep 5, 2020 at 15:19
Does this answer your question? Cannot add appsettings.json inside WPF project .net core 3.0 — Roar S.
– Roar S., Commented Sep 5, 2020 at 16:20

Miha · Accepted Answer · 2020-09-10 09:20:22Z

0

Add app.config file and then get connectionstring with:

string GetAppSettingVal(string key)
        {
            Configuration config = null;
            string exeConfigPath = GetType().Assembly.Location;
            try
            {
                config = ConfigurationManager.OpenExeConfiguration(exeConfigPath);
            }
            catch (Exception ex)
            {
                return "";
            }

            var connectionString = config.AppSettings.CurrentConfiguration.ConnectionStrings.ConnectionStrings[key].ConnectionString; 

            if (!string.IsNullOrEmpty(connectionString))            
                return connectionString;
            
            return string.Empty;
        }

answered Sep 10, 2020 at 9:20

Miha

11 bronze badge

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

Collectives™ on Stack Overflow

Dapper Question .net core 3.1 WPF ConnectionStrings

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related