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 to add health checks to a rather new application (Web API, not a microservice) and I and a colleague are not agreeing about what other systems I should include in the check. This application...
Entity Framework is able to save the changes by using a tracking mechanism (i.e. what is added, deleted, removed). I guess _repository.GetAllGoals() implementation is something like _context.Goals...
I tried to replicate your case and the only workable solution I could find is to use OnModelCreating configuration (fluent style) instead of attributes: public class Contestant { public int Id...
This question which is tagged with table tag. I am trying to find a better replacement for it since there are multiple types of tables such as HTML tables or data tables. The question seems to re...
One faster alternative is to use a formula to create the hyperlink. An example is provided below: public static IXLCell SetHyperLink(this IXLCell cell, string url, string text = "link") { if (s...
I am using ClosedXML library to generate an Excel containing thousands of hyperlinks using cell's Hyperlink property: cell.SetValue(text).Hyperlink = new XLHyperlink(url); Such a call takes abo...
If you are using .NET Core 5.0 or more you should be able to write something like the following (not tested): var data = context.TblOrder .OrderBy(o => o.OrderDate) .Select(o => ne...
One way to do this is to launch a Task at application startup as soon as possible (the DI is configured). The only hard part is to make DI available in the prewarm functionality. The following imp...
I am caching some very static information (changes once per day) in my ASP.NET Core application. This is normally done when needed ("lazy"). One such cache item is a 50K list of items that are tak...
Besides the aforementioned solutions, Web components might be useful (can be reused in multiple contexts). Examples: in Drupal in ButterCMS in Backdrop CMS in WordPress However, if your fo...
I have recently an issue at work after upgrading an ASP.NET Core 3.1 application to .NET 5. It worked correctly on all environments (e.g. PreProd, Prod) when targeting 3.1, but failed on Prod only ...
Before posting this on the help pages, I will compile the feedback in a separate answer. Generally speaking, comments should be helpful feedback and the following are not exhaustive lists. Can in...
I want to conditionally disabled or not (enabled) a bunch of reactive form controls. However, I have noticed that neither enable or disable function has a boolean parameter to nicely conditionally ...
First of all, it seems that Mysql does not allow to disable triggers. One way would be to set a session variable which can be checked in each trigger. This still incurs some overhead (trigger is st...
I am currently dealing with an Angular application that is being deployed using an CI orchestrator and Jenkins. Jenkins job is configured to do the following (relevant steps only): fetch source...
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 ...
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...
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...
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...
I want to use LazyCache and UnityContainer together in an ASP.NET classic application (.NET framework 4.6.1+). Namely, to be able to inject IAppCache in various services. For ASP.NET Core and its d...
This is an unanswered code review request of mine from Code Review Stack Exchange. Overview I have developed a small ASP.NET Core 3.1 Web API that provides information that is rarely changed (sever...
The reference indicated by jcsahnwaldt indeed specifies the space required by VARCHAR columns, namely (L = string length): L + 1 bytes if column values require 0 − 255 bytes, L + 2 bytes if valu...
After toying a little more with Delete actions for referentials, I think the rational of having the CASCADE DELETE as default is the following: having to DELETE the children before the parent is ...
I have noticed some time ago that Entity Framework assumes a CASCADE behaviour (implicit value, if not specified) for referential constraints (FKs) when deleting items. This means that by default, ...
