How to get the current path to the database file?

Question

I am developing a web application. I need to get the path to the database file. How can I get the path to a database file in C #? eg:

E:/Program Files/Microsoft SQL Server/MSSQL.1/MSSQL/Data/MyDatabase.mdf 

Answer 1

 select physical_name from sys.database_files where type = 0 

The above SQL query to execute. Below is the C # code that will retrieve and store this data in string :

 SqlConnection DbConn = new SqlConnection(ConfigurationManager.ConnectionStrings["CStringName"].ConnectionString); SqlCommand GetDataFile = new SqlCommand(); GetDataFile.Connection = DbConn; GetDataFile.CommandText = "select physical_name from sys.database_files where type = 0"; try { DbConn.Open(); string YourDataFile = (string) GetDataFile.ExecuteScalar(); DbConn.Close(); } catch (Exception ex) { DbConn.Dispose(); } 

Answer 2

Server.mappath will return the path