Khalid Abuhakmeh

Khalid Abuhakmeh's Blog
  • Office Hours
  • Resumé
  • About
  • 🔍 Search

Tag - "entity-framework"

A collection of 14 posts

May 17, 2022

Using SQL Server Cursors with Entity Framework Core

Using SQL Server Cursors with Entity Framework Core

Most relational databases are a modern marvel, with many features waiting for you to use. However, for .NET developers, you often need to discover methods to get data into and out of our database instances that work for our use...

Continue Reading

entity-framework dotnet sql

October 19, 2021

Bulk Import Records Into SQLite With C#

Bulk Import Records Into SQLite With C#

I’ve grown fond of SQLite during my time as a developer advocate. The file-based database with native drivers for every operating system allows me to ship self-contained data-driven sample apps to developers worldwide. Developers can clone a demo and run...

Continue Reading

sql entity-framework

October 12, 2021

Cursor Paging With Entity Framework Core and ASP.NET Core

Cursor Paging With Entity Framework Core and ASP.NET Core

When building APIs that return a non-trivial amount of data, we need to make design decisions based on our underlying database. For example, a developer may implement a specific endpoint in APIs that allows clients to return a window-based collection....

Continue Reading

entity-framework

October 5, 2021

Entity Framework Core ConnectionStrings For .NET Apps

Entity Framework Core ConnectionStrings For .NET Apps

If you’re anything like me, you set up your Entity Framework Core DbContext and your connectionString once in a blue moon and forget about it. Connection strings are essential parts of a functioning application, but we forget the nuance in...

Continue Reading

entity-framework

April 8, 2021

Recursive Data With Entity Framework Core and SQL Server

Recursive Data With Entity Framework Core and SQL Server

One of the most powerful features of relational database engines is the ability for tables to be self-referential. Having rows reference other rows within the same table allows us to create complex hierarchies and tree structures with minimal effort.

Continue Reading

entity-framework dotnet

April 6, 2021

Modeling Most SQL Relationships In Entity Framework Core

Modeling Most SQL Relationships In Entity Framework Core

Object Relational Mappers (ORMs) allow us to define relationships between entities in our relational database using C# objects. Depending on which ORM we use, we can also get the library to generate the relationships’ schema. Entity Framework Core is one...

Continue Reading

entity-framework dotnet

March 23, 2021

How To Add A View To An Entity Framework Core DbContext

How To Add A View To An Entity Framework Core DbContext

Working with databases is a fun yet challenging task. As our application’s mature, we see opportunities to optimize our codebase along with query performance. Views are a great way to achieve both goals. With Entity Framework Core 5 (EF Core),...

Continue Reading

sql entity-framework

March 4, 2021

Raw SQL Queries With Entity Framework Core 5

Raw SQL Queries With Entity Framework Core 5

Entity Framework Core 5 (EF Core) and LINQ allow developers to write powerful expressions that translate into SQL. Ultimately, ORMs are about balancing convenience and power. Generally, EF Core’s default features are enough to accomplish most data access-related tasks, but...

Continue Reading

entity-framework

March 2, 2021

Streaming Vs. Buffered Results With Entity Framework Core 5

Streaming Vs. Buffered Results With Entity Framework Core 5

Working with databases means writing queries, getting results, measuring performance, and then optimizing. The cycle never ends. Luckily, for Entity Framework Core 5 (EF Core) users, we have a few options for optimizing our queries. With an IDE like JetBrains...

Continue Reading

entity-framework dotnet

February 25, 2021

Entity Framework Core 5 Value Converters

Entity Framework Core 5 Value Converters

I’ve been diving into Entity Framework Core 5 and learning all I can about the object-relational mapper’s (ORM) inner-workings. With EF Core 5, the newer ORM has learned from its namesake Entity Framework’s past sins. With extensibility points and smarter...

Continue Reading

entity-framework database

Page 1 of 2 Older Posts

Twitter GitHub RSS Feed

Khalid Abuhakmeh © 2022 .
Powered by Jekyll.

Back to top

Explore Site

  • Office Hours
  • Resumé
  • About
  • 🔍 Search

About Khalid Abuhakmeh

Khalid is a product designer, traveler, respected community member, and open source contributor.

Recent Articles

  • May 24, 2022
    Get Tweet Engagements Using .NET and C#
    Get Tweet Engagements Using .NET and C#
  • May 17, 2022
    Using SQL Server Cursors with Entity Framework Core
    Using SQL Server Cursors with Entity Framework Core
  • May 10, 2022
    Using ASP.NET Core MVC Value Providers With Minimal APIs
    Using ASP.NET Core MVC Value Providers With Minimal APIs

Tags

HTML JavaScript OpenAPI aspnet azure beginners blazor blog console csharp css database development docker dotnet entity-framework general github html htmx http javascript jekyll jetbrains kotlin macOS machine-learning mobile mvc oss question razor regex ruby search sql sqldockerdotnet static terminal tips twitter xamarin