Example #1
0
        protected virtual IDbCommand CreateGetCommand(string whereSql, string orderBySql)
        {
            string sql = "SELECT * FROM [dbo].[sysdiagrams]";

            if (null != whereSql && 0 < whereSql.Length)
            {
                sql += " WHERE " + whereSql;
            }
            if (null != orderBySql && 0 < orderBySql.Length)
            {
                sql += " ORDER BY " + orderBySql;
            }
            return(_db.CreateCommand(sql));
        }