Uses SELECT to return only needed columns, reducing data transfer and memory usage.
This is often the secret weapon for developers dealing with performance bottlenecks. Instead of using a simple .ToList() which pulls **every column** from the database (including huge text blocks or unused fields), we use **projection** via a .Select() statement.
By projecting only to the `ProductSummaryDto`, we ask the database for *exactly* what we need: the product name, price, and category. This drastically reduces the size of the data packet traveling over the network and saves memory on the server.
Fast execution due to minimal data transfer.
Full results, but only essential columns were retrieved.
| Product Name | Category | Price | Rating |
|---|---|---|---|
| Premium Home & Garden Product Special Edition | Home & Garden | $63.63 | 5.00 |
| Mega Toys & Games Product Advanced | Toys & Games | $920.27 | 5.00 |
| Mega Electronics Product Special Edition | Electronics | $511.59 | 5.00 |
| Super Electronics Product Mini | Electronics | $371.47 | 5.00 |
| Pro Home & Garden Product Plus | Home & Garden | $749.81 | 5.00 |
| Ultra Toys & Games Product Advanced | Toys & Games | $446.85 | 5.00 |
| Premium Clothing Product Pro | Clothing | $986.81 | 5.00 |
| Professional Electronics Product Lite | Electronics | $487.59 | 5.00 |
| Super Books Product Plus | Books | $532.47 | 5.00 |
| Professional Home & Garden Product Lite | Home & Garden | $272.89 | 5.00 |
| Premium Office Supplies Product Classic | Office Supplies | $436.97 | 5.00 |
| Elite Toys & Games Product Plus | Toys & Games | $749.64 | 5.00 |
| Pro Home & Garden Product XL | Home & Garden | $865.44 | 5.00 |
| Premium Automotive Product Advanced | Automotive | $459.69 | 5.00 |
| Super Toys & Games Product Pro | Toys & Games | $194.85 | 5.00 |
| Pro Electronics Product Mini | Electronics | $99.50 | 5.00 |
| Super Electronics Product Advanced | Electronics | $766.30 | 5.00 |
| Pro Books Product 2024 | Books | $398.69 | 5.00 |
| Standard Sports & Outdoors Product Classic | Sports & Outdoors | $326.97 | 5.00 |
| Super Food & Grocery Product Advanced | Food & Grocery | $812.18 | 5.00 |
| Economy Clothing Product Advanced | Clothing | $981.45 | 5.00 |
| Deluxe Health & Beauty Product Pro | Health & Beauty | $840.46 | 5.00 |
| Professional Office Supplies Product Max | Office Supplies | $73.01 | 5.00 |
| Economy Sports & Outdoors Product Plus | Sports & Outdoors | $350.03 | 5.00 |
| Premium Books Product Classic | Books | $671.77 | 5.00 |
| Elite Books Product Special Edition | Books | $843.21 | 5.00 |
| Economy Health & Beauty Product Advanced | Health & Beauty | $967.47 | 5.00 |
| Mega Sports & Outdoors Product Special Edition | Sports & Outdoors | $630.45 | 5.00 |
| Deluxe Home & Garden Product Advanced | Home & Garden | $801.64 | 5.00 |
| Deluxe Office Supplies Product Max | Office Supplies | $33.31 | 5.00 |
| Elite Sports & Outdoors Product 2024 | Sports & Outdoors | $779.23 | 5.00 |
| Economy Clothing Product Mini | Clothing | $710.09 | 5.00 |
| Pro Health & Beauty Product 2024 | Health & Beauty | $758.52 | 5.00 |
| Super Sports & Outdoors Product Plus | Sports & Outdoors | $332.07 | 5.00 |
| Economy Sports & Outdoors Product Lite | Sports & Outdoors | $486.87 | 5.00 |
| Economy Books Product Classic | Books | $289.75 | 5.00 |
| Mega Automotive Product Plus | Automotive | $309.44 | 5.00 |
| Premium Clothing Product Max | Clothing | $461.72 | 5.00 |
| Deluxe Home & Garden Product XL | Home & Garden | $112.98 | 5.00 |
| Mega Food & Grocery Product Special Edition | Food & Grocery | $866.32 | 5.00 |
| Mega Toys & Games Product Pro | Toys & Games | $656.00 | 5.00 |
| Elite Office Supplies Product XL | Office Supplies | $759.27 | 5.00 |
| Super Books Product Lite | Books | $285.13 | 5.00 |
| Ultra Home & Garden Product Advanced | Home & Garden | $173.09 | 5.00 |
| Pro Home & Garden Product XL | Home & Garden | $278.87 | 5.00 |
| Deluxe Sports & Outdoors Product Lite | Sports & Outdoors | $673.67 | 5.00 |
| Economy Health & Beauty Product Special Edition | Health & Beauty | $33.55 | 5.00 |
| Economy Automotive Product Max | Automotive | $616.40 | 5.00 |
| Standard Automotive Product Pro | Automotive | $62.44 | 5.00 |
| Standard Home & Garden Product Plus | Home & Garden | $726.21 | 5.00 |
| Standard Clothing Product Advanced | Clothing | $858.71 | 5.00 |
| Standard Toys & Games Product Advanced | Toys & Games | $658.87 | 5.00 |
| Ultra Automotive Product Advanced | Automotive | $561.09 | 5.00 |
| Deluxe Office Supplies Product XL | Office Supplies | $679.31 | 5.00 |
| Elite Food & Grocery Product Lite | Food & Grocery | $131.28 | 5.00 |
| Bulk Product 07511384 | Clothing | $127.25 | 5.00 |
| Bulk Product 164cd9b4 | Sports & Outdoors | $392.96 | 5.00 |
| Bulk Product 4e2d072d | Electronics | $303.43 | 5.00 |
| Bulk Product c85bce04 | Toys & Games | $692.30 | 5.00 |
| Bulk Product b9e758e5 | Clothing | $501.42 | 5.00 |
| Bulk Product 6c1ac4ee | Books | $640.70 | 5.00 |
| Bulk Product 1cd59ab5 | Books | $183.33 | 5.00 |
| Bulk Product 21a983f6 | Toys & Games | $52.29 | 5.00 |
| Bulk Product 9d756eab | Sports & Outdoors | $49.84 | 5.00 |
| Bulk Product 66ea4784 | Books | $536.77 | 5.00 |
| Bulk Product e6dd8ba3 | Sports & Outdoors | $240.94 | 5.00 |
| Bulk Product b2a5f01e | Sports & Outdoors | $576.54 | 5.00 |
| Bulk Product f054ce6a | Clothing | $630.13 | 5.00 |
| Bulk Product e5aafaff | Home & Garden | $130.51 | 5.00 |
| Bulk Product 52b4307e | Books | $678.67 | 5.00 |
| Bulk Product 185599f5 | Sports & Outdoors | $502.82 | 5.00 |
| Bulk Product d780c12a | Toys & Games | $402.42 | 5.00 |
| Bulk Product 1aa7e025 | Home & Garden | $663.78 | 5.00 |
| Bulk Product 01539a67 | Toys & Games | $486.38 | 5.00 |
| Bulk Product 2328fd33 | Home & Garden | $822.86 | 5.00 |
| Bulk Product 5890aab2 | Books | $118.39 | 5.00 |
| Bulk Product f15b9864 | Toys & Games | $98.30 | 5.00 |
| Bulk Product 2262aaa0 | Electronics | $299.50 | 5.00 |
| Bulk Product 855e2c5a | Sports & Outdoors | $750.17 | 5.00 |
| Bulk Product 9f44b6fb | Sports & Outdoors | $173.26 | 5.00 |
| Bulk Product d49f8d39 | Electronics | $470.94 | 5.00 |
| Bulk Product c5e85de0 | Clothing | $97.15 | 5.00 |
| Bulk Product f1013ba3 | Home & Garden | $990.96 | 5.00 |
| Bulk Product cbe2c0fa | Home & Garden | $980.18 | 5.00 |
| Bulk Product 4354bedb | Toys & Games | $561.00 | 5.00 |
| Bulk Product f2fe0680 | Electronics | $930.97 | 5.00 |
| Bulk Product 1a4eba57 | Clothing | $120.79 | 5.00 |
| Bulk Product d8b6481f | Electronics | $143.76 | 5.00 |
| Bulk Product 7ee6cb1e | Home & Garden | $129.68 | 5.00 |
| Bulk Product d4204f83 | Books | $743.38 | 5.00 |
| Bulk Product 13734214 | Sports & Outdoors | $736.23 | 5.00 |
| Bulk Product 2a60ba83 | Clothing | $610.25 | 5.00 |
| Bulk Product ed6dc6d0 | Home & Garden | $539.14 | 5.00 |
| Bulk Product f81f648a | Books | $840.69 | 5.00 |
| Bulk Product e8dd3459 | Sports & Outdoors | $34.74 | 5.00 |
| Bulk Product f265ec67 | Electronics | $349.94 | 5.00 |
| Bulk Product 2ac4fc85 | Sports & Outdoors | $938.94 | 5.00 |
| Bulk Product 59123493 | Toys & Games | $304.93 | 5.00 |
| Bulk Product 66c09764 | Electronics | $174.67 | 5.00 |
| Bulk Product ebdf083b | Toys & Games | $453.35 | 5.00 |