C#

private object foo = null;

public object Foo
{
  get { if (foo == null) foo = new object(); return foo; }
}

public interface IFoo
{
  void Test();
}
class Foo1 : IFoo
{
  void Test() { Console.WriteLine("from Foo1"); }
}
class Foo2 : IFoo
{
  void Test() { Console.WriteLine("from Foo2"); }
}
public class FooFactory
{
  public static IFoo CreateFoo(string cls)
  {
    if (cls == "foo1") return new Foo1();
    else if (cls == "foo2") return new Foo2();
    else return null;
  }
}

<configuration>
  <runtime>
    <assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">
      <probing privatePath="plugins"/>
    </assemblyBinding>
  </runtime>
</configuration>

SELECT name from sysdatabases

SELECT user_name(uid) AS username, sysobjects.name AS tablename
FROM sysobjects
WHERE xtype='U' OR xtype='S'

theServer.theUser.theTable

"If a man empties his purse into his head, no man can take it away from him, for an investment in knowledge pays the best interest." -- Joseph E. O'Donnell

Not getting the response you want from a question asked in an online forum: How to Ask Questions the Smart Way!

SELECT * 
FROM INFORMATION_SCHEMA.SCHEMATA