General Application Design

[Frederic Laruelle]

Looking for the most efficient way to design a DB app from a memory usage and perfomance standpoint:

Assuming a pseudo structure like this:

class MyClass
{
public static void Main()
{
DoSomething();
DoAnotherThing();
}
public static void DoSomething()
{
...
}
public static void DoAnotherThing()
{
...
}
}

What would be the most efficient way to design this code if both DoSomething() and DoAnotherThing() need to execute independent SQL statements?

a) Would you open a DB connection in Main(), and then pass it as a parameter to the 2 methods? (versus opening a new connection in each method)
b) what about a SQL transaction, should this also be passed as a parameter?

Any comments appreciated.