finding datafiles path including datafile name using SMO

Question

Hi

i have did like

   foreach(LogFile lf in db.Databases)
      Console.WriteLine(lf.FileName)

which displays the logfile path including extension.....My Problem is how to find the

Datafiles exact path including extension..Give me the Guidance

Any Help is Greatly Appreciated...

Thanks in Advance.

Answer 1

    foreach (FileGroup fg in database.FileGroups)
    {
        foreach (DataFile df in fg.Files)
        {
            Console.WriteLine(Path.Combine(database.PrimaryFilePath, df.Name);
        }
    }