Visual Basic

class DAL
{
    /*You have to Decalre two Connection Strings Outside
    your Functions to be able to use them */
    String constrCustomers = @"User ID = sa; Password=wow;Server=MYSERVER;Database=Customer";
    String constrEmployees = @"User ID = sa; Password=wow;Server=MYSERVER;Database=Employer";
    SqlConnection con;
    SqlCommand cmdCustomer;
    SqlCommand cmdEmployees;
    SqlDataAdapter da;

    public DataTable Get_Customers()
    {
        con = new SqlConnection(constrCustomers);
        cmdCustomer = new SqlCommand();
        cmdCustomer.CommandTimeout = 0;
        cmdCustomer.CommandType = CommandType.Text;
        cmdCustomer.Connection = con;
        cmdCustomer.CommandText = "Select Top 1 * from Customer_Table";
        da = new SqlDataAdapter();
        da.SelectCommand = cmdCustomer;
        DataTable dt = new DataTable();
        try
        {
           con.open();

            da.Fill(dt);

        }
        catch (SqlException)
        {
            throw;
        }
        finally
        {
         con.close();
        }
        return dt;
    }

    public DataTable Get_Employees()
    {

        con = new SqlConnection(constrEmployees);
        cmdEmployees = new SqlCommand();
        cmdEmployees.CommandTimeout = 0;
        cmdEmployees.CommandType = CommandType.Text;
        cmdEmployees.Connection = con;
        cmdEmployees.CommandText = "Select Top 1 * from Employees";
        da = new SqlDataAdapter();
        da.SelectCommand = cmdEmployees;
        DataTable dt = new DataTable();
        try
        {
            con.Open();

            da.Fill(dt);

        }
        catch (SqlException)
        {
            throw;
        }
        finally
        {
         con.close();
        }
        return dt;
    }

The JZ wrote:

There were no requirements given in the original post

The JZ wrote:

There were no requirements pertaining to multi-users or multi-threading, as you posted.

The JZ wrote:

The question was to intercept file operations.

The JZ wrote:

If you did not like my idea, I do not care