.net core or MVC using entity framework execute Raw SQL Queries, select, insert, update and delete.

Execute Raw SQL Queries in Entity Framework. In ado.net we know we directly apply queries in C# code, so in entity framework mostly we all are use LINQ or lambda expression queries, but still, sometimes we need to add custom SQL Queries. use using the below code you can achieve that. Eg: our table name … Read more

All Countries States or Provinces database SQL server Data query for creating Country table and State table.

All Countries States or Provinces database SQL server Data query for creating the Country table and State table. Country Table Schema Country Table Data State or Province Table Schema State or Province Table Data

How to use Lamar in ASP. Net core web application or Web API

In this article, we will learn How to use Lamar in ASP. Net core web application or Web API. Why we use Lamar to implement dependency injection: There are lots of dependency injection containers in the .Net technology. The biggest disadvantage is the performance problem. The Lamar in this article is very lightweight and provides … Read more

Resolve SQL Server Identity Jumping 1000 Issue, resolve with DENTITY_CACHE

In SQL Server time we faced an issue with the Identity field, It directly jumps with 1000 numbers. So in this article, we resolve this issue. What to do suppose your last entry put with Jumped value. Copy your last row data somewhere in notepad Remove last row The above code will reset your seed … Read more

Compare – Lenovo Tab M10 vs Samsung Galaxy Tab A 10.1

Lenovo Tab M10 Samsung Galaxy Tab A 10.1 Performance Snapdragon 450 Samsung Exynos 7 Octa Network 4G: Available (supports Indian bands), 3G: Available, 2G: Available 4G: Available (supports Indian bands), 3G: Available, 2G: Available Display 10.1″ (25.65 cm) 10.1″ (25.65 cm) Camera 5 MP 8 MP Battery 4850 mAh 6150 mAh Operating System Android v8.1 … Read more

HttpContext Access in outside of framework another class library services .NET CORE

Issue: We do not have access to HttpContext outside of Controller, Base Controller, and Middleware, But some time we need that in services or another Class library for access Headers or any other thing. So just look at how to achieve it. Add IHttpContextAccessor in Startup.cs file 2. Then simply on which service you would … Read more

.net core implements JWT Token with Razor pages | Plus solve early logout issue

Problem: If we use claims with cookies authentication, when we host to shared hosting or some other side then its IIS server log out earlier while we applied session time out or idle time out Secondly, we will learn how to use JWT Token with Razor pages, so both things will be achieved with this … Read more