ODB-GET-1

   public static List<T> GetS(string where)
        {
            try
            {
                return Get(where);
            }
            catch
            {
                MakeSureExistTableAndColumns();
            }
            return Get(where);

        }

public static List<T> Get(string where)
        {       
            StringBuilder sql = new StringBuilder();
            sql.Append(SQL_SELECT);
            if (!String.IsNullOrEmpty(where.Trim()))
            {
                sql.Append(" Where ");
                sql.Append(where);
            }
            return Get(sql.ToString(), null);

        }

         public static List<T> GetS(params SqlParameter[] parms)
        {
            try
            {
                return Get(parms);
            }
            catch
            {
                MakeSureExistTableAndColumns();
            }
            return Get(parms);
        }

        public static List<T> Get(params SqlParameter[] parms)
        {            
            StringBuilder sql = new StringBuilder();
            sql.Append(SQL_SELECT);

            bool isFirst = true;
            foreach (SqlParameter parm in parms)
            {
                if (isFirst) { isFirst = false; sql.Append(" Where "); } else { sql.Append(" AND "); }
                sql.Append(parm.ParameterName.Substring(1) + "=" + parm.ParameterName);
            }
            return Get(sql.ToString(), parms);
        }