how to hide connectionString of a database connection in c#

Question

I am using sqlite in my app. I am declaring my sqliteConnection as constant. But the problem is that the user of this class can change the connectionString property of this sqliteConnection object. How I can prevent that? I want the connection string of the connection to be set just once.

if its declared with const keyword, it will be readonly by default. — Parimal Raj
– Parimal Raj, Commented Mar 17, 2013 at 7:02
By "user" you mean another developer with access to the code, or something else? If its a const it can't be changed in the code anymore. — Haedrian
– Haedrian, Commented Mar 17, 2013 at 7:03
@VictorMukherjee - why not create a read-only property ? only with getter and no setter. — Parimal Raj
– Parimal Raj, Commented Mar 17, 2013 at 7:09

p.s.w.g · Accepted Answer · 2013-03-17 07:25:13Z

1

You can create a read-only property...

private string connectionString = "my_string";
public string ConnectionString
{
    get { return connectionString; }
}

Or a readonly field. The value can be set only in the constructor or as a constant:

public readonly ConnectionString = "my_string";

Or a const field. The value can be set as a constant (value is static, i.e. there will only be one value for all instances):

public const ConnectionString = "my_string";

edited Mar 17, 2013 at 7:25

p.s.w.g

150k31 gold badges307 silver badges339 bronze badges

answered Mar 17, 2013 at 7:00

Parimal Raj

20.6k9 gold badges76 silver badges113 bronze badges

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

1 Comment

p.s.w.g Over a year ago

Pretty sure you can't do readonly and const on one field.

Collectives™ on Stack Overflow

how to hide connectionString of a database connection in c#

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related