asp.net connection string problem in web.config

Question

I have a little problem with my recent project. I have a connection string in my web.config but i'd like to access it in my sql specific class.

My connection string is looks like this:

"Data Source=(LocalDb)\MSSQLLocalDB;AttachDbFilename=|DataDirectory|\aspnet-Joblication-20180902120147.mdf;Integrated Security=True"

It's stored in my web.config file.

My problem is that the default asp.net functions can access this database but i'd like to store other data in the database so i tried to access it with SqlConnection class. I set the ConnectionString property of the SqlConnection object:

SqlConncetion connection = new SqlConnection()
connection.ConnectionString = "Data Source=(LocalDb)\\MSSQLLocalDB;AttachDbFilename=|DataDirectory|\\aspnet-Joblication-20180902120147.mdf;Integrated Security=True";

But i get this error everytime:

System.Data.SqlClient.SqlException: 'An attempt to attach an auto- named database for file *.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.'

I replaced the name of the mdf file with a '*' so it is shorter and easily readable.

If i understand this then my .mdf file is already attached to the MSSQLLocalDB so i should connect to the MSSQLLocalDB and i should be able to access the .mdf file somehow, right?

When i'm trying this:

connection = new SqlConnection();
connection.ConnectionString = "Data Source=(LocalDb)\\MSSQLLocalDB;Integrated Security=True";

Then it seems ok cause the connection is working now but my queries don't. My queries are trying to get data from the .mdf file's tables but the .mdf file is not specified in this connection.

So how can i specify it?

Oh...I found the way to specify my database. I added Initial Catalog to the ConnectionString property but now it fails to log me in. Do u have any idea how could i login? I think it's windows authentication based by default but i'm not sure... I would greatly appreciate any help. — Dániel Foltán
– Dániel Foltán, Commented Sep 17, 2018 at 9:40
System.Data.SqlClient.SqlException: 'Cannot open database "aspnet-Joblication-20180902120147.mdf" requested by the login. The login failed. Login failed for user 'DESKTOP-BIDR6TV\gomis96'.' — Dániel Foltán
– Dániel Foltán, Commented Sep 17, 2018 at 9:46

TanvirArjel · Accepted Answer · 2018-09-17 10:16:18Z

0

First in your web.config update the connection string as exactly as follows:

<add name="DefaultConnection"
    providerName="System.Data.SqlClient"
    connectionString="Data Source=(LocalDb)\\MSSQLLocalDB;AttachDbFileName=|DataDirectory|\aspnet-Joblication-20180902120147.mdf;Integrated Security=True;User Instance=True;MultipleActiveResultSets=True" />

Then in the code:

// Don't hard coded the connection string here. Get it from web.config as follows
string connectionString = WebConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString;
using (var connection = new SqlConnection(connectionString))
{
   connection.Open();
   // Do your necessary staffs here.
}

answered Sep 17, 2018 at 10:16

TanvirArjel

32.4k14 gold badges89 silver badges120 bronze badges

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

Comments

SUNIL DHAPPADHULE · Accepted Answer · 2018-10-10 17:14:35Z

0

Add in your Web.config

<add name="Connectionstring"
providerName="System.Data.SqlClient"
connectionString="Data Source=(localdb)\ProjectsV13;Initial Catalog=TestDb;Integrated Security=True;Connect Timeout=30;Encrypt=False;TrustServerCertificate=False;ApplicationIntent=ReadWrite;MultiSubnetFailover=False" />

 class Program
{
    private readonly string _connectionString;
    public Program()
    {
        _connectionString = ConfigurationManager.ConnectionStrings["Connectionstring"].ConnectionString;
    }
    static void Main(string[] args)
    {

        using (var connection = new SqlConnection(_connectionString))
        {
            connection.Open();
            // Do your logic here.
        }
    }
}

edited Oct 10, 2018 at 17:14

answered Oct 10, 2018 at 16:53

SUNIL DHAPPADHULE

2,89919 silver badges34 bronze badges

Comments

Uzzal Prasad · Accepted Answer · 2018-09-17 10:07:47Z

-1

In your code portion add database name.I already implemented this way.

"Data Source=(LocalDb);Initial Catalog=databasename;Integrated Security=True;"

edited Sep 17, 2018 at 10:07

answered Sep 17, 2018 at 9:55

Uzzal Prasad

1151 silver badge11 bronze badges

3 Comments

CodeCaster Over a year ago

"Try this" isn't an answer. Explain what you changed and how that will solve the issue.

Dániel Foltán Over a year ago

It requires a localdb instance name and my only localdb instance is MSSQLLocalDB.

Uzzal Prasad Over a year ago

In your last code portion

connection = new SqlConnection();         connection.ConnectionString = "Data Source=(LocalDb)\\MSSQLLocalDB;Integrated Security=True";

you won't specify your database name. mention your database name into Initial Catalog = aspnet-Joblication-20180902120147.mdf. i think it will work. I already implement with this.

Collectives™ on Stack Overflow

asp.net connection string problem in web.config

3 Answers 3

Comments

Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related