How to Improve Entity Framework Performance

As you know by default Entity framework is not giving Performance, Always we need to tune up as per our requirements. But there are a lot of things which must we need to keep in mind when we use EF. Disable change tracking for the entity if not needed: whenever you retrieve the data only … 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

Resolved: Entity Framework .net 5 core rename to table column | alter rename column in .net core EF.

The issue was supposed we have one User table and it has some columns like Id, FirstName, Surname, PhoneNumber, or Email. There we wanted to Rename Surname to LastName. The problem occurs when we will run migration after the above Change. It will not make rename or alter to the column, It will Drop to … Read more

How to use Entity Framework Migrations | Code First approach | .net core MVC code first

Summary: As you know in the Entity framework we have many ways to connect with the database from our application. We are using their Model first approach, Database first approach, and Code First approach.All approaches have different ways to use or Different requirement to use. The main thing is why we use this or which … Read more

Difference between .NET Standard, .NET Core, and .Net Framework Class Libraries?

As you know when the .net core was launch from that time we have a .net core, net Standard new libraries are available in vs. .net framework class library is old one which having .net framework 3.5, 4.0, 5,6 etc. .net core class library is totally we using for .net core projects. .net standard having … Read more

Solved: jQuery issue Adding a new array element to a JSON object

Issue: Some time we had some data in the JSON list, we wanted to add a new element list inside that JSON list, so using this article we can easy to learn how to do it or you can also implement your side. For more info follow this link also. https://stackoverflow.com/questions/18884840/adding-a-new-array-element-to-a-json-object/63230031#63230031

Solved: jQuery datatable server-side processing .net Core

Issue: In .net core when you create data grid by using jQuery datatable, directly its not working because of our model property names, we need to setup in startup.cs. you can follow this code. Do in Startup.cs file on return data if you are use camelCase then use this. if you are use pascal case … Read more

What is best SQL datatype for storing JSON string

Why we need: As you know some time we need to store JSON directly in database , Right now In SQL server there is no specific datatype available for JSON, we need to store that in nvarchar(max). In entity framework we can get record while we select from database , In Model we need Json … Read more