{"product_id":"b0hctmkhwf","title":"Entity Framework Core in Practice: A Hands-On Guide to Data Access in C#\/.NET, from Fundamentals to Performance Tuning (C#\/.NET in Practice Book 2)","description":"\u003cp\u003eThe tutorial code runs. Then the data grows, and a query you thought fetched one row has quietly fired hundreds of SQL statements — that's the kind of framework EF Core is.\u003c\/p\u003e\n\n\u003cp\u003eIt works, but I'm not sure this is the right way to write it. This book answers that unease  by showing you the SQL EF Core actually emits . Instead of listing APIs, it digs into why you write it this way and what happens if you don't.\u003c\/p\u003e\n\n\u003cp\u003eOne example, grown to the end The whole book grows a single inventory and order management system. Nine entities pack in every theme you meet in real work:\u003c\/p\u003e\n\n\u003cp\u003e- Category and Product (one-to-many), many-to-many with Supplier, one-to-one with CustomerProfile\u003c\/p\u003e\n\n\u003cp\u003e- Order and OrderItem for the N+1 problem, InventoryTransaction for large-data performance\u003c\/p\u003e\n\n\u003cp\u003eYou build the model in Chapter 4 and reuse it thereafter, so the context never resets from chapter to chapter.\u003c\/p\u003e\n\n\u003cp\u003eWhat you'll learn - What an ORM is, how it differs from Dapper and ADO.NET, and when EF Core fits (and doesn't)\u003c\/p\u003e\n\n\u003cp\u003e- The Fluent API, migrations, and relationship design\u003c\/p\u003e\n\n\u003cp\u003e- LINQ, Include, change tracking\u003c\/p\u003e\n\n\u003cp\u003e- The N+1 problem, AsNoTracking, indexes, transactions and concurrency control\u003c\/p\u003e\n\n\u003cp\u003e- A testing strategy and a troubleshooting Q\u0026amp;A\u003c\/p\u003e\n\n\u003cp\u003eWho this is for - Developers who know basic C# (classes, properties, intro LINQ, async\/await)\u003c\/p\u003e\n\n\u003cp\u003e- Developers about to work with a database in .NET\u003c\/p\u003e\n\n\u003cp\u003e- Developers who use EF Core by feel but aren't confident about performance or design\u003c\/p\u003e\n\n\u003cp\u003eNo prior EF Core experience or advanced SQL required (SELECT \/ JOIN \/ WHERE is enough).\u003c\/p\u003e\n\n\u003cp\u003eC#\/.NET in Practice series This book is part of the C#\/.NET in Practice series.  Its companion  Building Desktop Apps with C# and WinUI 3  connects this data layer to a real UI. Each volume stands on its own.\u003c\/p\u003e\n\n\u003cp\u003eThe full sample is on GitHub.\u003c\/p\u003e","brand":"ANT","offers":[{"title":"Ebook","offer_id":52819459703000,"sku":"YSL33746","price":4.8,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0835\/3356\/2072\/files\/619sL53FEpL._SY1500.jpg?v=1793089682","url":"https:\/\/www.bookmebay.com\/products\/b0hctmkhwf","provider":"BookMebay","version":"1.0","type":"link"}