To get all the DB's programatically on a local instance of SQL Server using SMO.
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using Microsoft.SqlServer.Management.Smo;
using Microsoft.SqlServer.Management.Common;
namespace ConsoleApplication1
{
class Program
{
static void Main(string[] args)
{
Server s = new Server(".\\INSTANCENAME");
foreach (Database d in s.Databases)
{
Console.WriteLine(d.Name.ToString());
}
Console.ReadKey();
}
}
}
Points of Interest
Don't forget to add the references via Project >> Add Reference... >> Browse tab