protected void PrepareConnection()
 {
     if (_connection == null)
     {
         _connection = new SqlConnection(ConnectionStringProvider.GetConncetionString());
     }
     if (_connection.State != ConnectionState.Open)
     {
         _connection.Open();
     }
 }