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
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
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 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
Sometimes I have to translate lots of words to another language for localization labels, so one by one I copy and paste it on google translater and put in code. now I create API and build logic so that I can put directly labels where I want. Use the below code.
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
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
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