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

SQL Server recursive query, Which returns all ancestors of an item

We will create a recursive query when getting data as per parent and its level. Mostly we use this query in MLM software (Multilevel marketing software). Using this you can easy to get who is my parent till the level we wanted to find. for more info follow this URL: https://stackoverflow.com/questions/16749095/sql-recursive-query-that-gets-all-ancestors-of-an-item Create new stored procedure … Read more

Solved: Laravel CSS js not loading 404 not found

When we create a new project in laravel php framework, at that time when we create a new layout or direct pages, Sometimes CSS or js are not loaded from the resources folder. So simply we need to move all static CSS, Js to public folder then to do this code. Use like this but … Read more

Push Notifications with App Center, android app.

How to implements push notification in xamarin forms using google firebase and app center | explain all step by step. How to implements push notification in xamarin forms using google firebase and appcenter You can follow below link to integrate application. https://console.firebase.google.com https://appcenter.ms/

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