1a:I[4594,["1849","static/chunks/1849-0fc2bd73d6f2e163.js","6329","static/chunks/6329-deb7a466c19beaad.js","5687","static/chunks/5687-c1621349502ac098.js","7194","static/chunks/7194-92efb78e82eec78e.js","6384","static/chunks/app/t/%5Btag%5D/page-90992b381821f968.js"],"BrandMark"] 1b:I[1566,["1849","static/chunks/1849-0fc2bd73d6f2e163.js","6329","static/chunks/6329-deb7a466c19beaad.js","5687","static/chunks/5687-c1621349502ac098.js","7194","static/chunks/7194-92efb78e82eec78e.js","6384","static/chunks/app/t/%5Btag%5D/page-90992b381821f968.js"],"ThemeToggle"] 1c:I[9718,["1849","static/chunks/1849-0fc2bd73d6f2e163.js","6329","static/chunks/6329-deb7a466c19beaad.js","5687","static/chunks/5687-c1621349502ac098.js","7194","static/chunks/7194-92efb78e82eec78e.js","6384","static/chunks/app/t/%5Btag%5D/page-90992b381821f968.js"],"AccountMenu"] 1d:I[4113,["1849","static/chunks/1849-0fc2bd73d6f2e163.js","6329","static/chunks/6329-deb7a466c19beaad.js","5687","static/chunks/5687-c1621349502ac098.js","7194","static/chunks/7194-92efb78e82eec78e.js","6384","static/chunks/app/t/%5Btag%5D/page-90992b381821f968.js"],"LeftNavigation"] 1e:I[5608,["1849","static/chunks/1849-0fc2bd73d6f2e163.js","6329","static/chunks/6329-deb7a466c19beaad.js","5687","static/chunks/5687-c1621349502ac098.js","7194","static/chunks/7194-92efb78e82eec78e.js","6384","static/chunks/app/t/%5Btag%5D/page-90992b381821f968.js"],"ResponsiveBannerAd"] 1f:I[8424,["1849","static/chunks/1849-0fc2bd73d6f2e163.js","6329","static/chunks/6329-deb7a466c19beaad.js","5687","static/chunks/5687-c1621349502ac098.js","7194","static/chunks/7194-92efb78e82eec78e.js","6384","static/chunks/app/t/%5Btag%5D/page-90992b381821f968.js"],"TopicFollowButton"] 20:I[1577,["1849","static/chunks/1849-0fc2bd73d6f2e163.js","6329","static/chunks/6329-deb7a466c19beaad.js","5687","static/chunks/5687-c1621349502ac098.js","7194","static/chunks/7194-92efb78e82eec78e.js","6384","static/chunks/app/t/%5Btag%5D/page-90992b381821f968.js"],"FeedView"] 21:T316f,{"content":[{"attrs":{"level":2},"content":[{"text":"Introduction","type":"text"}],"type":"heading"},{"content":[{"text":"Almost every real-world application needs a ","type":"text"},{"marks":[{"type":"bold"}],"text":"database","type":"text"},{"text":".","type":"text"},{"type":"hardBreak"},{"text":"In the .NET ecosystem, ","type":"text"},{"marks":[{"type":"bold"}],"text":"Entity Framework Core (EF Core)","type":"text"},{"text":" is the most popular and powerful way to work with databases.","type":"text"}],"type":"paragraph"},{"content":[{"text":"EF Core allows you to:","type":"text"}],"type":"paragraph"},{"content":[{"content":[{"content":[{"text":"Work with databases using ","type":"text"},{"marks":[{"type":"bold"}],"text":"C# instead of SQL","type":"text"}],"type":"paragraph"}],"type":"listItem"},{"content":[{"content":[{"text":"Perform ","type":"text"},{"marks":[{"type":"bold"}],"text":"CRUD operations easily","type":"text"}],"type":"paragraph"}],"type":"listItem"},{"content":[{"content":[{"text":"Keep your database in sync using ","type":"text"},{"marks":[{"type":"bold"}],"text":"migrations","type":"text"}],"type":"paragraph"}],"type":"listItem"},{"content":[{"content":[{"text":"Write clean, maintainable data-access code","type":"text"}],"type":"paragraph"}],"type":"listItem"}],"type":"bulletList"},{"content":[{"text":"In this article, you\u2019ll learn ","type":"text"},{"marks":[{"type":"bold"}],"text":"EF Core from zero to production-ready basics","type":"text"},{"text":".","type":"text"}],"type":"paragraph"},{"attrs":{"level":2},"content":[{"text":"What Is Entity Framework Core?","type":"text"}],"type":"heading"},{"content":[{"marks":[{"type":"bold"}],"text":"Entity Framework Core (EF Core)","type":"text"},{"text":" is an ","type":"text"},{"marks":[{"type":"bold"}],"text":"Object-Relational Mapper (ORM)","type":"text"},{"text":".","type":"text"}],"type":"paragraph"},{"content":[{"text":"\ud83d\udc49 ORM means:","type":"text"}],"type":"paragraph"},{"content":[{"content":[{"text":"It maps ","type":"text"},{"marks":[{"type":"bold"}],"text":"database tables","type":"text"},{"text":" to ","type":"text"},{"marks":[{"type":"bold"}],"text":"C# classes","type":"text"},{"text":" automatically.","type":"text"}],"type":"paragraph"}],"type":"blockquote"},{"attrs":{"level":3},"content":[{"text":"Without EF Core","type":"text"}],"type":"heading"},{"attrs":{"language":"plaintext"},"content":[{"text":"SELECT * FROM Products WHERE Id = 1;\r\n","type":"text"}],"type":"codeBlock"},{"attrs":{"level":3},"content":[{"text":"With EF Core","type":"text"}],"type":"heading"},{"attrs":{"language":"cs"},"content":[{"text":"var product = context.Products.FirstOrDefault(p => p.Id == 1);\r\n","type":"text"}],"type":"codeBlock"},{"content":[{"text":"\u2714 Less SQL","type":"text"},{"type":"hardBreak"},{"text":"\u2714 More productivity","type":"text"},{"type":"hardBreak"},{"text":"\u2714 Strong typing","type":"text"}],"type":"paragraph"},{"attrs":{"level":2},"content":[{"text":"EF Core Architecture (High Level)","type":"text"}],"type":"heading"},{"attrs":{"language":"plaintext"},"content":[{"text":"Controller \u2192 Service \u2192 DbContext \u2192 Database\r\n","type":"text"}],"type":"codeBlock"},{"content":[{"content":[{"content":[{"marks":[{"type":"bold"}],"text":"DbContext","type":"text"},{"text":" \u2192 Database session","type":"text"}],"type":"paragraph"}],"type":"listItem"},{"content":[{"content":[{"marks":[{"type":"bold"}],"text":"DbSet","type":"text"},{"text":" \u2192 Table","type":"text"}],"type":"paragraph"}],"type":"listItem"},{"content":[{"content":[{"marks":[{"type":"bold"}],"text":"Entity","type":"text"},{"text":" \u2192 Table row","type":"text"}],"type":"paragraph"}],"type":"listItem"}],"type":"bulletList"},{"attrs":{"level":2},"content":[{"text":"Step 1: Install EF Core Packages","type":"text"}],"type":"heading"},{"content":[{"text":"For SQL Server:","type":"text"}],"type":"paragraph"},{"attrs":{"language":"plaintext"},"content":[{"text":"dotnet add package Microsoft.EntityFrameworkCore.SqlServer\r\ndotnet add package Microsoft.EntityFrameworkCore.Tools\r\n","type":"text"}],"type":"codeBlock"},{"attrs":{"level":2},"content":[{"text":"Step 2: Create Your First Entity (Model)","type":"text"}],"type":"heading"},{"attrs":{"language":"cs"},"content":[{"text":"public class Product\r\n{\r\n public int Id { get; set; }\r\n public string Name { get; set; }\r\n public decimal Price { get; set; }\r\n}\r\n","type":"text"}],"type":"codeBlock"},{"content":[{"text":"\u2714 One class = One database table","type":"text"}],"type":"paragraph"},{"attrs":{"level":2},"content":[{"text":"Step 3: Create DbContext","type":"text"}],"type":"heading"},{"attrs":{"language":"cs"},"content":[{"text":"public class AppDbContext : DbContext\r\n{\r\n public AppDbContext(DbContextOptions options)\r\n : base(options) { }\r\n\r\n public DbSet Products { get; set; }\r\n}\r\n","type":"text"}],"type":"codeBlock"},{"content":[{"text":"\ud83d\udccc ","type":"text"},{"marks":[{"type":"code"}],"text":"DbContext","type":"text"},{"text":" manages database connections and queries.","type":"text"}],"type":"paragraph"},{"attrs":{"level":2},"content":[{"text":"Step 4: Configure Database Connection","type":"text"}],"type":"heading"},{"attrs":{"level":3},"content":[{"text":"appsettings.json","type":"text"}],"type":"heading"},{"attrs":{"language":"plaintext"},"content":[{"text":"\"ConnectionStrings\": {\r\n \"DefaultConnection\": \"Server=.;Database=ShopDb;Trusted_Connection=True;\"\r\n}\r\n","type":"text"}],"type":"codeBlock"},{"attrs":{"level":3},"content":[{"text":"Program.cs","type":"text"}],"type":"heading"},{"attrs":{"language":"cs"},"content":[{"text":"builder.Services.AddDbContext(options =>\r\n options.UseSqlServer(builder.Configuration.GetConnectionString(\"DefaultConnection\"))\r\n);\r\n","type":"text"}],"type":"codeBlock"},{"attrs":{"level":2},"content":[{"text":"Step 5: EF Core Migrations","type":"text"}],"type":"heading"},{"content":[{"text":"Migrations keep your ","type":"text"},{"marks":[{"type":"bold"}],"text":"database schema","type":"text"},{"text":" in sync with code.","type":"text"}],"type":"paragraph"},{"attrs":{"level":3},"content":[{"text":"Create Migration","type":"text"}],"type":"heading"},{"attrs":{"language":"plaintext"},"content":[{"text":"dotnet ef migrations add InitialCreate\r\n","type":"text"}],"type":"codeBlock"},{"attrs":{"level":3},"content":[{"text":"Apply Migration","type":"text"}],"type":"heading"},{"attrs":{"language":"plaintext"},"content":[{"text":"dotnet ef database update\r\n","type":"text"}],"type":"codeBlock"},{"content":[{"text":"\u2714 Tables are created automatically","type":"text"},{"type":"hardBreak"},{"text":"\u2714 No manual SQL needed","type":"text"}],"type":"paragraph"},{"attrs":{"level":2},"content":[{"text":"Step 6: CRUD Operations with EF Core","type":"text"}],"type":"heading"},{"attrs":{"level":3},"content":[{"text":"Create (Insert)","type":"text"}],"type":"heading"},{"attrs":{"language":"cs"},"content":[{"text":"context.Products.Add(new Product\r\n{\r\n Name = \"Laptop\",\r\n Price = 1200\r\n});\r\ncontext.SaveChanges();\r\n","type":"text"}],"type":"codeBlock"},{"attrs":{"level":3},"content":[{"text":"Read (Select)","type":"text"}],"type":"heading"},{"attrs":{"language":"cs"},"content":[{"text":"var products = context.Products.ToList();\r\n","type":"text"}],"type":"codeBlock"},{"attrs":{"language":"cs"},"content":[{"text":"var product = context.Products.Find(1);\r\n","type":"text"}],"type":"codeBlock"},{"attrs":{"level":3},"content":[{"text":"Update","type":"text"}],"type":"heading"},{"attrs":{"language":"cs"},"content":[{"text":"var product = context.Products.Find(1);\r\nproduct.Price = 1500;\r\ncontext.SaveChanges();\r\n","type":"text"}],"type":"codeBlock"},{"attrs":{"level":3},"content":[{"text":"Delete","type":"text"}],"type":"heading"},{"attrs":{"language":"cs"},"content":[{"text":"var product = context.Products.Find(1);\r\ncontext.Products.Remove(product);\r\ncontext.SaveChanges();\r\n","type":"text"}],"type":"codeBlock"},{"attrs":{"level":2},"content":[{"text":"Step 7: LINQ Queries in EF Core","type":"text"}],"type":"heading"},{"content":[{"text":"EF Core uses ","type":"text"},{"marks":[{"type":"bold"}],"text":"LINQ","type":"text"},{"text":" to query data.","type":"text"}],"type":"paragraph"},{"attrs":{"language":"cs"},"content":[{"text":"var expensiveProducts = context.Products\r\n .Where(p => p.Price > 1000)\r\n .OrderByDescending(p => p.Price)\r\n .ToList();\r\n","type":"text"}],"type":"codeBlock"},{"content":[{"text":"\u2714 Strongly typed","type":"text"},{"type":"hardBreak"},{"text":"\u2714 Compile-time safety","type":"text"}],"type":"paragraph"},{"attrs":{"level":2},"content":[{"text":"Step 8: Relationships in EF Core","type":"text"}],"type":"heading"},{"attrs":{"level":3},"content":[{"text":"One-to-Many Example","type":"text"}],"type":"heading"},{"attrs":{"language":"cs"},"content":[{"text":"public class Category\r\n{\r\n public int Id { get; set; }\r\n public string Name { get; set; }\r\n\r\n public List Products { get; set; }\r\n}\r\n","type":"text"}],"type":"codeBlock"},{"attrs":{"language":"cs"},"content":[{"text":"public class Product\r\n{\r\n public int Id { get; set; }\r\n public string Name { get; set; }\r\n\r\n public int CategoryId { get; set; }\r\n public Category Category { get; set; }\r\n}\r\n","type":"text"}],"type":"codeBlock"},{"content":[{"text":"EF Core automatically creates ","type":"text"},{"marks":[{"type":"bold"}],"text":"foreign keys","type":"text"},{"text":".","type":"text"}],"type":"paragraph"},{"attrs":{"level":2},"content":[{"text":"Step 9: Async Operations (Best Practice)","type":"text"}],"type":"heading"},{"attrs":{"language":"cs"},"content":[{"text":"var products = await context.Products.ToListAsync();\r\n","type":"text"}],"type":"codeBlock"},{"content":[{"text":"\u2714 Better performance","type":"text"},{"type":"hardBreak"},{"text":"\u2714 Scales well","type":"text"}],"type":"paragraph"},{"attrs":{"level":2},"content":[{"text":"Common EF Core Mistakes \ud83d\udeab","type":"text"}],"type":"heading"},{"content":[{"content":[{"content":[{"text":"Forgetting ","type":"text"},{"marks":[{"type":"code"}],"text":"SaveChanges()","type":"text"}],"type":"paragraph"}],"type":"listItem"},{"content":[{"content":[{"text":"Not using async methods","type":"text"}],"type":"paragraph"}],"type":"listItem"},{"content":[{"content":[{"text":"Exposing DbContext directly","type":"text"}],"type":"paragraph"}],"type":"listItem"},{"content":[{"content":[{"text":"Loading too much data (no pagination)","type":"text"}],"type":"paragraph"}],"type":"listItem"},{"content":[{"content":[{"text":"Ignoring indexes","type":"text"}],"type":"paragraph"}],"type":"listItem"}],"type":"bulletList"},{"attrs":{"level":2},"content":[{"text":"EF Core Best Practices \u2705","type":"text"}],"type":"heading"},{"content":[{"content":[{"content":[{"text":"Use ","type":"text"},{"marks":[{"type":"bold"}],"text":"DTOs","type":"text"},{"text":", not entities in API responses","type":"text"}],"type":"paragraph"}],"type":"listItem"},{"content":[{"content":[{"text":"Use ","type":"text"},{"marks":[{"type":"code"}],"text":"AsNoTracking()","type":"text"},{"text":" for read-only queries","type":"text"}],"type":"paragraph"}],"type":"listItem"},{"content":[{"content":[{"text":"Keep DbContext lifetime ","type":"text"},{"marks":[{"type":"bold"}],"text":"scoped","type":"text"}],"type":"paragraph"}],"type":"listItem"},{"content":[{"content":[{"text":"Add indexes for frequently queried columns","type":"text"}],"type":"paragraph"}],"type":"listItem"},{"content":[{"content":[{"text":"Separate data access from controllers","type":"text"}],"type":"paragraph"}],"type":"listItem"}],"type":"bulletList"},{"attrs":{"level":2},"content":[{"text":"What You\u2019ve Learned","type":"text"}],"type":"heading"},{"content":[{"text":"\u2714 What EF Core is","type":"text"},{"type":"hardBreak"},{"text":"\u2714 DbContext & DbSet","type":"text"},{"type":"hardBreak"},{"text":"\u2714 Migrations","type":"text"},{"type":"hardBreak"},{"text":"\u2714 CRUD operations","type":"text"},{"type":"hardBreak"},{"text":"\u2714 LINQ queries","type":"text"},{"type":"hardBreak"},{"text":"\u2714 Relationships","type":"text"}],"type":"paragraph"},{"content":[{"text":"You can now build ","type":"text"},{"marks":[{"type":"bold"}],"text":"real database-driven applications","type":"text"},{"text":" with ASP.NET Core \ud83d\ude80","type":"text"}],"type":"paragraph"}],"type":"doc"}13:[["$","a",null,{"href":"#main-content","className":"bg-brand fixed top-3 left-3 z-[100] -translate-y-20 rounded-lg px-4 py-2 font-semibold text-white transition focus:translate-y-0 dark:text-slate-950","children":"Skip to content"}],["$","header",null,{"className":"border-border bg-canvas/92 sticky top-0 z-40 border-b backdrop-blur-xl","children":["$","div",null,{"className":"mx-auto flex h-16 max-w-[1440px] items-center gap-3 px-4 sm:px-6","children":[["$","$L1a",null,{}],["$","form",null,{"role":"search","action":"/search","className":"relative ml-3 hidden max-w-xl flex-1 md:block","children":[["$","label",null,{"htmlFor":"global-search","className":"sr-only","children":"Search articles, tags and people"}],["$","svg",null,{"aria-hidden":"true","viewBox":"0 0 24 24","fill":"none","stroke":"currentColor","strokeWidth":"1.8","strokeLinecap":"round","strokeLinejoin":"round","className":"text-ink-muted pointer-events-none absolute top-1/2 left-3 size-5 -translate-y-1/2","children":[["$","circle",null,{"cx":"11","cy":"11","r":"7"}],["$","path",null,{"d":"m20 20-4-4"}]]}],["$","input",null,{"id":"global-search","name":"q","type":"search","placeholder":"Search articles, tags and people","className":"border-border bg-surface placeholder:text-ink-muted/75 h-11 w-full rounded-xl border pr-4 pl-10 text-sm"}]]}],["$","div",null,{"className":"ml-auto flex items-center gap-2","children":[["$","$Ld",null,{"href":"/search","aria-label":"Search","className":"hover:bg-brand-soft grid size-11 place-items-center rounded-xl md:hidden","children":["$","svg",null,{"aria-hidden":"true","viewBox":"0 0 24 24","fill":"none","stroke":"currentColor","strokeWidth":"1.8","strokeLinecap":"round","strokeLinejoin":"round","className":"size-5","children":"$13:1:props:children:props:children:1:props:children:1:props:children"}]}],["$","$L1b",null,{}],["$","div",null,{"className":"hidden sm:block","children":["$","$Ld",null,{"href":"/dashboard/posts/new","className":"bg-brand hover:bg-brand-strong inline-flex min-h-11 items-center justify-center gap-2 rounded-xl px-4 py-2 text-sm font-semibold text-white transition dark:text-slate-950","children":[["$","svg",null,{"aria-hidden":"true","viewBox":"0 0 24 24","fill":"none","stroke":"currentColor","strokeWidth":"1.8","strokeLinecap":"round","strokeLinejoin":"round","className":"size-4","children":[["$","path",null,{"d":"m4 20 4.5-1 10-10-3.5-3.5-10 10L4 20Z"}],["$","path",null,{"d":"m13.5 7 3.5 3.5"}]]}],"Write"]}]}],["$","$L1c",null,{}]]}]]}]}],["$","div",null,{"className":"mx-auto grid max-w-[1460px] grid-cols-1 gap-6 px-4 pt-6 pb-24 sm:px-6 lg:grid-cols-[220px_minmax(0,760px)] lg:pb-10 xl:grid-cols-[220px_minmax(0,760px)_300px]","children":[["$","$L1d",null,{}],["$","main",null,{"id":"main-content","tabIndex":-1,"className":"min-w-0","children":[["$","$L1e",null,{}],[["$","section",null,{"className":"border-border bg-surface rounded-2xl border shadow-[0_1px_2px_rgb(15_23_42/0.03)] mb-6 p-6 sm:p-8","children":["$","div",null,{"className":"flex flex-col gap-5 sm:flex-row sm:items-center","children":[["$","div",null,{"className":"bg-brand-soft text-brand relative grid size-20 shrink-0 place-items-center overflow-hidden rounded-2xl text-3xl font-bold","children":["$","span",null,{"aria-hidden":"true","children":"#"}]}],["$","div",null,{"className":"min-w-0 flex-1","children":[["$","p",null,{"className":"text-brand text-sm font-semibold","children":"Topic"}],["$","h1",null,{"className":"mt-1 text-3xl font-bold tracking-tight break-words","children":["#","dotnet-orm"]}],["$","p",null,{"className":"text-ink-muted mt-2 max-w-3xl leading-7","children":"Articles tagged dotnet-orm."}],["$","p",null,{"className":"text-ink-muted mt-3 text-sm","children":["1"," ","article"]}]]}],["$","$L1f",null,{"topicId":998,"topicName":"dotnet-orm","initialFollowing":false,"initialFollowerCount":0,"authenticated":false,"returnTo":"/t/dotnet-orm"}]]}]}],["$","$L20",null,{"data":{"count":1,"next":null,"previous":null,"results":[{"id":284,"slug":"entity-framework-core-ef-core-database-integration-made-easy","title":"🗄️ Entity Framework Core (EF Core): Database Integration Made Easy","excerpt":"Introduction Almost every real-world application needs a database . In the .NET ecosystem, Entity Framework Core (EF Core) is the most popular and powerful way to work with databas","content":[{"type":"richText","document":{"content":[{"attrs":{"level":2},"content":[{"text":"Introduction","type":"text"}],"type":"heading"},{"content":[{"text":"Almost every real-world application needs a ","type":"text"},{"marks":[{"type":"bold"}],"text":"database","type":"text"},{"text":".","type":"text"},{"type":"hardBreak"},{"text":"In the .NET ecosystem, ","type":"text"},{"marks":[{"type":"bold"}],"text":"Entity Framework Core (EF Core)","type":"text"},{"text":" is the most popular and powerful way to work with databases.","type":"text"}],"type":"paragraph"},{"content":[{"text":"EF Core allows you to:","type":"text"}],"type":"paragraph"},{"content":[{"content":[{"content":[{"text":"Work with databases using ","type":"text"},{"marks":[{"type":"bold"}],"text":"C# instead of SQL","type":"text"}],"type":"paragraph"}],"type":"listItem"},{"content":[{"content":[{"text":"Perform ","type":"text"},{"marks":[{"type":"bold"}],"text":"CRUD operations easily","type":"text"}],"type":"paragraph"}],"type":"listItem"},{"content":[{"content":[{"text":"Keep your database in sync using ","type":"text"},{"marks":[{"type":"bold"}],"text":"migrations","type":"text"}],"type":"paragraph"}],"type":"listItem"},{"content":[{"content":[{"text":"Write clean, maintainable data-access code","type":"text"}],"type":"paragraph"}],"type":"listItem"}],"type":"bulletList"},{"content":[{"text":"In this article, you’ll learn ","type":"text"},{"marks":[{"type":"bold"}],"text":"EF Core from zero to production-ready basics","type":"text"},{"text":".","type":"text"}],"type":"paragraph"},{"attrs":{"level":2},"content":[{"text":"What Is Entity Framework Core?","type":"text"}],"type":"heading"},{"content":[{"marks":[{"type":"bold"}],"text":"Entity Framework Core (EF Core)","type":"text"},{"text":" is an ","type":"text"},{"marks":[{"type":"bold"}],"text":"Object-Relational Mapper (ORM)","type":"text"},{"text":".","type":"text"}],"type":"paragraph"},{"content":[{"text":"👉 ORM means:","type":"text"}],"type":"paragraph"},{"content":[{"content":[{"text":"It maps ","type":"text"},{"marks":[{"type":"bold"}],"text":"database tables","type":"text"},{"text":" to ","type":"text"},{"marks":[{"type":"bold"}],"text":"C# classes","type":"text"},{"text":" automatically.","type":"text"}],"type":"paragraph"}],"type":"blockquote"},{"attrs":{"level":3},"content":[{"text":"Without EF Core","type":"text"}],"type":"heading"},{"attrs":{"language":"plaintext"},"content":[{"text":"SELECT * FROM Products WHERE Id = 1;\r\n","type":"text"}],"type":"codeBlock"},{"attrs":{"level":3},"content":[{"text":"With EF Core","type":"text"}],"type":"heading"},{"attrs":{"language":"cs"},"content":[{"text":"var product = context.Products.FirstOrDefault(p => p.Id == 1);\r\n","type":"text"}],"type":"codeBlock"},{"content":[{"text":"✔ Less SQL","type":"text"},{"type":"hardBreak"},{"text":"✔ More productivity","type":"text"},{"type":"hardBreak"},{"text":"✔ Strong typing","type":"text"}],"type":"paragraph"},{"attrs":{"level":2},"content":[{"text":"EF Core Architecture (High Level)","type":"text"}],"type":"heading"},{"attrs":{"language":"plaintext"},"content":[{"text":"Controller → Service → DbContext → Database\r\n","type":"text"}],"type":"codeBlock"},{"content":[{"content":[{"content":[{"marks":[{"type":"bold"}],"text":"DbContext","type":"text"},{"text":" → Database session","type":"text"}],"type":"paragraph"}],"type":"listItem"},{"content":[{"content":[{"marks":[{"type":"bold"}],"text":"DbSet","type":"text"},{"text":" → Table","type":"text"}],"type":"paragraph"}],"type":"listItem"},{"content":[{"content":[{"marks":[{"type":"bold"}],"text":"Entity","type":"text"},{"text":" → Table row","type":"text"}],"type":"paragraph"}],"type":"listItem"}],"type":"bulletList"},{"attrs":{"level":2},"content":[{"text":"Step 1: Install EF Core Packages","type":"text"}],"type":"heading"},{"content":[{"text":"For SQL Server:","type":"text"}],"type":"paragraph"},{"attrs":{"language":"plaintext"},"content":[{"text":"dotnet add package Microsoft.EntityFrameworkCore.SqlServer\r\ndotnet add package Microsoft.EntityFrameworkCore.Tools\r\n","type":"text"}],"type":"codeBlock"},{"attrs":{"level":2},"content":[{"text":"Step 2: Create Your First Entity (Model)","type":"text"}],"type":"heading"},{"attrs":{"language":"cs"},"content":[{"text":"public class Product\r\n{\r\n public int Id { get; set; }\r\n public string Name { get; set; }\r\n public decimal Price { get; set; }\r\n}\r\n","type":"text"}],"type":"codeBlock"},{"content":[{"text":"✔ One class = One database table","type":"text"}],"type":"paragraph"},{"attrs":{"level":2},"content":[{"text":"Step 3: Create DbContext","type":"text"}],"type":"heading"},{"attrs":{"language":"cs"},"content":[{"text":"public class AppDbContext : DbContext\r\n{\r\n public AppDbContext(DbContextOptions options)\r\n : base(options) { }\r\n\r\n public DbSet Products { get; set; }\r\n}\r\n","type":"text"}],"type":"codeBlock"},{"content":[{"text":"📌 ","type":"text"},{"marks":[{"type":"code"}],"text":"DbContext","type":"text"},{"text":" manages database connections and queries.","type":"text"}],"type":"paragraph"},{"attrs":{"level":2},"content":[{"text":"Step 4: Configure Database Connection","type":"text"}],"type":"heading"},{"attrs":{"level":3},"content":[{"text":"appsettings.json","type":"text"}],"type":"heading"},{"attrs":{"language":"plaintext"},"content":[{"text":"\"ConnectionStrings\": {\r\n \"DefaultConnection\": \"Server=.;Database=ShopDb;Trusted_Connection=True;\"\r\n}\r\n","type":"text"}],"type":"codeBlock"},{"attrs":{"level":3},"content":[{"text":"Program.cs","type":"text"}],"type":"heading"},{"attrs":{"language":"cs"},"content":[{"text":"builder.Services.AddDbContext(options =>\r\n options.UseSqlServer(builder.Configuration.GetConnectionString(\"DefaultConnection\"))\r\n);\r\n","type":"text"}],"type":"codeBlock"},{"attrs":{"level":2},"content":[{"text":"Step 5: EF Core Migrations","type":"text"}],"type":"heading"},{"content":[{"text":"Migrations keep your ","type":"text"},{"marks":[{"type":"bold"}],"text":"database schema","type":"text"},{"text":" in sync with code.","type":"text"}],"type":"paragraph"},{"attrs":{"level":3},"content":[{"text":"Create Migration","type":"text"}],"type":"heading"},{"attrs":{"language":"plaintext"},"content":[{"text":"dotnet ef migrations add InitialCreate\r\n","type":"text"}],"type":"codeBlock"},{"attrs":{"level":3},"content":[{"text":"Apply Migration","type":"text"}],"type":"heading"},{"attrs":{"language":"plaintext"},"content":[{"text":"dotnet ef database update\r\n","type":"text"}],"type":"codeBlock"},{"content":[{"text":"✔ Tables are created automatically","type":"text"},{"type":"hardBreak"},{"text":"✔ No manual SQL needed","type":"text"}],"type":"paragraph"},{"attrs":{"level":2},"content":[{"text":"Step 6: CRUD Operations with EF Core","type":"text"}],"type":"heading"},{"attrs":{"level":3},"content":[{"text":"Create (Insert)","type":"text"}],"type":"heading"},{"attrs":{"language":"cs"},"content":[{"text":"context.Products.Add(new Product\r\n{\r\n Name = \"Laptop\",\r\n Price = 1200\r\n});\r\ncontext.SaveChanges();\r\n","type":"text"}],"type":"codeBlock"},{"attrs":{"level":3},"content":[{"text":"Read (Select)","type":"text"}],"type":"heading"},{"attrs":{"language":"cs"},"content":[{"text":"var products = context.Products.ToList();\r\n","type":"text"}],"type":"codeBlock"},{"attrs":{"language":"cs"},"content":[{"text":"var product = context.Products.Find(1);\r\n","type":"text"}],"type":"codeBlock"},{"attrs":{"level":3},"content":[{"text":"Update","type":"text"}],"type":"heading"},{"attrs":{"language":"cs"},"content":[{"text":"var product = context.Products.Find(1);\r\nproduct.Price = 1500;\r\ncontext.SaveChanges();\r\n","type":"text"}],"type":"codeBlock"},{"attrs":{"level":3},"content":[{"text":"Delete","type":"text"}],"type":"heading"},{"attrs":{"language":"cs"},"content":[{"text":"var product = context.Products.Find(1);\r\ncontext.Products.Remove(product);\r\ncontext.SaveChanges();\r\n","type":"text"}],"type":"codeBlock"},{"attrs":{"level":2},"content":[{"text":"Step 7: LINQ Queries in EF Core","type":"text"}],"type":"heading"},{"content":[{"text":"EF Core uses ","type":"text"},{"marks":[{"type":"bold"}],"text":"LINQ","type":"text"},{"text":" to query data.","type":"text"}],"type":"paragraph"},{"attrs":{"language":"cs"},"content":[{"text":"var expensiveProducts = context.Products\r\n .Where(p => p.Price > 1000)\r\n .OrderByDescending(p => p.Price)\r\n .ToList();\r\n","type":"text"}],"type":"codeBlock"},{"content":[{"text":"✔ Strongly typed","type":"text"},{"type":"hardBreak"},{"text":"✔ Compile-time safety","type":"text"}],"type":"paragraph"},{"attrs":{"level":2},"content":[{"text":"Step 8: Relationships in EF Core","type":"text"}],"type":"heading"},{"attrs":{"level":3},"content":[{"text":"One-to-Many Example","type":"text"}],"type":"heading"},{"attrs":{"language":"cs"},"content":[{"text":"public class Category\r\n{\r\n public int Id { get; set; }\r\n public string Name { get; set; }\r\n\r\n public List Products { get; set; }\r\n}\r\n","type":"text"}],"type":"codeBlock"},{"attrs":{"language":"cs"},"content":[{"text":"public class Product\r\n{\r\n public int Id { get; set; }\r\n public string Name { get; set; }\r\n\r\n public int CategoryId { get; set; }\r\n public Category Category { get; set; }\r\n}\r\n","type":"text"}],"type":"codeBlock"},{"content":[{"text":"EF Core automatically creates ","type":"text"},{"marks":[{"type":"bold"}],"text":"foreign keys","type":"text"},{"text":".","type":"text"}],"type":"paragraph"},{"attrs":{"level":2},"content":[{"text":"Step 9: Async Operations (Best Practice)","type":"text"}],"type":"heading"},{"attrs":{"language":"cs"},"content":[{"text":"var products = await context.Products.ToListAsync();\r\n","type":"text"}],"type":"codeBlock"},{"content":[{"text":"✔ Better performance","type":"text"},{"type":"hardBreak"},{"text":"✔ Scales well","type":"text"}],"type":"paragraph"},{"attrs":{"level":2},"content":[{"text":"Common EF Core Mistakes 🚫","type":"text"}],"type":"heading"},{"content":[{"content":[{"content":[{"text":"Forgetting ","type":"text"},{"marks":[{"type":"code"}],"text":"SaveChanges()","type":"text"}],"type":"paragraph"}],"type":"listItem"},{"content":[{"content":[{"text":"Not using async methods","type":"text"}],"type":"paragraph"}],"type":"listItem"},{"content":[{"content":[{"text":"Exposing DbContext directly","type":"text"}],"type":"paragraph"}],"type":"listItem"},{"content":[{"content":[{"text":"Loading too much data (no pagination)","type":"text"}],"type":"paragraph"}],"type":"listItem"},{"content":[{"content":[{"text":"Ignoring indexes","type":"text"}],"type":"paragraph"}],"type":"listItem"}],"type":"bulletList"},{"attrs":{"level":2},"content":[{"text":"EF Core Best Practices ✅","type":"text"}],"type":"heading"},{"content":[{"content":[{"content":[{"text":"Use ","type":"text"},{"marks":[{"type":"bold"}],"text":"DTOs","type":"text"},{"text":", not entities in API responses","type":"text"}],"type":"paragraph"}],"type":"listItem"},{"content":[{"content":[{"text":"Use ","type":"text"},{"marks":[{"type":"code"}],"text":"AsNoTracking()","type":"text"},{"text":" for read-only queries","type":"text"}],"type":"paragraph"}],"type":"listItem"},{"content":[{"content":[{"text":"Keep DbContext lifetime ","type":"text"},{"marks":[{"type":"bold"}],"text":"scoped","type":"text"}],"type":"paragraph"}],"type":"listItem"},{"content":[{"content":[{"text":"Add indexes for frequently queried columns","type":"text"}],"type":"paragraph"}],"type":"listItem"},{"content":[{"content":[{"text":"Separate data access from controllers","type":"text"}],"type":"paragraph"}],"type":"listItem"}],"type":"bulletList"},{"attrs":{"level":2},"content":[{"text":"What You’ve Learned","type":"text"}],"type":"heading"},{"content":[{"text":"✔ What EF Core is","type":"text"},{"type":"hardBreak"},{"text":"✔ DbContext & DbSet","type":"text"},{"type":"hardBreak"},{"text":"✔ Migrations","type":"text"},{"type":"hardBreak"},{"text":"✔ CRUD operations","type":"text"},{"type":"hardBreak"},{"text":"✔ LINQ queries","type":"text"},{"type":"hardBreak"},{"text":"✔ Relationships","type":"text"}],"type":"paragraph"},{"content":[{"text":"You can now build ","type":"text"},{"marks":[{"type":"bold"}],"text":"real database-driven applications","type":"text"},{"text":" with ASP.NET Core 🚀","type":"text"}],"type":"paragraph"}],"type":"doc"}}],"author":{"userId":15,"name":"Samim Hossain","username":"Samim.Hossain","bio":"devs3 community author","profileImage":"https://res.cloudinary.com/dpoholbpp/image/upload/v1787830404/legacy/8d/8daefee7a2783e5fd73c50184987e278d042901d881ff5e5ff79b2ae8e832c90.jpg"},"tags":["ef-core","orm","dotnet","dotnet-core","entity-framework-core","entity-framework","dotnet-orm"],"publishedAt":"2026-02-01T12:00:00Z","updatedAt":"2026-08-25T08:20:52.731870Z","coverImage":"https://res.cloudinary.com/dpoholbpp/image/upload/v1787830221/legacy/d5/d5d85b62b98a7bd1d423fa538e2b538186df6a78a70446934313258392f0d688.png","reactions":1,"comments":0,"views":315,"periodViews":"$undefined","readTime":3,"featured":false,"rawDetails":"$21"}],"source":"api"},"mode":"top","title":"Articles","eyebrow":"Explore #dotnet-orm","basePath":"/t/dotnet-orm","tag":"dotnet-orm","showModeTabs":true}]]]}],"$L22"]}],"$L23","$L24"]