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

Generate Azure Function Keys using Key management API

In this article we easy to know how to generate Azure Function Keys of any function using Post Man. After postman hit you can easy to achieve it in rest sharp or any HTTP hit in your C#, PHP, or any programming language. Using post man find your Host _master key from azure portal, Go … Read more

SQL Server table reset seed | RESEED | reseed table data

Some time table identity value comes wrong sake of we delete manual entries, we added wrong data in edit mode or it takes next value of identity or some time automatically comes. So in this case many developer are delete data or re-design to table structure (schema). No need to do this you just clear … Read more

Where clause on json data in SQL Server | JSON_VALUE

A very rare example of this. But I find out suppose you have a list of key values, or you want to search value corresponding of the key, you will pass key and get the value of that from JSON list. Using the below example you can easy to achieve this. I have this json … 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

Time in India vs Saudi Arabia | IST vs KSA

We will show you list of time IST vs SKA. Saudi Arabia time is 2:30 hrs behind India. 0:00 AM (0:00) IST == 9:30 PM (21:30) previous day KSA0:30 AM (0:30) IST == 10:00 PM (22:00) previous day KSA1:00 AM (1:00) IST == 10:30 PM (22:30) previous day KSA1:30 AM (1:30) IST == 11:00 PM (23:00) previous day KSA2:00 AM (2:00) IST == 11:30 PM (23:30) previous day KSA2:30 AM … Read more

Using SQL query removes all tables data with schema | stored procedures | views | indexes

Rather then delete one by one remove all data and schema from database using single SQL query. Mostly on shared hosting where we are not able to check SQL server database and table views because of SQL server version, sometimes our SQL version is low or some time they version is high. So we are … Read more