Welcome to Software Development on Codidact!
Will you help us build our independent community of developers helping developers? We're small and trying to grow. We welcome questions about all aspects of software development, from design to code to QA and more. Got questions? Got answers? Got code you'd like someone to review? Please join us.
Posts by Alexei
I have recently contributed to a Clean Code project and had a discussion about how to implement unit tests. The project author argues for using an in-memory database (which easily replaces the rea...
This answers your questions, not what I suspect to be real issue. According to the specifications a VARCHAR(100) will need actual data stored length + 1. So, the actual size would have mattered if...
I have recently started a project based on the clean architecture principle and noticed that it did not rely on generic repositories since Entity Framework's DbSets are doing the job just fine. In ...
Migrations are applied during the application startup (initialization) only when the application is not accessible yet. One way to go is to leave the existing user as it is and define a designated ...
I have decided to convert a legacy database-first ASP.NET Core project to code-first. However, I have noticed that the project used the same database as another bigger project and the Entity Framew...
This is possible in two steps by using a dynamic SQL: SET @nextId = (SELECT MAX(id) + 1 FROM `CustomTable` ); SET @sql = CONCAT('ALTER TABLE `CustomTable` AUTO_INCREMENT = ', @nextId[]()); PREPA...
According to the documentation for the MySQL IN function: The number of values in the IN() list is only limited by the max_allowed_packet value. The default value for it is 67108864. So, you...
Note: this was tested in a .NET Framework 4.6.2 project. This answer provides an extension method that greatly simplifies (and makes it more intuitive) the written code: public static IQueryable&...
I am interested in performing a LEFT JOIN using LINQ-2-SQL when working with method call notation. This answer suggests a way that relies on GroupJoin but it is more verbose than expected: var le...
ghost-in-the-zsh provided a direct answer and I will try to offer a more general complementary one. One possible thing to try is a trigger that checks the integrity, but it cannot work for insert...
I can't say that I fully understood what you did, but I think I got the explanation: removed 1+ columns that were part of the index. The index will be updated to not include that column. If...
During my review of the posts and tags, I have seen the tools tags. It is very generic and I am sure if it is helpful. What do you think?
One way to solve this without customizing the Swagger UI is to deal with it on the server side. The following assumes that the swagger docs is served at /swagger relative path. Middleware /// <...
I have added Swagger UI for an ASP.NET Core 3.1 application and I have realized that all endpoints requiring Windows Authentication fail. This issue is created by the fact that generated HTTP reque...
Already good answers, but I can provide a slightly different perspective here: always use braces if there is a risk of getting into a pitfall. Examples (from C#, but the language is less relevant)...
I can provide an answer based on Stack Overflow experience. SO offered watches by tags. By using a general tag along with a more specific tag, users interested in [sql] will also get the question i...
One way to solve this is to shrink the database and reindex all tables to fix the indexes fragmentation: DBCC SHRINKDATABASE (TheDatabase); GO -- reindexing all tables to optimize performance ...
My project has the following set up for the production and preproduction ("clone") environment. Production is not accessible at all for the development team, only the preproduction database. Pr...
This heavily relies on this question which deals with another matter. In order to delay the loader, there must be a clear difference between the start of loaded from the caller's perspective and w...
I am working on an Angular application using ngrx and I have a loader state + reducer that is used to display a loader. However, very short AJAX calls cause a flicker and I need to delay showing th...
Comments from this question reveal that there is some aggressive caching related to question tags (what tags are used for a question). Unfortunately, after changing tags for several questions I ha...
Thanks for raising this question. My answers to your questions: What type of tags will we allow? (Should specific tags like [UrlRewrite] be allowed?) I am not sure what is the best way to deal wi...
My notification list includes the following entry: New answer to your question 'How many votes are required for special actions...' However, there is no answer for that question. I imagine that ...
We currently have quite a few questions tagged with formula. However, [formula] seems so general that I am inclined to replace it to a more specific formula based on the context. Examples: [excel-...
I will provide an answer from a pragmatic perspective, rather than a direct answer to your question. This is particularly important when working on a real project (as opposed to homework). Short an...