How do I view the SQL generated by the Entity Framework(ef) on C# on debugging mode You can try these three ways. in EF6 in EF6.3+
How to get the compressed and uncompressed backup script in SQL Server Uncompressed Backup Compressed Backup If you want to restore backup then go ahead.
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
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
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
Using this query you can easy to track that, Which running SQL Query is taking extra time or load, check reads and writes. Output will be. Query
Using this query you can easy to get all primary keys of from all tables of current database. Output will be like this.
Using this query we can easy to check all relationships in current Database. We have 2 different queries you can find below. Example picture this there. 1st Query 2nd Query
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
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