Get filepath to LocalDB file from connection string in .NET [duplicate]

Question

How to get the filepath to the .mdf file of a LocalDB database from its connection string in .NET?

Example string:

Data Source=(LocalDb)\v11.0;Initial Catalog=MyDb;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|\MyDb.mdf

angularsen · Accepted Answer · 2013-05-03 12:30:02Z

1

public static string GetFilePathFromConnectionString(string connectionString)
{
    var attachDbFileName = new SqlConnectionStringBuilder(connectionString).AttachDBFilename;
    return attachDbFileName.Replace("|DataDirectory|", AppDomain.CurrentDomain.GetData("DataDirectory").ToString());
}

answered May 3, 2013 at 12:30

angularsen

8,7483 gold badges73 silver badges88 bronze badges

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

Collectives™ on Stack Overflow

Get filepath to LocalDB file from connection string in .NET [duplicate]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related