How to Access Database via DLL without a Connection String in C# Console Application

Question

I'm having a Library Application in C#. It contains all EDMX files and Database accessing methods. I created one Console application, in that I refereed that Library DLL to access the methods. But the console application expects the Connection String in local App.Config file. I need a Security, how to access the DLL without specifying the Connection String in the Console Application ?

Is there is any other way is there to achieve the requirement. Kindly assist me.

It is common to use integrated security so you don't need to put a username and password in the connection string. Are you also trying to hide the server and database name? The only way to truly hide this from the user is to use a distributed service for data access, don't do it from the application directly. — Crowcoder
– Crowcoder, Commented Dec 2, 2016 at 13:12

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

1

You must provide the connection string in order to access the database. If you can't use integrated security then I suggest you to keep keep the connection string encrypted in the app.config file, in the <appSettings></appSettings> section and decrypt it in the console app before sending it to the business layer.

Consult this answer for how to encrypt/decrypt strings: Simple two way encryption for C#

edited May 23, 2017 at 11:45

CommunityBot

11 silver badge

answered Dec 2, 2016 at 13:20

Marjan Slavkovski

6331 gold badge7 silver badges20 bronze badges

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

5 Comments

Crowcoder Over a year ago

If your app can decrypt it, then a savvy user can too.

Marjan Slavkovski Over a year ago

If savvy user can't then NSA will certainly do. But let's get back to the problem here.

Crowcoder Over a year ago

If you store the key such that you can decrypt it then you have the same problem as connection string.

Marjan Slavkovski Over a year ago

That's why people invented public and private keys, there are thousands of encryption algorithms. If you can help the guy that posted the question then please feel free to do so. Otherwise any non-related comments are not necessary.

Crowcoder Over a year ago

I am trying to help. It is the private key that decrypts, you don't give that to someone you are trying to hide the data from.

Collectives™ on Stack Overflow

How to Access Database via DLL without a Connection String in C# Console Application

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