You are an enterprise application developer. You are manipulating a collection of customer, product, and supplier objects.
The collection objects must fulfill the following requirements:

The objects must use custom sort methods on different properties of the respective classes.
The objects must be strongly typed.

A developer from your team decides to use the following collection classes.

abstract class MyCollectionBase : System.Collections.CollectionBase { abstract public void Sort();
}
public class CustomerCollection : MyCollectionBase { //Code overriding CollectionBase methods
public override void Sort(){
//Customer sorting code
}
}
public class SupplierCollection : MyCollectionBase { //Code overriding CollectionBase methods
public override void Sort(){
//Supplier sorting code
}
}
public class ProductCollection : MyCollectionBase {
//Code overriding CollectionBase methods
public override void Sort(){
//Product sorting code
}
}

You need to review the code and recommend improvements to simplify maintenance, if necessary. What should you conclude and recommend?

You are an enterprise application developer. You create a data access layer for an order processing application.
The data access layer meets the following criteria:

The data access layer contains a GetConnectionString method to retrieve and return the connection string for the database.
The data access layer contains a stored procedure named GetTotalOrderAmount. The stored procedure runs a select query to return only the sum of the OrderAmount column for the active orders. At times, there might be no active orders.

You create the following method to execute the stored procedure and return the total.

public double GetTotalOrderAmount() {
SqlConnection con = new SqlConnection(GetConnectionString()); string sql = GetTotalOrderAmount;
SqlCommand cmd = new SqlCommand(sql,con);
IDataReader rd; con.Open(); rd = cmd.ExecuteReader(); double amt = 0.0;
if (rd.Read()) {
amt = rd.GetDouble(0);
}
rd.Close();
con.Close();
return amt;
}

You need to review the code and recommend modifications to simplify the code and improve performance, if necessary. What should you conclude and recommend?