public static BOStateProvince GetByName(string Name)
        {
            SqlConnection con = new SqlConnection(GetConnectionString());

            con.Open();

            try
            {
                SqlCommand cmd = new SqlCommand("P_StateProvince_GetByName", con);
                cmd.CommandType = CommandType.StoredProcedure;
                SetVarCharParameter(cmd.Parameters, "@Name", 100, Name, false);
                SqlDataReader rdr = cmd.ExecuteReader(CommandBehavior.SingleResult);

                try
                {
                    if (rdr.Read())
                    {
                        BOStateProvince businessObject = new BOStateProvince(rdr);
                        return businessObject;

                    }
                }
                finally
                {
                    rdr.Close();
                }
            }
            finally
            {
                con.Close();
            }
            return null;
        }
 public BOStateProvinceComparer(BOStateProvince.Columns column, BOStateProvince.SortDirections direction)
 {
     _column = column;
     _direction = direction;
 }
 protected override void BeforeSave(SQLTransaction trans)
 {
     if (StateProvince == null)
         StateProvince = new BOStateProvince(1);
     base.BeforeSave(trans);
 }