As for existing SQL Server Install EF first: dotnet tool install global dotnet ef Prepare a clean .NET project: [email protected] MINGW64 /Desktop $ mkdir Temp [email protected] MINGW64 /Desktop $ cd Temp/ [email protected] MINGW64 /Desktop/Temp $ dotnet new console Getting...
We already know how to add data to database. That's simple: dbContext.MyDbSet.Add(myObject); But there may already exists some data in the database. We need to delete the obsolete data, and try to add the missing data. For example, I have some numbers: 1, 1, 2, 2, 3, 3 While in t...
Only get the row you need And the key reason for your slow query is it outputs too much data. Consider adding: Take(200) , Skip() to take only the data you need or the current page requires. Use a pager to generate the report. This might helps a lot. Consider the following code (...
Soft deletion feature is important in some cases that you need a second step to delete the data in your database. When you first delete it from your C LinQ query, the data will only be marked as Deleted but not delete in your database. Multi tenancy is one of the ASP.NET boilerpl...
Multi tenant requires many features because the data can be separated by different tenants. So when you are accessing the database, you don't need to worry that your operation will affect other tenants. Multi tenancy is the ASP.NET boilerplate's most important feature and works p...
If your ASP.NET Core project is connecting to your database via entity framework, you can't be unfamiliar with the script: dotnet ef database update . Without executing the script your database is not the latest and this may cause some issues. Traditionally we update the database...
Why do we need to do that? In case you ruined your code or you have too many migrations and caused your editor slow, you may want to reset all migrations. However, deleting all migrations directly in your code will cause database update fail. So I will talk about my solution abou...