Azure SQL uses a layered firewall model:
When to use each:
Example:
Reference: Rishan Digital – Firewall Rules and Authentication
Firewall rules in Azure SQL Database control which IP addresses can connect to your database server. Configuring these rules correctly ensures that only trusted users and applications access your data while keeping it secure from unauthorized traffic.
Azure provides two levels of firewall configuration: server-level and database-level rules. Server-level rules allow access to all databases under a logical server, while database-level rules apply only to a specific database.
You can configure firewall rules using the Azure Portal, Transact-SQL (T-SQL) commands, or PowerShell. Understanding how and where to apply these rules helps ensure a secure and flexible environment for managing database access.
When creating API endpoints in ASP.NET Core, you often need to ensure only authenticated users can access certain actions.
The [Authorize] attribute makes this easy — it automatically blocks unauthenticated requests.
Sometimes, you also load the current user from a database or a user service. In this case, it’s a good practice to add a null check as an extra safety step, even if [Authorize] is already applied.
Example
[Authorize]
[HttpPost("DoSomething")]
public async Task<IActionResult> DoSomething(RequestModel request)
{
var user = await userService.GetContextUserAsync();
if (user == null)
{
// Safety check in case the user is authenticated but not found in the database
return Unauthorized("User not found.");
}
// Continue with the action
return Ok("Action completed successfully.");
}Key Ideas
[Authorize] ensures only authenticated users reach your action.if (user == null) check.This pattern keeps your API safe, clean, and reliable.
When building forms in React, sometimes you want one field to copy values from another field — but only if it is still empty. For example, you may want a mediaContentUrl field to auto-fill with the same value a user types in another field.
A common problem is that after the first letter, the mediaContentUrl field is no longer "empty," so it stops updating. The trick is to keep syncing while it matches the other field, and stop once the user edits it directly.
Here’s a simplified fix you can use inside your change handler:
setFormValues(prev => {
const updated = { ...prev, [name]: value, mediaFile: null };
// Only sync if mediaContentUrl is empty
// or still the same as the field being typed
if (name !== "mediaContentUrl") {
const prevField = String(prev[name] ?? "");
const prevMedia = String(prev.mediaContentUrl ?? "");
if (!prevMedia || prevMedia === prevField) {
updated.mediaContentUrl = value;
}
}
return updated;
});This way, the mediaContentUrl field will auto-fill until the user changes it, and then it stops syncing.
In .NET applications, it’s common to have multiple classes that share the same interface or base class. Instead of registering each class manually in the Dependency Injection (DI) container, you can register them all automatically by scanning the assembly.
Here’s a simple example:
var serviceTypes = typeof(IServiceBase)
.Assembly
.GetTypes()
.Where(t =>
typeof(IServiceBase).IsAssignableFrom(t) &&
!t.IsAbstract &&
!t.IsInterface);
foreach (var type in serviceTypes)
{
services.AddSingleton(typeof(IServiceBase), type);
}
// If you also need a concrete type directly
services.AddSingleton<SpecialService>();
// Example: register a factory or manager
services.AddSingleton<IServiceFactory, ServiceFactory>();This pattern ensures:
IServiceBase are available through IEnumerable<IServiceBase>.When registering services, you must decide how long they should live in your application:
General advice:
Choosing the right lifetime prevents resource leaks, avoids threading issues, and makes your application more reliable.
How to Convert Dictionary Keys into a Comma-Separated String in C#
When working with a Dictionary<string, object> in C#, you may need to get all the keys as a single string. This can be done easily using the built-in string.Join method.
Here’s a simple example:
var dict = new Dictionary<string, object>
{
{ "Name", "Alice" },
{ "Age", 30 },
{ "Country", "USA" }
};
string keys = string.Join(",", dict.Keys);
Console.WriteLine(keys); // Output: Name,Age,Countrydict.Keys gives you the collection of keysstring.Join combines them with commasThis approach is clean, fast, and works well for logging, debugging, or exporting keys.
If you're upgrading your home internet, Wi-Fi 7 mesh systems promise blazing speeds, lower latency, and better performance in busy, device-packed households. This video breaks down the top 5 options available now, balancing speed, coverage, and value.
Highlights:
Whether you're streaming, gaming, or building a smart home, there’s a system on this list that fits your needs and budget.
If the built-in Stereo Mix method is unavailable or insufficient:
These alternatives offer additional flexibility for managing multiple audio outputs.
Wi-Fi 7 mesh systems are the next big thing in home networking, offering ultra-fast speeds, better range, and improved connectivity for demanding households. This comparison breaks down five top contenders: TP-Link Deco BE85 & BE95, ASUS BQ16 Pro, Eero Max 7, and Netgear Orbi 970.
Each system supports up to 10Gbps speeds and offers mobile apps for setup. However, ASUS stands out with advanced settings and no added fees for features like parental controls or security.