search

Entity Framework Core (EF) converts expressions into SQL at runtime. In earlier versions, it was straight forward to get the SQL. In Entity Framework Core 3, you must access the SQL using ILogger. This article explains how to access the SQL generated and gives some example code to access the output of queries made behind the scenes. This article works with Entity Framework Core 3.

Bharat Dwarkani shared on Jul 21, 2020
image
christianfindlay.com
bookmarks
share
visibility9
visibility9 share bookmarks

RepoDb is a new hybrid micro-ORM library for .NET, designed to cater the missing pieces of micro-ORMs and macro-ORMs

Bharat Dwarkani shared on Jul 18, 2020
image
link.medium.com
bookmarks
share
visibility25
visibility25 share bookmarks

This article presents an alternate way for standard filtering with Where LINQ extension. The result is query has similar performance (perhaps slightly better). But the most important, it doesn’t time out due too many filter parameters.

Bharat Dwarkani shared on Jul 13, 2020
image
lukaszcoding.com
bookmarks
share
visibility11
visibility11 share bookmarks

Easy and optimized way to apply Filtering, Sorting, and pagination using text-based data.

AliReZa Sabouri shared on Jul 03, 2020
image
alirezanet.github.io
bookmarks
share
visibility41
visibility41 share bookmarks

Using ORM for database related work is a common practice in applications developed in the last decade. There are many popular ORM’s. One of the most common ORM’s in the .NET world is Entity Framework.

Bharat Dwarkani shared on May 27, 2020
image
medium.com
bookmarks
share
visibility19
visibility19 share bookmarks

In this article, we are going to create a web application using ASP.NET Core and React.js with the help of the Entity Framework Core database first approach. We will be creating a sample Employee Record Management system and performing CRUD operations on it. To read the inputs from the user, we are using HTML Form elements with required field validations on the client-side. We are also going to bind a dropdown list in the HTML Form to a table in the database using EF Core.

Bharat Dwarkani shared on May 13, 2020
image
medium.com
bookmarks
share
visibility14
visibility14 share bookmarks

So you're a dotnet developer and you've heard the hype surrounding graphql, and you think "oh yeah, I just HAVE to try this!". Well prepared to be deeply underwhelmed.

Aambharat shared on Mar 15, 2020
image
dev.to
bookmarks
share
visibility161
visibility161 share bookmarks

Health check are important, both of our selves, but also of ourrrrr micro-services. This is something I came across lately – a health check of your connection to a database via EF Core context. Let’s check this out!

Bharat Dwarkani shared on Mar 15, 2020
image
michalbialecki.com
bookmarks
share
visibility20
visibility20 share bookmarks

Often you might be interested in knowing how your LINQ Queries are translated to SQL Database in behind. The best way to profile ASP.NET Core, Entity Framework LINQ queries running on Azure SQL/ On-Premise SQL is to use Azure Data Studio.

Bharat Dwarkani shared on Feb 15, 2020
image
link.medium.com
bookmarks
share
visibility21
visibility21 share bookmarks

LINQ is a powerful querying tool for .NET applications. There are certain techniques to follow when writing queries to make sure they run quickly and effectively. The following are a few things to consider when aiming to improve the performance of LINQ to Entities.

Bharat Dwarkani shared on Dec 17, 2019
image
syncfusion.com
bookmarks
share
visibility36
visibility36 share bookmarks
add