Demonstrates INNER JOIN operations with related data.
In relational databases, joins are critical for combining data from multiple tables. In Entity Framework Core, this is typically handled automatically when you include **navigation properties** (Eager Loading), or explicitly using the LINQ `join` keyword.
The key performance benefit here is that all the necessary product and category data is fetched from the database in a **single trip**, avoiding the N+1 problem (where N queries are run for N products to get their category).
Query Execution Time:
62 ms| ID | Product Name | Category | Price | Stock | Status |
|---|---|---|---|---|---|
| 1021 | Deluxe Automotive Product 2024 | Automotive | $687.74 | 386 | In Stock |
| 1367 | Deluxe Automotive Product 2024 | Automotive | $433.75 | 467 | In Stock |
| 2123 | Deluxe Automotive Product 2024 | Automotive | $483.83 | 250 | In Stock |
| 493 | Deluxe Automotive Product Advanced | Automotive | $866.01 | 8 | Low Stock |
| 2682 | Deluxe Automotive Product Advanced | Automotive | $220.89 | 107 | In Stock |
| 3147 | Deluxe Automotive Product Advanced | Automotive | $56.13 | 288 | In Stock |
| 3345 | Deluxe Automotive Product Advanced | Automotive | $216.35 | 489 | In Stock |
| 3757 | Deluxe Automotive Product Classic | Automotive | $980.32 | 219 | In Stock |
| 201 | Deluxe Automotive Product Classic | Automotive | $194.53 | 115 | In Stock |
| 1236 | Deluxe Automotive Product Classic | Automotive | $890.63 | 497 | In Stock |
| 2356 | Deluxe Automotive Product Classic | Automotive | $308.63 | 370 | In Stock |
| 1636 | Deluxe Automotive Product Classic | Automotive | $602.73 | 366 | In Stock |
| 1738 | Deluxe Automotive Product Classic | Automotive | $575.10 | 73 | In Stock |
| 1768 | Deluxe Automotive Product Lite | Automotive | $929.36 | 479 | In Stock |
| 4903 | Deluxe Automotive Product Lite | Automotive | $161.26 | 378 | In Stock |
| 4464 | Deluxe Automotive Product Max | Automotive | $154.52 | 373 | In Stock |
| 2675 | Deluxe Automotive Product Max | Automotive | $535.65 | 206 | In Stock |
| 1287 | Deluxe Automotive Product Max | Automotive | $877.19 | 382 | In Stock |
| 2544 | Deluxe Automotive Product Max | Automotive | $789.90 | 324 | In Stock |
| 1174 | Deluxe Automotive Product Max | Automotive | $494.05 | 444 | In Stock |
| 242 | Deluxe Automotive Product Max | Automotive | $719.14 | 253 | In Stock |
| 2216 | Deluxe Automotive Product Mini | Automotive | $999.12 | 62 | In Stock |
| 1771 | Deluxe Automotive Product Mini | Automotive | $116.68 | 21 | Low Stock |
| 3728 | Deluxe Automotive Product Mini | Automotive | $867.12 | 356 | In Stock |
| 3522 | Deluxe Automotive Product Mini | Automotive | $588.25 | 457 | In Stock |
| 4488 | Deluxe Automotive Product Mini | Automotive | $191.47 | 489 | In Stock |
| 3773 | Deluxe Automotive Product Plus | Automotive | $709.56 | 343 | In Stock |
| 1568 | Deluxe Automotive Product Plus | Automotive | $338.43 | 182 | In Stock |
| 764 | Deluxe Automotive Product Plus | Automotive | $246.78 | 165 | In Stock |
| 1412 | Deluxe Automotive Product Pro | Automotive | $769.53 | 230 | In Stock |
| 2218 | Deluxe Automotive Product Pro | Automotive | $168.61 | 382 | In Stock |
| 1995 | Deluxe Automotive Product Pro | Automotive | $700.98 | 108 | In Stock |
| 2111 | Deluxe Automotive Product Special Edition | Automotive | $952.61 | 294 | In Stock |
| 760 | Deluxe Automotive Product Special Edition | Automotive | $569.15 | 112 | In Stock |
| 1193 | Deluxe Automotive Product Special Edition | Automotive | $52.08 | 158 | In Stock |
| 47 | Deluxe Automotive Product Special Edition | Automotive | $252.24 | 430 | In Stock |
| 3588 | Deluxe Automotive Product Special Edition | Automotive | $358.74 | 226 | In Stock |
| 2652 | Deluxe Automotive Product Special Edition | Automotive | $750.87 | 288 | In Stock |
| 2906 | Deluxe Automotive Product Special Edition | Automotive | $142.08 | 327 | In Stock |
| 4115 | Deluxe Automotive Product Special Edition | Automotive | $301.20 | 38 | Low Stock |
| 2567 | Deluxe Automotive Product XL | Automotive | $436.72 | 361 | In Stock |
| 613 | Deluxe Automotive Product XL | Automotive | $107.71 | 449 | In Stock |
| 1227 | Deluxe Automotive Product XL | Automotive | $657.02 | 70 | In Stock |
| 1195 | Economy Automotive Product 2024 | Automotive | $821.98 | 1 | Low Stock |
| 624 | Economy Automotive Product 2024 | Automotive | $576.20 | 111 | In Stock |
| 2298 | Economy Automotive Product 2024 | Automotive | $27.99 | 367 | In Stock |
| 1549 | Economy Automotive Product 2024 | Automotive | $97.02 | 322 | In Stock |
| 1775 | Economy Automotive Product 2024 | Automotive | $98.41 | 206 | In Stock |
| 2700 | Economy Automotive Product 2024 | Automotive | $738.89 | 395 | In Stock |
| 3145 | Economy Automotive Product 2024 | Automotive | $348.59 | 93 | In Stock |
| 3767 | Economy Automotive Product 2024 | Automotive | $899.64 | 222 | In Stock |
| 1511 | Economy Automotive Product Advanced | Automotive | $677.02 | 322 | In Stock |
| 1650 | Economy Automotive Product Classic | Automotive | $533.68 | 233 | In Stock |
| 2368 | Economy Automotive Product Classic | Automotive | $405.16 | 449 | In Stock |
| 2526 | Economy Automotive Product Classic | Automotive | $369.97 | 449 | In Stock |
| 995 | Economy Automotive Product Classic | Automotive | $13.12 | 434 | In Stock |
| 958 | Economy Automotive Product Classic | Automotive | $552.14 | 356 | In Stock |
| 4590 | Economy Automotive Product Classic | Automotive | $818.26 | 81 | In Stock |
| 4821 | Economy Automotive Product Lite | Automotive | $180.33 | 481 | In Stock |
| 4851 | Economy Automotive Product Lite | Automotive | $914.25 | 352 | In Stock |
| 4180 | Economy Automotive Product Lite | Automotive | $256.10 | 294 | In Stock |
| 1078 | Economy Automotive Product Lite | Automotive | $55.89 | 447 | In Stock |
| 75 | Economy Automotive Product Max | Automotive | $827.71 | 432 | In Stock |
| 1869 | Economy Automotive Product Max | Automotive | $859.60 | 135 | In Stock |
| 1608 | Economy Automotive Product Max | Automotive | $84.06 | 329 | In Stock |
| 4080 | Economy Automotive Product Max | Automotive | $616.40 | 108 | In Stock |
| 4836 | Economy Automotive Product Max | Automotive | $693.02 | 485 | In Stock |
| 2799 | Economy Automotive Product Max | Automotive | $101.67 | 437 | In Stock |
| 3555 | Economy Automotive Product Mini | Automotive | $698.46 | 373 | In Stock |
| 4564 | Economy Automotive Product Mini | Automotive | $52.90 | 228 | In Stock |
| 2097 | Economy Automotive Product Mini | Automotive | $215.07 | 224 | In Stock |
| 939 | Economy Automotive Product Mini | Automotive | $330.66 | 36 | Low Stock |
| 2217 | Economy Automotive Product Plus | Automotive | $310.72 | 146 | In Stock |
| 4750 | Economy Automotive Product Plus | Automotive | $457.89 | 18 | Low Stock |
| 4948 | Economy Automotive Product Plus | Automotive | $884.30 | 330 | In Stock |
| 4053 | Economy Automotive Product Plus | Automotive | $105.50 | 131 | In Stock |
| 3867 | Economy Automotive Product Pro | Automotive | $738.11 | 449 | In Stock |
| 3545 | Economy Automotive Product Pro | Automotive | $814.63 | 145 | In Stock |
| 2628 | Economy Automotive Product Pro | Automotive | $506.45 | 472 | In Stock |
| 1016 | Economy Automotive Product Pro | Automotive | $569.78 | 33 | Low Stock |
| 61 | Economy Automotive Product Pro | Automotive | $307.55 | 356 | In Stock |
| 95 | Economy Automotive Product Pro | Automotive | $585.14 | 115 | In Stock |
| 1342 | Economy Automotive Product Special Edition | Automotive | $624.59 | 171 | In Stock |
| 1930 | Economy Automotive Product Special Edition | Automotive | $321.08 | 108 | In Stock |
| 3453 | Economy Automotive Product Special Edition | Automotive | $773.13 | 4 | Low Stock |
| 4076 | Economy Automotive Product XL | Automotive | $641.04 | 348 | In Stock |
| 2529 | Economy Automotive Product XL | Automotive | $425.52 | 489 | In Stock |
| 2505 | Economy Automotive Product XL | Automotive | $601.28 | 76 | In Stock |
| 209 | Economy Automotive Product XL | Automotive | $803.34 | 144 | In Stock |
| 389 | Elite Automotive Product 2024 | Automotive | $197.91 | 44 | Low Stock |
| 2089 | Elite Automotive Product 2024 | Automotive | $403.93 | 1 | Low Stock |
| 4389 | Elite Automotive Product 2024 | Automotive | $519.37 | 411 | In Stock |
| 2849 | Elite Automotive Product 2024 | Automotive | $470.39 | 398 | In Stock |
| 3196 | Elite Automotive Product Advanced | Automotive | $287.45 | 427 | In Stock |
| 3711 | Elite Automotive Product Advanced | Automotive | $525.67 | 195 | In Stock |
| 2032 | Elite Automotive Product Advanced | Automotive | $755.69 | 383 | In Stock |
| 1688 | Elite Automotive Product Advanced | Automotive | $627.97 | 242 | In Stock |
| 1728 | Elite Automotive Product Advanced | Automotive | $239.56 | 185 | In Stock |
| 69 | Elite Automotive Product Advanced | Automotive | $373.70 | 246 | In Stock |
| 612 | Elite Automotive Product Classic | Automotive | $702.50 | 377 | In Stock |