public static List <OptionPickingItemsEx> Get(string constructionCode) { string sql = @" SELECT * FROM OptionPickingItemsEx WHERE ConstructionCode = '" + constructionCode + "'"; var db = OptionPickingItemsEx.GetDatabase(); return(db.ExecuteQuery <OptionPickingItemsEx>(sql)); }