Joschi
Dictionary translation
You could start by assuming bold text is english and non bold text the translation.
But this will break on declinations like kneel, knelt and so on and also an plurals like knavery.
You could then try to do more passes detecting and handling as many edge cases as possible.
But somehow I don't think you will get around having to clean up your data manually in the end.
8 replies
What return method is appropriate for controller actions for SPA frontend?
You should return the most appropriate http response.
For a post request that created some resource that would be 201 Created.
https://ochzhen.com/blog/created-createdataction-createdatroute-methods-explained-aspnet-core
For delete endpoints you could just return a 200 OK or maybe 204 No Content
3 replies
✅ EFCore fetching all data in nearly all tables after a single insert
We found the problem today.
As one may expect it was not directly related to the implicit operator. That was just a fluke / not fully rebuilding as it seems.
The problem occurred, when the operation threw a DBUpdateException. Which then lead Serilog.Exceptions to reflect and deserialize the complete DBContext.
Which of course itterated over all datasets, fetching the entire database.
But all this happened, before it even logged that an UpdateError occurred or the exception bubbled to the top, which made it hard to find.
That's a known problem and Serilog.Exceptions.EfCore provides a destructerer, which seemingly needs to be set explicitly in code.
18 replies
✅ EFCore fetching all data in nearly all tables after a single insert
No the project is sadly not public.
- It is always happening.
- I hope I find some time to test this.
- It takes in a DTO, converts it to the db model, saves it to the db and returns the newly saved object back to the controller, but we don't reach that point.
18 replies
✅ EFCore fetching all data in nearly all tables after a single insert
The observation being the correct
INSERT command being generated and send to the DB first, followed by a series of SELECT [x].Property... (all the properties of the given table) FROM [DB].[TABLE] AS [x] statements without any parameters.
We know it is really send back to the client, because we discovered some malformed data in our tables thanks to some EFCore Converter crashing in the process of converting the database value. And also the RAM constantly going up.18 replies