The Weird and The Wonderful

fileName = ""

If Len(fileName) = 0 Then
    fileName = Left(DBEngine.Workspaces(0).Databases(0).Name, i) & "REF"
End If

public class IDataAccesslayer
{
    private static SqlConnection conn = new SqlConnection(WebConfigurationManager.ConnectionStrings["connStr"].ToString());

    public IDataAccesslayer()
    {
        //
        // TODO: Add constructor logic here
        //
    }

    public static void ExecuteNoReturn(String spName, List<SqlParameter> parms)
    {
        try
        {
            conn.Open();

            SqlCommand cmd = new SqlCommand(spName, conn);
            cmd.CommandType = CommandType.StoredProcedure;

            foreach (SqlParameter parm in parms)
            {
                cmd.Parameters.Add(parm);
            }

            cmd.ExecuteNonQuery();
        }
        catch (Exception ex)
        {
            throw (ex);
        }
        finally
        {
            if (conn.State == ConnectionState.Open)
                conn.Close();
        }
    }
    public static DataSet ExecuteReturnDataSet(String spName, List<SqlParameter> parms)
    {
        //this was same as previous, except using a data-adapter
    }
}