/// <summary> /// Load Customer by primary key /// </summary> /// <param name="CustomerIdentifier"></param> /// <param name="pBad">true for incorrect SQL, false for correct SQL</param> /// <returns>DataTable with one record on success or empty rows for failure</returns> public DataTable LoadCustomers(int CustomerIdentifier, bool pBad = true) { mHasException = false; var dt = new DataTable(); using (var cn = new SqlConnection { ConnectionString = ConnectionString }) { using (var cmd = new SqlCommand { Connection = cn }) { cmd.CommandText = pBad ? SelectStatementBad : SelectStatementGood; cmd.Parameters.AddWithValue("@CustomerIdentifier", CustomerIdentifier); try { cn.Open(); dt.Load(cmd.ExecuteReader()); dt.HideIdentifierFields(); } catch (Exception ex) { ActualCommandText = cmd.ActualCommandText(); mHasException = true; mLastException = ex; } } } return(dt); }